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

Surnames > P > PY > PYE

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
PY PYA PYB PYC PYE PYF PYG PYK PYL PYM PYN PYO PYP PYR PYS PYT PYU PYY PYZ

Full Surname List Starting with PYE(Alphabetical)

PYE
PYEATT
PYER
PYERS
PYETT

Top 100 Surnames in the 2010 US Census starting with PYE

SurnameCountRankWiki?
PYE 3743 8763 no
PYEATT 790 29768 no
PYERS 232 81458 no
PYER 180 100302 no
PYETT 115 144141 no