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

100 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
decompensations2210304(None) 
decompensation2193361decompensation_
compensations19136182__compensations
decompensating2262522decompensati_ng
compensation18126503__compensation_
decompensates20113193decompensat__es
decompositions2152813decomp_ositions
recommendations22113093recommendations
commendations2055804__commendations
compellations1954814__compellations
compensating1955004__compensati_ng
compensational2073524__compensational
compensators1854374__compensat_ors
condensations1646274__condensations
decompensate19123634decompensat___e
decompensated21122894decompensat__ed
decomposition2053074decomp_osition_
decompressions21102664decompres_sions
decongestions1753564deconge_s_tions
deconsecrations2064514deconsecrations
denominations16117854denom_in_ations
dispensations1655484d__ispensations
documentations19144484docum_entations
recombinations2095594recombin_ations
recommendation2183224recommendation_
recompilations2054954recomp_ilations
recompositions2053174recomp_ositions
recomputations20104104recomp_utations
cementations1659015__cem_entations
combinations1897925__combin_ations
commendation1946515__commendation_
commensurations21182585__commensurations
comminations18810485__commin_ations
compellation1855105__compellation_
compensates1745725__compensat__es
compensative2154655__compensati_ve
compensator1754675__compensat_o_r
compensatory2163645__compensat_ory
competitions1845535__compe_titions
compilations1848685__comp_ilations
complexations26134015__complexations
complications2147435__complications
compositions1846255__comp_ositions
compunctions20145695__compun_ctions
compurgations20123895__compurgations
computations1848125__comp_utations
condensation1546785__condensation_
conversations1847455__conversations
cooperations1659195__coope_rations
deaminations151010135de_am_in_ations
decantations1547945dec___antations
decapitations1847665dec_ap_itations
decarbonations19123155decarbon_ations
decelerations1646425dec_ele_rations
decerebrations1993745dec_erebrations
decimalizations2957585decimalizations
decimations16410165decim____ations
declensions1443335dec__lens__ions
declinations15410225dec__lin_ations
decollations1547365deco___llations
decolonizations27145965decolonizations
decolorizations27136105decolorizations
decommissions2052855decom_mis_sions
decompression20102765decompres_sion_
deconcentration20103625deconcentration_
deconditions1645285deco___nditions
decongestion1653925deconge_s_tion_
deconsecration1954785deconsecration_
decorations14312885deco____rations
decortications1966775deco_rtications
decrepitations1984345decrep_itations
decussations1543675dec___ussations
deforestations1853965defo_restations
delaminations1647945delam_in_ations
denomination15118835denom_in_ation_
deoxygenations2661745deoxygen_ations
depigmentations21102845depigmentations
depopulations1844495depo_p_ulations
desperations1559525de__spe_rations
detonations1239375deto___n_ations
disorientations1683625disorientations
dispensation1555605d__ispensation_
documentation18144725docum_entation_
dominations14611045d__om_in_ations
emendations1446055_e__m_endations
fermentations1856275fe_rm_entations
fomentations1746795__fom_entations
recombination19106175recombin_ation_
recompensing1953865recompens__i_ng
recompilation1955155recomp_ilation_
recomposition1953415recomp_osition_
recomputation1974395recomp_utation_
reconsecrations1995105reconsecrations
recuperations1746085rec_upe_rations
regimentations1784855regim_entations
renominations15108305renom_in_ations
reoperations14410065re_o_pe_rations
reorientations1465215re_orientations
sedimentations1754415sedim_entations
segmentations1655595se_gm_entations

Search took 5 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 Filter178691658740.343520965.0
2DLD Change Limit658741003.93616736.3
3Display Results1001000.0801250.0
 (SQL Overall)1786911004.35940993.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.