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 = 'ZE' order by rank asc limit 0,100 Surnames > Z > ZE > ZEF

Surnames > Z > ZE > ZEF

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
ZA ZB ZD ZE ZG ZH ZI ZL ZM ZN ZO ZR ZS ZU ZV ZW ZY
ZEA ZEB ZEC ZED ZEE ZEF ZEG ZEH ZEI ZEK ZEL ZEM ZEN ZEO ZEP ZEQ ZER ZES ZET ZEU ZEV ZEW ZEY ZEZ

Full Surname List Starting with ZEF(Alphabetical)

ZEFERINO
ZEFF
ZEFFER
ZEFFIRO
ZEFFREN
ZEFI

Top 100 Surnames in the 2010 US Census starting with ZEF

SurnameCountRankWiki?
ZEFERINO 715 32236 no
ZEFF 438 48256 no
ZEFFIRO 148 117480 no
ZEFFER 114 145220 no
ZEFI 111 148347 no
ZEFFREN 101 159712 no