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

Surnames > P > PI > PIF

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
PI PIA PIB PIC PID PIE PIF PIG PIH PII PIJ PIK PIL PIM PIN PIO PIP PIQ PIR PIS PIT PIU PIV PIW PIX PIZ

Full Surname List Starting with PIF(Alphabetical)

PIFER
PIFF
PIFFER
PIFHER
PIFKO

Top 100 Surnames in the 2010 US Census starting with PIF

SurnameCountRankWiki?
PIFER 3814 8623 no
PIFHER 231 81772 no
PIFFER 132 129047 no
PIFKO 121 138304 no
PIFF 112 147253 no