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 = 'NY' order by rank asc limit 0,100 Surnames > N > NY > NYE

Surnames > N > NY > NYE

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
NY NYA NYB NYC NYD NYE NYF NYG NYH NYI NYK NYL NYM NYO NYP NYQ NYR NYS NYT NYU NYZ

Full Surname List Starting with NYE(Alphabetical)

NYE
NYEGAARD
NYEHOLT
NYEIN
NYEN
NYENHUIS
NYER
NYERGES
NYERS
NYESTE

Top 100 Surnames in the 2010 US Census starting with NYE

SurnameCountRankWiki?
NYE 12167 2952 no
NYENHUIS 560 39281 no
NYERS 153 114424 no
NYER 144 120187 no
NYERGES 141 122314 no
NYEIN 123 136449 no
NYEN 120 139228 no
NYEGAARD 119 140157 no
NYEHOLT 117 142108 no
NYESTE 103 157234 no