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 = 'ST' order by rank asc limit 0,100 Surnames > S > ST > STC

Surnames > S > ST > STC

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
SA SB SC SD SE SF SG SH SI SJ SK SL SM SN SO SP SQ SR ST SU SV SW SY SZ
STA STB STC STD STE STF STG STH STI STJ STL STM STO STP STR STS STT STU STV STW STY

Full Surname List Starting with STC(Alphabetical)

STCHARLES
STCIN
STCLAIR
STCLAIRE
STCLOUD
STCROIX
STCYR

Top 100 Surnames in the 2010 US Census starting with STC

SurnameCountRankWiki?
STCLAIR 14590 2469 no
STCYR 3132 10290 no
STCLAIRE 941 26042 no
STCHARLES 808 29279 no
STCROIX 403 51610 no
STCIN 182 99378 no
STCLOUD 153 114424 no