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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
decompensating226252(None) 
compensating1955002__compensating
decompensation2193362decompensation
decompensations22103042decompensations
decompensate19123633decompensat__e
decompensated21122893decompensat_ed
decompensates20113193decompensat_es
recompensing1953863recompens__ing
commentating1957044__commentating
compensation18126504__compensation
compensations19136184__compensations
compensative2154654__compensative
decomposing1943634decomp_os__ing
decompressing2152914decompres_sing
deconcentrating2163084deconcentrating
decongesting1753734deconge_s_ting
deconsecrating2053634deconsecrating
denominating1645694denom_in_ating
commenting1749175__commen__ting
compensate1646145__compensat__e
compensated1844865__compensat_ed
compensates1745725__compensat_es
compensational2073525__compensational
compensator1754675__compensat_or
compensators1854375__compensators
compensatory2163645__compensatory
competing163712465__compe___ting
complicating2145635__complicating
compositing1846265__comp_ositing
composting17178055__comp_os_ting
cooperating1648425__coope_rating
deaminating1547975de_am_in_ating
decapitating1854955dec_ap_itating
decarbonating1953235decarbon_ating
decelerating1645595dec_ele_rating
decerebrating1953205dec_erebrating
decimating1648755decim____ating
decollating1545965deco___llating
decomposition2053075decomp_osition
decompositions2152815decomp_ositions
decorating14312075deco____rating
decorticating1984245deco_rticating
decoupaging1851945decoup___aging
decrepitating1953025decrep_itating
decussating1543195dec___ussating
deforesting1654795defo_re_s_ting
delaminating1645685delam_in_ating
dementing13311045de__m_en__ting
deoxygenating26101625deoxygen_ating
depopulating1853735depo_p_ulating
detonating1248825deto___n_ating
disorientating1682705disorientating
documenting1753125docum_en__ting
dominating1449405d__om_in_ating
emendating1444615_e__m_endating
recementing1645225recem_en__ting
recommencing2153335recommen__cing
recommendation2183225recommendation
recommendations22113095recommendations
recommending2053235recommen__ding
recomposing1844225recomp_os__ing
recomputing1844345recomp___uting
reconcentrating2063345reconcentrating
recondensing1653695recondens__ing
reconsecrating1954195reconsecrating
recuperating1744995rec_upe_rating
renominating1546425renom_in_ating
reoperating1449025re_o_pe_rating
reorientating1473765re_orientating
tempesting1544455te__mpe_s_ting
uncompensated2062745uncompensat_ed

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 Filter178691950240.360496363.9
2DLD Change Limit95024716.67314240.1
3Display Results71710.0461543.5
 (SQL Overall)178691717.07925242.4
 
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.