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

Surnames > S > ST > STP

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

STPAUL
STPETER
STPETERS
STPHARD
STPIERRE
STPREUX

Top 100 Surnames in the 2010 US Census starting with STP

SurnameCountRankWiki?
STPIERRE 9638 3685 no
STPETER 2680 11694 no
STPAUL 398 52169 no
STPREUX 244 78316 no
STPETERS 210 88336 no
STPHARD 164 108199 no