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 = 'HY' order by rank asc limit 0,100 Surnames > H > HY > HYR

Surnames > H > HY > HYR

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
HA HE HI HJ HL HM HN HO HR HS HT HU HV HW HY
HY HYA HYB HYC HYD HYE HYI HYJ HYK HYL HYM HYN HYO HYP HYR HYS HYT HYU HYV HYZ

Full Surname List Starting with HYR(Alphabetical)

HYRE
HYRKAS
HYRNE

Top 100 Surnames in the 2010 US Census starting with HYR

SurnameCountRankWiki?
HYRE 1056 23899 no
HYRKAS 191 95545 no
HYRNE 130 130610 yes