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 = 'ZY' order by rank asc limit 0,100 Surnames > Z > ZY > ZYL

Surnames > Z > ZY > ZYL

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
ZA ZB ZD ZE ZG ZH ZI ZL ZM ZN ZO ZR ZS ZU ZV ZW ZY
ZYB ZYC ZYD ZYG ZYK ZYL ZYN ZYS ZYW

Full Surname List Starting with ZYL(Alphabetical)

ZYLA
ZYLBERBERG
ZYLINSKI
ZYLKA
ZYLLA
ZYLMAN
ZYLSTRA

Top 100 Surnames in the 2010 US Census starting with ZYL

SurnameCountRankWiki?
ZYLSTRA 1842 15806 no
ZYLA 675 33731 no
ZYLKA 470 45495 no
ZYLINSKI 212 87663 no
ZYLLA 171 104602 no
ZYLBERBERG 123 136449 no
ZYLMAN 110 149395 no