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

Surnames > T > TS > TSH

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
TSA TSC TSE TSH TSI TSO TSU TSV TSY

Full Surname List Starting with TSH(Alphabetical)

TSHIBANGU
TSHIMANGA
TSHUDY

Top 100 Surnames in the 2010 US Census starting with TSH

SurnameCountRankWiki?
TSHUDY 302 65593 no
TSHIMANGA 116 143149 no
TSHIBANGU 105 154907 no