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

Surnames > Z > ZU > ZUG

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
ZU ZUA ZUB ZUC ZUE ZUF ZUG ZUH ZUI ZUK ZUL ZUM ZUN ZUO ZUP ZUR ZUS ZUT ZUV ZUZ

Full Surname List Starting with ZUG(Alphabetical)

ZUG
ZUGAY
ZUGEL
ZUGELDER
ZUGER
ZUGG

Top 100 Surnames in the 2010 US Census starting with ZUG

SurnameCountRankWiki?
ZUG 330 60960 no
ZUGG 227 82908 no
ZUGAY 184 98553 no
ZUGEL 167 106570 no
ZUGELDER 158 111426 no
ZUGER 157 111988 no