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 “defoliating” with Change Limit: [1] [2] [3] [4]

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

257 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
defoliating164582(None) 
decollating1545972decollating
defalcating1844342defalcating
deflating142610712def_l_ating
defoliation1548312defoliation
defoliations1647592defoliations
desolating1239462desol_ating
exfoliating2243392exfoliating
foliating1339252__foliating
affiliating1844173affiliating
deadlifting1742503deadlifting
debilitating1654113debilitating
decorating14312073deco_rating
defeating142311973def__eating
defecating17237783def_ecating
defilading1643643defil_ading
defleaing1444743def_lea_ing
deflecting1736503def_lecting
defoaming1645653defo__aming
defoliant1345203defolia__nt
defoliate1346993defoliat__e
defoliated1545833defoliat_ed
defoliates1446333defoliat_es
defoliator1444183defoliat_or
defoliators1543723defoliators
deforesting1654793deforesting
delating103119603de__l_ating
delisting112710503de__listing
demolishing1843883demolishing
denominating1645693denominating
depilating1439193depil_ating
depolishing1843503depolishing
depositing1446933deposi_ting
derogating1348633dero_gating
desalinating1476313desalinating
detonating1248823deto_nating
detoxicating2353863detoxicating
devaluating1645053devaluating
deviating14311083de__viating
filiating1339253__filiating
negotiating1344243negotiating
reflating132514713ref_l_ating
refloating14198323ref_loating
retaliating1248873retaliating
spoliating1366963_spoliating
afflicting1943484_afflicting
ammoniating1644064ammoniating
associating1444864associating
befitting15236624bef__itting
befleaing1544024bef_lea_ing
bevomiting1843104bevomi_ting
bloviating1643814_bloviating
collating12312784__collating
deactivating1953454deactivating
deadlining1364564deadli_ning
deaerating12311564de_aerating
deaminating1547974deaminating
debating123213734de___bating
debiting122511204de__bi_ting
decapitating1854954decapitating
decelerating1645594decelerating
decimating1648764de_cimating
declaiming1644784de_claiming
declaring1339574de_cl_aring
declawing1636214de_cl_awing
declining13129354de_cli_ning
decocting1538124deco__cting
decollation1448194decollation
decollations1547364decollations
decoloring1486314decol_oring
decolouring1583434decolouring
decorticating1984244decorticating
decoupaging1851944decoupaging
decussating1543194decussating
dedicating1539144de_dicating
defacing15238684def___acing
defalcation1746224defalcation
defalcations1845194defalcations
defaming15238464def___aming
defatting1436104def__atting
defaulting1543394def_aulting
defecting162510224def__ecting
defibrinating2052464defibrinating
defiling132812464def__i_ling
defining133711804def__i_ning
deflagrating1852664deflagrating
deflation13310654def_l_ation
deflations1439714def_l_ations
defloration1547264defloration
deflorations1646064deflorations
deflowering1952654deflowering
defocusing1752814defo_cusing
defocussing1861954defocussing
defogging1653864defo__gging
defoliants1442934defolia_nts
deforcing1636064defo__rcing
deformation1747664deformation
deformations1846844deformations
deformative2044974deformative
deforming1636704defo__rming
defraying1735854def__raying
defrosting1544494def_rosting
deglazing2135134de_gl_azing
dehorting1447214deho__rting
dehydrating2043654dehydrating
deionizing2147654deioni_zing
delaminating1645684delaminating
delaying133210974de__l_aying
deleading1237774de__leading
deleaving1436264de__leaving
delectating1545994delectating
delegating1337674de_legating
deleting103314424de__l_eting
delighting1644994de__lighting
deliming12310374de__li_ming
delimiting1445844de__limiting
delineating1346374delineating
demarcating1745204demarcating
demeriting1448684demeri_ting
demitting13239074de__mitting
demodulating1753164demodulating
demolition1376984demoli_tion
demolitions1446524demoli_tions
demonising1447564demoni_sing
demonizing2348854demoni_zing
demoting12311424demo___ting
demounting1444964demo_unting
demyelinating2051624demyelinating
denervating1645924denervating
denigrating14146924denigrating
denitrating13128334denitrating
denoting10311754deno___ting
denudating1345264de_nudating
deorbiting1445154de_orbiting
depainting14156154de_painting
depicting1537814de__picting
deplaning1338054de_pl_aning
depleting1378194de_pl_eting
depopulating1853734depopulating
deporting1369594depo__rting
deprecating1777284deprecating
depreciating1845034depreciating
depredating1655694depredating
depurating1438644de_purating
deracinating1645224deracinating
derating103222284de___rating
desalting1138844desal__ting
desecrating1548094desecrating
deselecting1544474deselecting
desiccating1744704desiccating
designating1446074designating
desisting112810384de__sisting
desolatingly1752704desol_atingly
desolation11311404desol_ation
desolations12310594desol_ations
despiting13179324de_spi_ting
despoliation1546714despoliation
despoliations1646394despoliations
despumating1743694despumating
detoxifying2652634detoxifying
deuterating1347274deuterating
devastating1644704devastating
devoicing16145224devo_i_cing
devolving1733984devol__ving
devoting1338824devo___ting
dilating102714914d__il_ating
dimidiating1643994dimidiating
dislocating1546734dislocating
dissociating1655364dissociating
divulgating1742304divulgating
doating93816864d__o__ating
dominating1449404d__ominating
donating10311804d__o_nating
duplicating1745404d_uplicating
elating83423084_e__l_ating
elongating1244524_elongating
eluviating1444894_eluviating
emaciating1546824_emaciating
emulating1239874_emul_ating
enlisting1038344_e_nlisting
epilating12310974_epil_ating
eradiating1248734_eradiating
etiolating1146984etiol_ating
evaluating1456024_evaluating
excoriating2145484excoriating
exfoliation2145254exfoliation
exfoliations2244784exfoliations
exfoliative2452484exfoliative
expiating1938544_e_xpiating
explicating2356124_explicating
exuviating2144524_exuviating
fellating1339254__fellating
flinting123412344__f_linting
flirting12319014__f_lirting
fliting113514614__f_li_ting
flitting123010884__f_litting
floating123111884__f_loating
foisting122910504__fo_isting
foliation121110794__foliation
foliations1399944__foliations
folioing1237574__foli_oing
gelating103015734ge__l_ating
helilifting1852044helilifting
herniating1445984he_rniating
humiliating1744084humiliating
immolating1545054immol_ating
inflating13310444inf_l_ating
inflicting1645724inf_licting
infuriating1546284infuriating
insolating1149154insol_ating
isolating1039744_isol_ating
mediating13311204me__diating
officiating2052924officiating
opiating11410094___opiating
palliating1347894_palliating
peculating1549164pecul_ating
percolating1657324percol_ating
perforating1747024perfo_rating
perorating13313134pero_rating
phenolating1745254phenol_ating
recoating121317464reco__ating
reenlisting1244674reenlisting
refitting132811124ref__itting
reflecting1638824ref_lecting
refolding1437454refol__ding
reforesting1546194reforesting
reformatting1852704reformatting
regelating1239954regel_ating
regulating12310064regul_ating
relating92725444re__l_ating
relisting102414354re__listing
relocating13310874relo_cating
remediating1547134remediating
remotivating1864334remotivating
renominating1546424renominating
renovating1447424reno_vating
replating122217404re_pl_ating
replicating1649094re_plicating
repolishing1744584repolishing
repositing13310494reposi_ting
repudiating1546204repudiating
reradiating1347264reradiating
reslating102516994re_sl_ating
resonating11311264reso_nating
resplitting1444944resplitting
revalidating1744184revalidating
revaluating1545894revaluating
reviolating1556264reviol_ating
revolting1339634revol__ting
sealifting1444634se_alifting
seriating10916404se__riating
solating9315594__sol_ating
solvating1336444__solvating
sufflating1744844suffl_ating
vellicating1744564ve_llicating
ventilating1546344ventilating
violating1337444_viol_ating

Search took 10 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 Filter1786911488190.403443402.0
2DLD Change Limit1488192578.95316622.2
3Display Results2572570.1431797.2
 (SQL Overall)1786912579.49918811.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.