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

Surnames > Z > ZO > ZOG

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
ZOB ZOC ZOD ZOE ZOF ZOG ZOH ZOI ZOK ZOL ZOM ZON ZOO ZOP ZOQ ZOR ZOS ZOT ZOU ZOV ZOZ

Full Surname List Starting with ZOG(Alphabetical)

ZOGBY
ZOGG
ZOGHBI
ZOGHBY
ZOGLIO
ZOGLMAN
ZOGLMANN
ZOGRAFOS

Top 100 Surnames in the 2010 US Census starting with ZOG

SurnameCountRankWiki?
ZOGG 456 46647 no
ZOGRAFOS 300 65964 no
ZOGBY 228 82613 no
ZOGLMAN 222 84463 no
ZOGLIO 183 98982 no
ZOGLMANN 175 102688 no
ZOGHBI 109 150452 no
ZOGHBY 109 150452 no