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 > PYS

Surnames > P > PY > PYS

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 PYS(Alphabetical)

PYSH
PYSHER
PYSKATY
PYSZ
PYSZKA

Top 100 Surnames in the 2010 US Census starting with PYS

SurnameCountRankWiki?
PYSHER 530 41100 no
PYSZKA 238 79846 no
PYSZ 185 98099 no
PYSH 119 140157 no
PYSKATY 109 150452 no