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 “fanega” 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.

349 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
fanega105578(None) 
fanegas1145711fanegas
fanga96119621fan_ga
anga56831352_an_ga
faena85014202fa_ena
fane75343572fane__
fanegada1341612fanegada
fanes84639892fane_s
fang85432552fan_g_
fangas105017192fan_gas
fanged114318222fanged
fangs96224072fan_gs
favela1237032favela
manege94113202manege
manga85026202man_ga
panga85323532pan_ga
sanga66023792san_ga
senega738172senega
tanga64923692tan_ga
aceta74017353_aceta
adnexa1433673adnexa
aga410447233_a__ga
ajuga1335883_ajuga
akela9311343_akela
alegar739283_alegar
alga57927603_a_lga
ameba9312383_ameba
amiga85514813_amiga
ana39559833_an__a
ane37866953_ane__
anear55420323_anear
anele55628833_anele
anemia82613573_anemia
anent54931843_anent
anergia847363_anergia
anergy10156863_anergy
anes45255933_ane_s
anew76623133_ane_w
angas65827983_an_gas
angel65019563_angel
anger66225873_anger
anima74620073_anima
anna45529013_an_na
anoa45634473_an_oa
ansa45927773_an_sa
anta46839583_an_ta
antra56521923_antra
apnea73413413apne_a
area45843393_are_a
areca75618633_areca
arena55323813_arena
arepa75615563_arepa
asea46327183_ase_a
banana83213413banana
banda85223103ban_da
bane65250433bane__
baned85436353bane_d
banes74945583bane_s
bang74837003ban_g_
banged104923723banged
banger94423633banger
bangs85627773ban_gs
barege94713543barege
bodega1034933bodega
caeca93915133ca_eca
calesa8412473calesa
camera10313693camera
cancha134411613cancha
candela1089743candela
cane66653123cane__
caned85838093cane_d
canella9310793canella
caner75334773cane_r
caners84629203caners
canes75350373cane_s
canna75919333can_na
canola8313623canola
canula8312963canula
catena8312483catena
cinema1047653cinema
conga85419873con_ga
dagga839543da_gga
dang65131543dan_g_
danged94819483danged
danger83722823danger
dangs75623203dan_gs
donga76718423don_ga
enema7612743_enema
face96140123face__
faced117727653face_d
facer105525053face_r
facers115519443facers
faces106439433face_s
facet106038523face_t
facete115014833facete
facets116316653facets
faceup1334893faceup
facia103218463fa_cia
facula112912233facula
fade85736343fade__
faded105025243fade_d
fadein1068843fadein
fader94421513fade_r
faders105117463faders
fades94932863fade_s
fadge104816993fa_dge
fadged124712353fadged
fadges114814023fadges
faecal11359813fa_ecal
faenas94412763faenas
faery116015483fa_ery
fag76852363fa__g_
fagged124717703fagged
faggy136514373fa_ggy
fags86939123fa__gs
fainer94717243faine_r
fainest10417703fainest
fajita1635923fajita
fake115534943fake__
faked135225483fake_d
fakeer13378743fakeer
faker124824593fake_r
fakers134219533fakers
fakery16509263fakery
fakes126032483fake_s
fakey155515423fake_y
fame95639393fame__
famed115928343fame_d
fames105735923fame_s
fan67158863fan___
fancy134615483fan_cy
fandom122110893fandom
fanegadas1441483fanegadas
fanfic1436313fanfic
fanion94514323fanion
fanjet16311393fanjet
fanjets1734803fanjets
fanned104117473fanned
fanner94218183fanner
fanners103914653fanners
fanny114816043fan_ny
fano75831693fan__o
fanon84619013fan_on
fanons96115213fanons
fanos85926503fan_os
fans76247373fan__s
fantod102010033fantod
fantom112110803fantom
fanum10313443fan_um
fanums1137263fanums
fare76354463fare__
fared95842343fare_d
farer86733143fare_r
farers95924053farers
fares85852873fare_s
farina94618233farina
farness102912203farness
fascia1148703fascia
fate75444283fate__
fated95632133fate_d
fates85139233fate_s
fatness103311293fatness
fatwa1168063fa_twa
faugh125712963fa_ugh
fauna84816513fa_una
fava106820263fa__va
fave105532963fave__
favelas1337023favelas
favella1336173favella
faves115331423fave_s
fawned134910423fawne_d
fawner125910463fawne_r
fawners13388493fawners
faxed166220533faxe_d
faxes155726653faxe_s
fayed126422153faye_d
faze165630043faze__
fazed186222963faze_d
fazenda2043253fazenda
fazes175527213faze_s
feta76528903f__eta
finca104714503fin_ca
fine75147953fine__
fined94930503fine_d
finely123011563finely
finer85431563fine_r
finery124512893finery
fines86644263fine_s
finest94321733finest
finger104920333finger
flanes94522423flane_s
flaneur1034183flaneur
flange103411973flan_ge
flanged123810843flanged
flanger113412623flanger
flanges113413273flanges
flea75628493f_le_a
forego1038903forego
fovea11310483fove_a
fraena938063fraena
frena85915273f_rena
funeral1037623funeral
funest94316863funest
fungal10388733fun_gal
fungi95014133fun_gi
fungo94413133fun_go
funkia1336343funkia
gaga66625553ga__ga
galea64722933gale_a
galena74911093galena
gane55145303gane__
ganef96322463gane_f
ganefs10489203ganefs
ganev95513863gane_v
ganevs10456913ganevs
gang66031973gan_g_
ganged94619193ganged
ganger83721463ganger
gangs76222573gan_gs
ganja131410003gan_ja
genera71211713genera
geneva1085853geneva
hang85535553han_g_
hangar104114513han_gar
hanged114222393hanged
hanger104023253hanger
hangs95726723han_gs
haniwa1236743haniwa
hansa85416783han_sa
jane115031483jane__
janes124928123jane_s
kana85928533kan__a
kanaka9357523kanaka
kane85133973kane__
kanes95529373kane_s
kinema1236023kinema
lane45153333lane__
lanely93914483lanely
lanes54946793lane_s
laneway1345273laneway
lang56637383lan_g_
lanugo735573lanugo
linga66820823lin_ga
mana65341963man__a
manage93818903manage
manana84816073manana
mane65052033mane__
maned86634103mane_d
maneges103612143maneges
manes76648963mane_s
mangas94122923man_gas
mange84930193man_ge
mangel94017533mangel
manger94325003manger
manges94628943manges
mangey123614523mangey
mango85724323man_go
mangy115021243man_gy
mania75634153man_ia
manila84518303manila
manna75522543man_na
manta75629913man_ta
mantra84116093mantra
mantua84412023mantua
mega77620873__mega
nana46632903nan__a
neg47237343__neg_
negs55727363__negs
nema65522523__nema
nonego737013nonego
omega836383_omega
pakeha1533933pakeha
palea75028663pale_a
panada94113053panada
panama104213353panama
panda85022613pan_da
pane64950293pane__
paned85437183pane_d
panel76023623pane_l
panels84716523panels
panes76148693pane_s
pang75336293pan_g_
pangas99921103pan_gas
panged104722333panged
pangen94115913pangen
pangs84628663pan_gs
parerga1035173parerga
pineta85815563pineta
raga55930813ra__ga
ranee55438103rane_e
ranees64623963ranees
rang56939163ran_g_
range64728413ran_ge
ranged84824313ranged
ranger73925523ranger
ranges73826923ranges
rangy95320383ran_gy
ranula6311813ranula
renege72713763renege
saga55331173sa__ga
saiga64717933sa_iga
sancta839833sancta
sane45954343sane__
saned65636273sane_d
sanely93114613sanely
saner54334323sane_r
sanes55649073sane_s
sanest64426693sanest
sang55441233san_g_
sangar73617683san_gar
sangas75222653san_gas
sanger74524563sanger
sangh95517453san_gh
santera7311303santera
seneca839793seneca
senegas837253senegas
taenia6313193taenia
taiga64115663ta_iga
tang56138673tan_g_
tanged84622493tanged
tango66921173tan_go
tangs65028343tan_gs
tangy94519933tan_gy
tanka93817483tan_ka
tantra63713353tantra
tapeta8310693tapeta
telega736773telega
tinea54923163tine_a
tonga65619693ton_ga
usnea539393usne_a
vanda94515923van_da
vane75534693vane__
vaned94622423vane_d
vanes85130973vane_s
vang84926043van_g_
vangs96319583van_gs
vinegar1134613vinegar
wane76344723wane__
waned95831783wane_d
wanes85040883wane_s
waney115120323wane_y
wangan10311223wan_gan
wanigan1135213wanigan
yang85626073yan_g_
yangs95618693yan_gs
yantra9449623yantra
zanana153810363zanana
zanza1378703zan_za
zareba1736423zareba

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163496.00018786.0
3Display Results3493490.1103172.7
 (SQL Overall)1786913496.25028590.6
 
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.