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

105 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
exsiccating234266(None) 
desiccating1744702desiccating
exsiccation2243622exsiccation
exsiccations2343262exsiccations
execrating2047883ex_ecrating
expiating1938543expi__ating
explicating2356123explicating
exsecting1935933exs_ec_ting
exsiccate2043143exsiccat__e
exsiccated2242493exsiccat_ed
exsiccates2142803exsiccat_es
extincting2044003extinc_ting
extirpating2143743extirpating
extricating2146693extricating
vesicating1646903vesi_cating
abdicating1686154abdi_cating
associating1444864associating
auspicating1644604auspicating
busticating1645304busticating
dedicating1539144dedi_cating
desecrating1548094desecrating
desiccation1646384desiccation
desiccations1755654desiccations
desiccative1953944desiccative
designating1446074designating
dictating1338884__dictating
dislocating1546734dislocating
educating1337934e__ducating
eliciting1237774e_li_citing
elucidating1543694elucidating
emaciating1546824e_maciating
embrocating1844144embrocating
emigrating1467504e_migrating
ensilaging1243434ensi_laging
enunciating1444374enunciating
epilating12310974e_pi_lating
equivocating2751714equivocating
eradicating1556634eradicating
eructating1345694e_ructating
escalating1347094e_scalating
escaping1347064e_s__caping
escheating1645884e_scheating
escorting1237714e_s_corting
escoting1158714e_s__coting
estating92614994e_s__tating
estimating1348884e_stimating
estivating1447634e_stivating
estreating11710364e_streating
etiolating1146984e_tiolating
evacuating1645684e_vacuating
evicting1437484e_vi_c_ting
eviscerating1852674eviscerating
exacting1838524ex__ac_ting
exasperating2253184exasperating
excavating2344114ex_cavating
excepting2145874ex__cepting
exciting1838024ex___citing
excoriating2145484excoriating
excreting1946434ex__creting
excruciating2452374excruciating
exculpating2343554exculpating
executing1945584ex__ecuting
exfoliating2243394exfoliating
exhibiting2343624exhi_biting
exhilarating2351914exhilarating
existing1639074ex_i__sting
exiting15311394ex_i___ting
exonerating1945554exonerating
expatiating2144364expatiating
expecting2146694ex_pec_ting
expurgating2243284expurgating
exscinding2142334exs_cinding
exserting1736664exs__erting
extenuating1943574extenuating
extracting2047224extrac_ting
extubating2044424ex_tubating
exuberating2144174exuberating
exuviating2144524ex_uviating
fascinating1745254fascinating
hesitating1448004hesi_tating
indicating1449694indi_cating
insinuating1244534insinuating
masticating1647834masticating
medicating1648954medi_cating
metricating1647364metri_cating
mislocating1645894mislocating
nictating1237574__nictating
obsecrating1644134obsecrating
officiating2052924officiating
oxidating1845054ox_i_dating
pepsinating1645374pepsi_nating
radicating1459074radi_cating
redictating1546804redictating
replicating1649094repli_cating
resinating11313734resi_nating
resituating1247544resituating
rusticating1446314rusticating
siccative1645104__siccative
siccing12319514__sicc__ing
sinuating1039684__sinuating
situating1038884__situating
sonicating1348314soni_cating
urticating1347354urti_cating
vellicating1744564velli_cating
vesiculating1844674vesiculating

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.423422437.4
2DLD Change Limit1488191059.15616253.7
3Display Results1051050.0601750.0
 (SQL Overall)1786911059.63918538.3
 
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.