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

Surnames > N > NO > NOJ

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

NOJ
NOJI
NOJIMA
NOJIRI

Top 100 Surnames in the 2010 US Census starting with NOJ

SurnameCountRankWiki?
NOJIMA 180 100302 no
NOJI 141 122314 no
NOJIRI 117 142108 no
NOJ 115 144141 no