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 = 'NE' order by rank asc limit 0,100 Surnames > N > NE > NEF

Surnames > N > NE > NEF

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
NA NC ND NE NG NH NI NJ NK NN NO NS NT NU NW NY NZ
NE NEA NEB NEC NED NEE NEF NEG NEH NEI NEJ NEK NEL NEM NEN NEO NEP NER NES NET NEU NEV NEW NEY NEZ

Full Surname List Starting with NEF(Alphabetical)

NEF
NEFF
NEFFENDORF
NEFT
NEFZGER

Top 100 Surnames in the 2010 US Census starting with NEF

SurnameCountRankWiki?
NEFF 22764 1577 no
NEFZGER 282 69579 no
NEF 196 93513 no
NEFT 182 99378 no
NEFFENDORF 114 145220 no