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 = 'SU' order by rank asc limit 0,100 Surnames > S > SU > SUY

Surnames > S > SU > SUY

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
SA SB SC SD SE SF SG SH SI SJ SK SL SM SN SO SP SQ SR ST SU SV SW SY SZ
SU SUA SUB SUC SUD SUE SUF SUG SUH SUI SUJ SUK SUL SUM SUN SUO SUP SUQ SUR SUS SUT SUV SUW SUY SUZ

Full Surname List Starting with SUY(Alphabetical)

SUY
SUYAMA
SUYAT
SUYDAM

Top 100 Surnames in the 2010 US Census starting with SUY

SurnameCountRankWiki?
SUYDAM 1391 19425 no
SUY 518 41959 no
SUYAT 284 69170 no
SUYAMA 221 84748 no