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

Surnames > Z > ZY > ZYB

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

ZYBERT
ZYBURA

Top 100 Surnames in the 2010 US Census starting with ZYB

SurnameCountRankWiki?
ZYBURA 122 137327 no
ZYBERT 107 152628 no