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 = 'US' order by rank asc limit 0,100 Surnames > U > US > USS

Surnames > U > US > USS

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
UB UC UD UE UF UG UH UI UJ UK UL UM UN UO UP UQ UR US UT UV UW UY UZ
US USA USC USE USH USI USK USL USM USN USO USQ USR USS UST USU USY USZ

Full Surname List Starting with USS(Alphabetical)

USS
USSELMAN
USSERY
USSHER
USSIN

Top 100 Surnames in the 2010 US Census starting with USS

SurnameCountRankWiki?
USSERY 5036 6708 no
USSELMAN 341 59324 no
USSIN 200 91981 no
USS 125 134712 no
USSHER 105 154907 no