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 = 'TE' order by rank asc limit 0,100 Surnames > T > TE > TEZ

Surnames > T > TE > TEZ

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
TA TC TE TH TI TJ TK TL TO TR TS TU TV TW TY TZ
TE TEA TEB TEC TED TEE TEF TEG TEH TEI TEJ TEK TEL TEM TEN TEO TEP TER TES TET TEU TEV TEW TEX TEY TEZ

Full Surname List Starting with TEZ(Alphabetical)

TEZAK
TEZEL
TEZENO

Top 100 Surnames in the 2010 US Census starting with TEZ

SurnameCountRankWiki?
TEZENO 815 29093 no
TEZAK 469 45569 no
TEZEL 104 156044 no