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

Surnames > H > HT > HTU

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
HTA HTE HTO HTU HTW

Full Surname List Starting with HTU(Alphabetical)

HTUN
HTUT

Top 100 Surnames in the 2010 US Census starting with HTU

SurnameCountRankWiki?
HTUN 271 71886 no
HTUT 162 109258 no