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

144 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
desalinating147631(None) 
deaminating1547972de_aminating
delaminating1645682delaminating
deracinating1645222deracinating
desalination13411132desalination
desalinations14410182desalinations
desalinizing2354102desalinizing
debilitating1654113debilitating
decapitating1854953decapitating
defalcating1844343defal_cating
defoliating1645823defoli_ating
delineating1346373de__lineating
demyelinating2051623demyelinating
denominating1645693denominating
depainting14156153depa_in_ting
desalinate1146673desalinat__e
desalinated1345773desalinat_ed
desalinates1246213desalinat_es
desalinator1254353desalinat_or
desalinators1353603desalinators
desalting1138843desal___ting
designating1446073des_ignating
desolating1239463desol__ating
devaluating1645053deval_uating
evaginating1644913_evaginating
festinating1547373fes_tinating
resinating11313733res__inating
retaliating1248873retali_ating
revalidating1744183revalidating
salivating1447443__salivating
aestivating1545804aes_tivating
alienating1147234___alienating
assassinating1461454assassinating
bepainting15144884bepa_in_ting
deactivating1953454deactivating
deadlifting1742504deadli_fting
deadlining1364564deadlin__ing
deaerating12311564de_a_erating
deamination14411544de_amination
deaminations151010134de_aminations
deaminizing2475554de_aminizing
decanting132510634deca__n_ting
decarbonating1953234decarbonating
decelerating1645594decelerating
dechlorinating2162184dechlorinating
decimating1648764de__cimating
declination14411874de_clination
declinations15410224de_clinations
declining13129354de_clin__ing
decollating1545974decol_lating
dedicating1539144de__dicating
defibrinating2052464defibrinating
deflagrating1852664deflagrating
deflating142610714de_fl__ating
delamination1548854delamination
delaminations1647944delaminations
delating103119604de__l__ating
delegating1337674de__legating
delighting1644994de__lighting
delimiting1445844de__limiting
delisting112710504de__li_sting
demarcating1745204dema_rcating
depilating1439194de__pilating
deracination1548864deracination
deracinations1647834deracinations
desalinization2455614desalinization
desalinizations2555394desalinizations
desalinize2044324desalin__ize
desanding12207654desa__n_ding
descanting1446924des_can_ting
desecrating1548094des_ecrating
deselecting1544474desel_ecting
desiccating1744704des_iccating
desiderating1544694desiderating
desisting112810384des__i_sting
despiting13179324des_pi__ting
despumating1743694des_pumating
desquamating2551754desquamating
destaining1267944destain__ing
destination12413844des_tination
destinations13412664des_tinations
destining11311434des_tin__ing
destituting13155164des_tituting
detaining112510474deta_in__ing
detonating1248824de__tonating
detoxicating2353864detoxicating
devastating1644704deva_stating
deviating14311084de__vi_ating
dilapidating1762024dilapidating
disjointing2045294disjoin_ting
dislocating1546734dis_locating
displanting1546044displan_ting
disseminating1754054disseminating
dissipating1556314dis_sipating
divaricating1953594divaricating
dominating1449404d__ominating
duplicating1745404d_uplicating
eliminating1445544_eliminating
emaciating1546824_emaci_ating
emanating1239004_ema__nating
eradiating1248734_eradi_ating
eradicating1556634_eradicating
escalating1347094_escal__ating
estimating1348884_es_timating
estivating1447634_es_tivating
evaluating1456024_eval_uating
explicating2356124_explicating
fascinating1745254fas_cinating
geminating1447764ge__minating
germinating1546174ge_rminating
hesitating1448004hes__itating
inseminating1554554inseminating
invaginating1753904invaginating
invalidating1793444invalidating
italianating1352054_italianating
laminating1348734__laminating
marinating13410274__marinating
paginating1447534__paginating
patinating1339884__patinating
pepsinating1645374pe_psinating
pollinating1445624_pollinating
reanimating1447234re_animating
recalibrating1852964recalibrating
renominating1546424renominating
repainting13128974repa_in_ting
replicating1649094re_plicating
reradiating1347264reradi_ating
resaluting1137394resal__uting
reslating102516994res_l__ating
resonating11311264res__onating
resplitting1444944respli_tting
revaccinating2152704revaccinating
revaluating1545894reval_uating
sainting93215734__sa_in_ting
salinizing2047434__salinizing
sanitating1149654__sanitating
satiating10311814__sati_ating
sealifting1444634se_ali_fting
splinting1238194__splin_ting
supinating1357834__supinating
terminating1447354te_rminating
validating1545844__validating
vellicating1744564ve_llicating
vesicating1646904ves__icating

Search took 9 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 Filter1786911247900.406440125.6
2DLD Change Limit1247901448.09315419.5
3Display Results1441440.0761894.7
 (SQL Overall)1786911448.57520838.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.