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

Surnames > U > UC > UCE

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
UC UCA UCC UCE UCH UCK UCL

Full Surname List Starting with UCE(Alphabetical)

UCEDA
UCETA

Top 100 Surnames in the 2010 US Census starting with UCE

SurnameCountRankWiki?
UCEDA 352 57781 no
UCETA 250 76768 no