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

Surnames > S > SR > SRU

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
SRA SRB SRD SRE SRI SRN SRO SRP SRS SRU SRY

Full Surname List Starting with SRU(Alphabetical)

SRUBAR
SRULOWITZ
SRUN

Top 100 Surnames in the 2010 US Census starting with SRU

SurnameCountRankWiki?
SRUBAR 183 98982 no
SRUN 138 124548 no
SRULOWITZ 110 149395 no