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 = 'IF' order by rank asc limit 0,100 Surnames > I > IF > IFR

Surnames > I > IF > IFR

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
IA IB IC ID IE IF IG IH II IJ IK IL IM IN IO IP IQ IR IS IT IU IV IW IX IY IZ
IFF IFI IFK IFL IFR IFT

Full Surname List Starting with IFR(Alphabetical)

IFRAH
IFRAIMOV

Top 100 Surnames in the 2010 US Census starting with IFR

SurnameCountRankWiki?
IFRAIMOV 148 117480 no
IFRAH 134 127494 no