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

Surnames > Z > ZI > ZIY

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
ZI ZIA ZIB ZIC ZID ZIE ZIF ZIG ZIH ZII ZIK ZIL ZIM ZIN ZIO ZIP ZIR ZIS ZIT ZIU ZIV ZIY ZIZ

Full Surname List Starting with ZIY(Alphabetical)

ZIYAD
ZIYADEH

Top 100 Surnames in the 2010 US Census starting with ZIY

SurnameCountRankWiki?
ZIYAD 208 89069 no
ZIYADEH 100 160975 no