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

Surnames > Z > ZI > ZIG

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

ZIGA
ZIGAN
ZIGICH
ZIGLAR
ZIGLER
ZIGMAN
ZIGMOND
ZIGMONT
ZIGMUND
ZIGNEGO
ZIGO
ZIGRANG
ZIGROSSI

Top 100 Surnames in the 2010 US Census starting with ZIG

SurnameCountRankWiki?
ZIGLER 2019 14713 no
ZIGLAR 976 25356 no
ZIGA 308 64559 no
ZIGMAN 304 65244 no
ZIGAN 287 68547 no
ZIGMOND 279 70208 no
ZIGMONT 241 79075 no
ZIGO 191 95545 no
ZIGNEGO 179 100791 no
ZIGMUND 130 130610 no
ZIGICH 129 131379 no
ZIGRANG 126 133863 no
ZIGROSSI 113 146201 no