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 = 'ER' order by rank asc limit 0,100 Surnames > E > ER > ERF

Surnames > E > ER > ERF

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
EA EB EC ED EE EF EG EH EI EJ EK EL EM EN EO EP EQ ER ES ET EU EV EW EX EY EZ
ER ERA ERB ERC ERD ERE ERF ERG ERH ERI ERJ ERK ERL ERM ERN ERO ERP ERQ ERR ERS ERT ERV ERW ERX ERZ

Full Surname List Starting with ERF(Alphabetical)

ERFANI
ERFE
ERFLE
ERFMAN
ERFORD
ERFOURTH
ERFURT
ERFURTH

Top 100 Surnames in the 2010 US Census starting with ERF

SurnameCountRankWiki?
ERFE 208 89069 no
ERFURTH 167 106570 no
ERFORD 164 108199 no
ERFANI 143 120901 no
ERFLE 140 123064 no
ERFURT 130 130610 no
ERFOURTH 127 133048 no
ERFMAN 117 142108 no