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

127 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
deracinating164522(None) 
deaminating1547972de_aminating
delaminating1645682delaminating
deracination1548862deracination
deracinations1647832deracinations
desalinating1476312desalinating
deactivating1953453de_activating
decapitating1854953decapitating
decimating1648753de__cimating
denominating1645693denominating
depainting14156153depa_in_ting
depreciating1845033depreci_ating
deracinate1356563deracinat__e
deracinated1544863deracinat_ed
deracinates1445863deracinat_es
emaciating1546813_emaci_ating
eradiating1248733_eradi_ating
eradicating1556633_eradicating
evaginating1644903_evaginating
germinating1546173ger_minating
reradiating1347263reradi_ating
revaccinating2152703revaccinating
terminating1447353ter_minating
bepainting15144884bepa_in_ting
brachiating1944434_brachiating
brecciating1844224brecci_ating
brominating1696094_brominating
capacitating1952554capacitating
criminating1646854_criminating
deaconing1337194de_acon__ing
deaerating12311564de_a_erating
deamination14411544de_amination
deaminations151010134de_aminations
deaminizing2475554de_aminizing
debilitating1654114debilitating
decanting132510634de__can_ting
decarbonating1953234decarbonating
decorating14312074de__corating
decrepitating1953024decrepitating
dedicating1539144de__dicating
defalcating1844344defa_lcating
defecating17237784defec__ating
defibrinating2052464defibrinating
defoliating1645824defoli_ating
delamination1548854delamination
delaminations1647944delaminations
delectating1545994delec_tating
delineating1346374de__lineating
demarcating1745204dema_rcating
demyelinating2051624demyelinating
depilating1439184de__pilating
deprecating1777284deprec__ating
deraigning1344104dera_i_gning
derailing112011314dera_i__ling
deranging1238064dera__n_ging
derating103222284der____ating
deratting1139514dera___tting
deregulating1554014deregulating
derogating1348634der__ogating
desalination13411134desalination
desalinations14410184desalinations
desalinizing2354104desalinizing
descanting1446924de_scan_ting
desecrating1548094desec_rating
desiccating1744704desic_cating
designating1446074de_signating
detaining112510474deta_in__ing
detonating1248824de__tonating
detoxicating2353864detoxicating
detracting1438714detrac___ting
detraining1267674detra_in__ing
devaluating1645054deva_luating
devastating1644704deva_stating
deviating14311084de__vi_ating
dilapidating1762024dilapidating
divaricating1953594divaricating
dominating1449404d__ominating
draining103312674d_ra_in__ing
ejaculating2144824_ejaculating
eliminating1445544_eliminating
elucidating1543694_elucidating
emanating1239004_ema__nating
emancipating1952894_emancipating
eructating1345694_eruc_tating
evacuating1645674_evac_uating
fascinating1745244_fascinating
felicitating1853324felicitating
festinating1547374fe_stinating
fractionating1953084_fractionating
geminating1447764ge__minating
glaciating1445594_glaci_ating
gravitating1644004_gravitating
herniating1445984her_ni_ating
invaginating1753904invaginating
irradiating1353774irradi_ating
keratinizing2654044keratinizing
laminating1348724__laminating
lancinating1445444_lancinating
machinating1945614__machinating
marginating1545894mar_ginating
marinating13410264__marinating
merchanting1944314mer_chanting
mercurating1645954mer_curating
originating1344904_originating
paginating1447524__paginating
patinating1339874__patinating
pepsinating1645374pe_psinating
percolating1657324per_colating
peregrinating1752974peregrinating
perennating1445544per_ennating
personating1447674per_sonating
radiating111112124__radi_ating
radicating1459064__radicating
reactivating1844754re_activating
reanimating1447234re_animating
recriminating1864934recriminating
renominating1546424renominating
repainting13128974repa_in_ting
resinating11313734__resinating
retaliating1248874retali_ating
revalidating1744184revalidating
ruinating1039594__r_uinating
ruminating1348144__ruminating
seriating10916404ser__i_ating
urinating10310654_ur__inating
vaccinating1945184_vaccinating
vaticinating1853554vaticinating

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.420425454.8
2DLD Change Limit1247901278.45314762.8
3Display Results1271270.0801587.5
 (SQL Overall)1786911278.95319958.8
 
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.