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

Surnames > S > SY > SYA

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
SY SYA SYB SYC SYD SYE SYF SYH SYK SYL SYM SYN SYP SYR SYS SYT SYV SYX SYZ

Full Surname List Starting with SYA(Alphabetical)

SYAL
SYAS

Top 100 Surnames in the 2010 US Census starting with SYA

SurnameCountRankWiki?
SYAS 283 69392 no
SYAL 194 94311 no