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

Surnames > U > UF > UFF

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
UFE UFF UFH UFK UFR

Full Surname List Starting with UFF(Alphabetical)

UFFELMAN
UFFER
UFFMAN
UFFNER
UFFORD

Top 100 Surnames in the 2010 US Census starting with UFF

SurnameCountRankWiki?
UFFELMAN 449 47272 no
UFFORD 280 69996 no
UFFMAN 158 111426 no
UFFER 127 133048 no
UFFNER 127 133048 no