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

Surnames > P > PU > PUP

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

PUPA
PUPEK
PUPELLO
PUPILLO
PUPO
PUPP
PUPPALA
PUPPE
PUPPO

Top 100 Surnames in the 2010 US Census starting with PUP

SurnameCountRankWiki?
PUPO 1594 17625 no
PUPILLO 371 55386 no
PUPPO 254 75799 no
PUPA 248 77264 no
PUPPE 205 90113 no
PUPPALA 197 93125 no
PUPEK 174 103181 no
PUPP 144 120187 no
PUPELLO 134 127494 no