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

Surnames > Z > ZI > ZIF

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

ZIFF
ZIFFER
ZIFKO

Top 100 Surnames in the 2010 US Census starting with ZIF

SurnameCountRankWiki?
ZIFF 535 40800 no
ZIFFER 183 98982 no
ZIFKO 100 160975 no