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

Surnames > U > UL > ULF

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
ULA ULB ULC ULD ULE ULF ULH ULI ULL ULM ULN ULO ULR ULS ULT ULU ULV ULW ULY

Full Surname List Starting with ULF(Alphabetical)

ULFERS
ULFERTS
ULFIG

Top 100 Surnames in the 2010 US Census starting with ULF

SurnameCountRankWiki?
ULFERTS 261 74141 no
ULFERS 218 85659 no
ULFIG 144 120187 no