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

Surnames > N > NO > NOY

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

NOY
NOYA
NOYCE
NOYD
NOYE
NOYER
NOYES
NOYOLA

Top 100 Surnames in the 2010 US Census starting with NOY

SurnameCountRankWiki?
NOYES 9710 3666 no
NOYOLA 4279 7759 no
NOY 653 34618 no
NOYCE 640 35203 no
NOYA 486 44270 no
NOYER 359 56836 no
NOYD 312 63873 no
NOYE 305 65066 no