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 = 'PU' order by rank asc limit 0,100 Surnames > P > PU > PUZ

Surnames > P > PU > PUZ

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
PA PE PF PH PI PJ PL PN PO PP PR PS PT PU PY
PU PUA PUB PUC PUD PUE PUF PUG PUH PUI PUJ PUK PUL PUM PUN PUO PUP PUR PUS PUT PUU PUV PUY PUZ

Full Surname List Starting with PUZ(Alphabetical)

PUZ
PUZA
PUZAK
PUZEY
PUZIO
PUZO
PUZON
PUZYCKI
PUZZO
PUZZUOLI

Top 100 Surnames in the 2010 US Census starting with PUZ

SurnameCountRankWiki?
PUZIO 901 26932 no
PUZZO 514 42237 no
PUZON 459 46404 no
PUZA 348 58337 no
PUZO 243 78567 no
PUZ 220 85049 no
PUZAK 182 99378 no
PUZEY 182 99378 yes
PUZZUOLI 122 137327 no
PUZYCKI 115 144141 no