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

Surnames > H > HI > HIU

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
HI HIA HIB HIC HID HIE HIG HIJ HIK HIL HIM HIN HIO HIP HIR HIS HIT HIU HIV HIX HIY HIZ

Full Surname List Starting with HIU(Alphabetical)

HIU
HIURA

Top 100 Surnames in the 2010 US Census starting with HIU

SurnameCountRankWiki?
HIU 226 83226 no
HIURA 153 114424 no