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

Surnames > P > PU > PUY

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

PUYEAR
PUYLEART

Top 100 Surnames in the 2010 US Census starting with PUY

SurnameCountRankWiki?
PUYEAR 320 62531 no
PUYLEART 131 129825 no