select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'NO' order by rank asc limit 0,100 Surnames > N > NO > NOI

Surnames > N > NO > NOI

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
NA NC ND NE NG NH NI NJ NK NN NO NS NT NU NW NY NZ
NO NOA NOB NOC NOD NOE NOF NOG NOH NOI NOJ NOK NOL NOM NON NOO NOP NOR NOS NOT NOU NOV NOW NOX NOY NOZ

Full Surname List Starting with NOI(Alphabetical)

NOI
NOIA
NOICE
NOIL
NOIROT
NOISETTE
NOISEUX

Top 100 Surnames in the 2010 US Census starting with NOI

SurnameCountRankWiki?
NOIA 310 64200 no
NOISETTE 296 66754 no
NOICE 242 78821 no
NOIROT 180 100302 no
NOISEUX 172 104156 no
NOIL 119 140157 no
NOI 100 160975 no