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

Surnames > P > PU > PUI

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

PUIA
PUIG
PUIH

Top 100 Surnames in the 2010 US Census starting with PUI

SurnameCountRankWiki?
PUIG 2198 13764 no
PUIA 161 109758 no
PUIH 116 143149 no