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

Surnames > E > EF > EFF

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
EFA EFE EFF EFI EFL EFR EFS EFT EFU

Full Surname List Starting with EFF(Alphabetical)

EFF
EFFA
EFFENBERGER
EFFENDI
EFFERSON
EFFERTZ
EFFINGER
EFFIONG
EFFLAND
EFFLANDT
EFFLER
EFFNER
EFFORD
EFFRON

Top 100 Surnames in the 2010 US Census starting with EFF

SurnameCountRankWiki?
EFFINGER 1596 17605 no
EFFLER 936 26143 no
EFFERTZ 550 39887 no
EFFERSON 465 45886 no
EFFRON 371 55386 no
EFFORD 243 78567 no
EFFNER 237 80131 no
EFFLAND 199 92358 no
EFFENBERGER 186 97671 no
EFFENDI 175 102688 no
EFF 140 123064 no
EFFA 136 126018 no
EFFIONG 132 129047 no
EFFLANDT 114 145220 no