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

130 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
redecorating1611505(None) 
decorating14312072__decorating
redecoration1546012redecoration
redecorations1645082redecorations
desecrating1548093desec_rating
edulcorating1652053_edulcorating
execrating2047883_exec_rating
federating1548853fede__rating
overdecorating2153683overdecorating
recoating121317463r__eco_ating
recrating121318793r__ec_rating
redecorate1346143redecorat__e
redecorated1544963redecorat_ed
redecorates1465683redecorat_es
redecorator1452983redecorat_or
redecorators1552663redecorators
rededicating1744333rededicating
redefeating1645333rede_feating
redepositing1652823redepositing
redictating1546803redic_tating
regenerating1446333regenerating
rerecording1543303rerecor_ding
celebrating1646114cele_brating
cerebrating1646664cere_brating
deaerating12311564__deaerating
decelerating1645594decelerating
decimating1648764__decimating
decocting1538124__deco_cting
decollating1545974__decollating
decoration13314424__decoration
decorations14312884__decorations
decorative1648924__decorative
dedicating1539144dedic__ating
defecating17237784defec__ating
degenerating1545664degenerating
dehorting1447214__dehor_ting
delectating1545994delec_tating
deporting1369594__depor_ting
depurating1438644__depurating
derating103222284__de__rating
derogating1348634__derogating
desolating1239464__desolating
deteriorating1553394deteriorating
detonating1248824__detonating
educating1337934_educ__ating
elaborating1444864_elaborating
escorting1237714_e_scor_ting
evaporating1744194_evaporating
excoriating2145484_e_xcoriating
expectorating2552064expectorating
generating12310394gene__rating
medicating1648954medic__ating
meliorating1446564me_liorating
mercurating1645954me_rcurating
moderating1448804mode__rating
obsecrating1644134obsec_rating
penetrating1447664pene_trating
percolating1657324pe_rcolating
perforating1747024pe_rforating
perorating13313134__perorating
predeceasing18103064predec_easing
predicating1749654predic__ating
prerecording1852114prerecor_ding
radicating1459074radic__ating
reallocating1573664reallocating
reassorting1245024reassor_ting
recharting1637214r__echarting
recoaling121312454r__eco_aling
recording131311624r__ecor_ding
recorking16149644r__ecor_king
recounting1339194r__ecounting
recreating131214584r__ecreating
recuperating1744994recuperating
redacting13612304redac___ting
redating102620174red____ating
redeciding1544704redec__iding
redefecting1844374rede_fecting
redescribing1852544redescribing
rediscounting1762064rediscounting
redivorcing1852154redivor_cing
redrafting1545964red___rafting
redrawing1437214red___rawing
redshirting1643264redshir_ting
reeducating1545164re_educating
reelevating1544964re_elevating
reembracing1852704re_embracing
reengraving1693094re_engraving
reescalating1553254reescalating
reexporting2143424reexpor_ting
refecting152413354refec___ting
refloating14198324re_flo_ating
regelating1239954rege__lating
regrating111316214r__e_grating
reheating132314914rehe___ating
rehydrating1944034re_hydrating
reimporting1644094reimpor_ting
reincarnating1652444reincarnating
reiterating12410504re_iterating
rejecting192211154rejec___ting
relegating1239484rele__gating
relocating13310874r__elocating
reluctating1445764reluc_tating
remediating1547134reme_diating
remigrating1547594re_migrating
remunerating1545424remunerating
renegotiating1552244renegotiating
renovating1447424r__enovating
reoperating1449024re_operating
repeating122618984repe___ating
reporting12513904r__epor_ting
reprobating1647104re_probating
reregulating1454644reregulating
rerepeating1447184rere_peating
rescoring12310604re_scor__ing
reseating102421534rese___ating
resecting122816484resec___ting
resecuring1345124resecur__ing
resonating11311264r__esonating
resorting10614614r__esor_ting
reticulating1546394reticulating
retorting10613274r__etor_ting
revegetating1753684revegetating
reverberating1953204reverberating
reverting132315134reve__r_ting
revibrating1745574re_vibrating
reviolating1556264re_violating
teleporting1453274telepor_ting
undercoating1645374underco_ating
underrating1388254unde_rrating
venerating14410054vene__rating

Search took 8 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.390458182.1
2DLD Change Limit1247901306.59318927.7
3Display Results1301300.0761710.5
 (SQL Overall)1786911307.05925313.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.