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 > NOK

Surnames > N > NO > NOK

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 NOK(Alphabetical)

NOKE
NOKES
NOKLEBY

Top 100 Surnames in the 2010 US Census starting with NOK

SurnameCountRankWiki?
NOKES 1918 15303 no
NOKLEBY 151 115639 no
NOKE 148 117480 no