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 > STD

Surnames > S > ST > STD

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 STD(Alphabetical)

STDENIS
STDENNIS
STDON

Top 100 Surnames in the 2010 US Census starting with STD

SurnameCountRankWiki?
STDENIS 1035 24237 yes
STDENNIS 397 52267 no
STDON 106 153769 no