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

Surnames > U > UM > UMS

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
UM UMA UMB UME UMF UMH UMI UML UMM UMN UMO UMP UMR UMS

Full Surname List Starting with UMS(Alphabetical)

UMSCHEID
UMSTATTD
UMSTEAD
UMSTED
UMSTOT

Top 100 Surnames in the 2010 US Census starting with UMS

SurnameCountRankWiki?
UMSTEAD 1949 15127 no
UMSCHEID 438 48256 no
UMSTED 307 64721 no
UMSTATTD 188 96799 no
UMSTOT 169 105600 no