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

Surnames > U > UM > UML

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

UMLAH
UMLAND
UMLAUF
UMLOR

Top 100 Surnames in the 2010 US Census starting with UML

SurnameCountRankWiki?
UMLAND 783 29986 no
UMLAUF 639 35246 no
UMLOR 263 73666 no
UMLAH 132 129047 no