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

Surnames > P > PY > PYR

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

PYRA
PYRAH
PYRAM
PYREK
PYRITZ
PYRON
PYRTLE
PYRYT
PYRZ

Top 100 Surnames in the 2010 US Census starting with PYR

SurnameCountRankWiki?
PYRON 1672 16993 no
PYRTLE 410 50851 no
PYRYT 125 134712 no
PYREK 125 134712 no
PYRAM 122 137327 no
PYRZ 121 138304 no
PYRITZ 116 143149 no
PYRA 115 144141 no
PYRAH 106 153769 no