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

Surnames > P > PA > PAF

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
PA PAA PAB PAC PAD PAE PAF PAG PAH PAI PAJ PAK PAL PAM PAN PAO PAP PAQ PAR PAS PAT PAU PAV PAW PAX PAY PAZ

Full Surname List Starting with PAF(Alphabetical)

PAFF
PAFFEL
PAFFENROTH
PAFFHAUSEN
PAFFORD
PAFFRATH
PAFUMI
PAFUNDI

Top 100 Surnames in the 2010 US Census starting with PAF

SurnameCountRankWiki?
PAFFORD 1585 17699 no
PAFF 1027 24388 no
PAFFRATH 253 76029 no
PAFFENROTH 207 89403 no
PAFUNDI 177 101737 no
PAFUMI 164 108199 no
PAFFEL 163 108734 no
PAFFHAUSEN 114 145220 no