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

Surnames > H > HA > HAP

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
HA HAA HAB HAC HAD HAE HAF HAG HAH HAI HAJ HAK HAL HAM HAN HAO HAP HAQ HAR HAS HAT HAU HAV HAW HAX HAY HAZ

Full Surname List Starting with HAP(Alphabetical)

HAP
HAPE
HAPEMAN
HAPER
HAPES
HAPGOOD
HAPKA
HAPKE
HAPNER
HAPNEY
HAPP
HAPPE
HAPPEL
HAPPENY
HAPPER
HAPPLE
HAPPOLD
HAPPOLDT
HAPPS
HAPPY
HAPTONSTALL

Top 100 Surnames in the 2010 US Census starting with HAP

SurnameCountRankWiki?
HAPPEL 1854 15727 no
HAPP 1172 22095 no
HAPNER 687 33280 no
HAPPE 683 33410 no
HAPPY 598 37288 no
HAPGOOD 454 46811 no
HAPEMAN 435 48530 no
HAPKE 410 50851 no
HAPTONSTALL 273 71478 no
HAPKA 209 88685 no
HAPER 190 95955 no
HAPNEY 175 102688 no
HAPPLE 174 103181 no
HAPE 153 114424 no
HAPPER 147 118185 no
HAPPOLD 136 126018 no
HAPPENY 126 133863 no
HAPPOLDT 122 137327 no
HAPPS 122 137327 no
HAPES 112 147253 no
HAP 100 160975 no