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

Surnames > P > PH > PHU

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
PHA PHE PHI PHL PHO PHR PHU PHY

Full Surname List Starting with PHU(Alphabetical)

PHU
PHUA
PHUN
PHUNG
PHUNTSOK
PHUONG
PHUYAL
PHUYEL

Top 100 Surnames in the 2010 US Census starting with PHU

SurnameCountRankWiki?
PHUNG 7155 4915 no
PHU 2230 13593 no
PHUONG 1355 19834 no
PHUN 310 64200 no
PHUA 163 108734 no
PHUYEL 147 118185 no
PHUNTSOK 142 121590 no
PHUYAL 102 158432 no