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

Surnames > P > PF > PFU

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
PFA PFE PFI PFL PFO PFR PFU

Full Surname List Starting with PFU(Alphabetical)

PFUHL
PFUND
PFUNDSTEIN
PFUNDT
PFUNTNER

Top 100 Surnames in the 2010 US Census starting with PFU

SurnameCountRankWiki?
PFUND 703 32676 no
PFUHL 297 66553 no
PFUNDSTEIN 197 93125 no
PFUNTNER 189 96368 no
PFUNDT 154 113791 no