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 = 'RY' order by rank asc limit 0,100 Surnames > R > RY > RYZ

Surnames > R > RY > RYZ

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
RA RC RE RH RI RM RO RU RY RZ
RY RYA RYB RYC RYD RYE RYF RYG RYH RYK RYL RYM RYN RYO RYP RYS RYT RYU RYV RYZ

Full Surname List Starting with RYZ(Alphabetical)

RYZA
RYZNAR
RYZNER

Top 100 Surnames in the 2010 US Census starting with RYZ

SurnameCountRankWiki?
RYZNAR 169 105600 no
RYZNER 169 105600 no
RYZA 114 145220 no