Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “fanegas” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

242 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
fanegas114571(None) 
fanega1055781fanega_
fangas105017191fan_gas
angas65827982_an_gas
faenas94412762fa_enas
fanegada1341612fanegada
fanegadas1441482fanegadas
fanes84639892fane__s
fanga96119622fan_ga_
fangs96224072fan_g_s
favelas1337022favelas
maneges103612142maneges
mangas94122922man_gas
pangas99921102pan_gas
sangas75222652san_gas
senegas837252senegas
aegis6316783_a_egis
agas55938843_a__gas
ajugas1435263_ajugas
akelas10311193_akelas
alegar739283_alegar
alegars838933_alegars
algas65624933_a_lgas
amebas10311453_amebas
amigas95912173_amigas
anabas8314083_anabas
anas46649863_an__as
anear55420323_ane_ar
anears63717183_anears
aneles64626293_aneles
anemias92512143_anemias
anergias947173_anergias
anes45255933_ane__s
anga56831353_an_ga_
angels74416173_angels
angers75222543_angers
animas84418723_animas
anlas55626933_an_las
annas55824883_an_nas
anoas57226493_an_oas
antas55432033_an_tas
apneas83211383apne_as
areas55935773_are_as
arecas84817443_arecas
arenas65021993_arenas
arepas85515703_arepas
avgas96912133_a_vgas
bananas93312223bananas
bandas95120543ban_das
banes74945583bane__s
bangers104020353bangers
bangs85627773ban_g_s
bareges105212033bareges
bodegas1135483bodegas
calesas9411833calesas
cameras11313363cameras
canchas143212403canchas
candelas1139533candelas
canellas10310563canellas
caners84629203cane_rs
canes75350373cane__s
cannas84518403can_nas
canolas9313993canolas
canulas9312853canulas
canvas113813333can_vas
catenas9313113catenas
cinemas1138043cinemas
congas94417033con_gas
daggas937973da_ggas
dangers94818213dangers
dangs75623203dan_g_s
degas75119163__degas
dongas84914613don_gas
enemas8812003_enemas
facemask1942123facemask
facers115519443face_rs
faces106439433face__s
facets116316653face_ts
facias113415803fa_cias
fadeins1168503fadeins
faders105117463fade_rs
fades94932863fade__s
fadges114814023fa_dges
faecal11359813fa_ecal
faeces114713123fa_eces
faena85014203fa_ena_
fags86939123fa__g_s
fajitas1734253fajitas
fakeers14446673fakeers
fakers134219533fake_rs
fakes126032483fake__s
fames105735923fame__s
fancies124018783fancies
fandoms13229473fandoms
fane75343573fane___
fanfics1535173fanfics
fang85432553fan_g__
fanged114318223fan_ged
fanions103713073fanions
fanjets1734803fanjets
fanners103914653fanners
fannies103415643fannies
fanons96115213fan_ons
fanos85926503fan__os
fans76247373fan___s
fantasm1236593fan_tasm
fantast10311703fan_tast
fantasy1336153fan_tasy
fantods11177623fantods
fantoms12189153fantoms
fanums1137263fan_ums
farers95924053fare_rs
fares85852873fare__s
farinas103215233farinas
farness102912203farne_ss
fascias1258413fascias
fates85139233fate__s
fatness103311293fatne_ss
fatwas1249053fa_twas
faunas94013633fa_unas
favas115618593fa__vas
favela1237033favela_
favellas1446163favellas
faves115331423fave__s
fawners13388493fawne_rs
faxes155726653faxe__s
fazendas2143073fazendas
fazes175527213faze__s
fetas85624403f__etas
fincas113512073fin_cas
fines86644263fine__s
fingers113418433fingers
flanes94522423flane__s
flaneurs1133953flaneurs
flangers123311373flangers
flanges113413273flan_ges
fleas86423663f_le_as
foveas1238623fove_as
funeral1037623funeral
funerals1146453funerals
fungal10388733fun_gal
fungals11276783fun_gals
fungus10418183fun_gus
funkias1435383funkias
galeas74618513gale_as
galenas83310343galenas
ganefs10489203gane_fs
ganevs10456913gane_vs
gangers94418603gangers
gangs76222573gan_g_s
ganjas14149113gan_jas
genevas1185253genevas
hangar104114513han_gar
hangars114313493han_gars
hangers113120813hangers
hangs95726723han_g_s
hansas94616043han_sas
janes124928123jane__s
kanakas10327213kanakas
kanas95326913kan__as
kanes95529373kane__s
kinemas1336893kinemas
lanes54946793lane__s
laneway1345273laneway
laneways1444573laneways
lanugos834453lanugos
lingas75116573lin_gas
manages103418963manages
mananas93414733mananas
manas76240433man__as
manege94113203maneg_e
manes76648963mane__s
manga85026203man_ga_
mangels103614493mangels
mangers103521263mangers
manges94628943man_ges
mangos94319333man_gos
manias84029033man_ias
manilas93915873manilas
mannas85019803man_nas
mantas85725363man_tas
mantras93815863mantras
mantuas93410993mantuas
nanas55928633nan__as
negs55727363__neg_s
negus64513563__negus
nemas75321573__nemas
nonegos837143nonegos
omegas936973_omegas
pakehas1635313pakehas
panadas103312213panadas
panamas113112763panamas
pandas95521963pan_das
panels84716523pane_ls
panes76148693pane__s
panga85323533pan_ga_
pangens103112063pangens
pangs84628663pan_g_s
ragas65326063ra__gas
ranees64623963rane_es
rangers83621043rangers
ranges73826923ran_ges
ranulas7311773ranulas
reneges82513593reneges
sagas66025883sa__gas
saigas74114293sa_igas
sanes55649073sane__s
sanga66023793san_ga_
sangar73617683san_gar
sangars83116253san_gars
sangers84421943sangers
sanghs105312063san_ghs
santeras8311063santeras
senecas939013senecas
senega738173senega_
syngas10368913syn_gas
taenias7311283taenias
taigas73712563ta_igas
tanga64923693tan_ga_
tangos74216303tan_gos
tangs65028343tan_g_s
tankas104613763tan_kas
tantras73112093tantras
telegas837443telegas
tineas64616483tine_as
tongas74315523ton_gas
usneas638333usne_as
vandas103915993van_das
vanes85130973vane__s
vangs96319583van_g_s
vinegar1134613vinegar
vinegars1245063vinegars
wanes85040883wane__s
wangan10311223wan_gan
wangans1149503wan_gans
wanigan1135213wanigan
wanigans1244743wanigans
yangs95618693yan_g_s
yantras10259003yantras
zananas16319563zananas
zanzas1487053zan_zas
zarebas1836303zarebas

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.1561145455.1
2DLD Change Limit1340272427.01619103.1
3Display Results2422420.0932602.2
 (SQL Overall)1786912427.26524596.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.