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

Surnames > S > SY > SYS

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

SYSAK
SYSAVATH
SYSKA
SYSKO
SYSLO
SYSOL
SYSTER
SYSWERDA

Top 100 Surnames in the 2010 US Census starting with SYS

SurnameCountRankWiki?
SYSLO 315 63373 no
SYSAK 259 74608 no
SYSKA 193 94730 no
SYSAVATH 147 118185 no
SYSKO 143 120901 no
SYSWERDA 120 139228 no
SYSOL 117 142108 no
SYSTER 103 157234 no