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

Surnames > Z > ZI > ZIK

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

ZIKA
ZIKAS
ZIKE
ZIKMUND
ZIKO
ZIKOS

Top 100 Surnames in the 2010 US Census starting with ZIK

SurnameCountRankWiki?
ZIKE 612 36525 no
ZIKA 538 40610 no
ZIKO 238 79846 no
ZIKMUND 204 90495 no
ZIKOS 141 122314 no
ZIKAS 100 160975 no