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 = 'GI' order by rank asc limit 0,100 Surnames > G > GI > GIF

Surnames > G > GI > GIF

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
GA GB GD GE GF GH GI GJ GL GM GN GO GR GS GU GW GY
GI GIA GIB GIC GID GIE GIF GIG GIJ GIK GIL GIM GIN GIO GIP GIR GIS GIT GIU GIV GIW GIX GIZ

Full Surname List Starting with GIF(Alphabetical)

GIFF
GIFFELS
GIFFEN
GIFFEY
GIFFIN
GIFFORD
GIFT

Top 100 Surnames in the 2010 US Census starting with GIF

SurnameCountRankWiki?
GIFFORD 19514 1834 yes
GIFFIN 4124 8028 no
GIFT 1490 18523 no
GIFFEN 988 25115 no
GIFFEY 133 128249 no
GIFFELS 108 151532 no
GIFF 103 157234 no