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

Surnames > N > NO > NOZ

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

NOZAKI
NOZAWA
NOZICKA

Top 100 Surnames in the 2010 US Census starting with NOZ

SurnameCountRankWiki?
NOZAKI 381 54178 no
NOZAWA 233 81181 no
NOZICKA 100 160975 no