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

(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
decompensations22103041decompensations_
decompensation2193362decompensation__
compensations19136183__compensations_
decompensating2262523decompensati_n_g
compensation18126504__compensation__
compensational2073524__compensational
decompensates20113204decompensat__es_
decompositions2152814decomp_ositions_
recommendations22113094recommendations_
commendations2055805__commendations_
compellations1954815__compellations_
compensating1955005__compensati_n_g
compensators1854375__compensat_ors_
condensations1646275__condensations_
decompensate19123645decompensat____e
decompensated21122905decompensat___ed
decomposition2053075decomp_osition__
decompressions21102665decompres_sions_
decongestions1753565deconge_s_tions_
deconsecrations2064515deconsecrations_
denominations16117855denom_in_ations_
dispensations1655485d__ispensations_
documentations19144485docum_entations_
recombinations2095595recombin_ations_
recommendation2183225recommendation__
recompilations2054955recomp_ilations_
recompositions2053175recomp_ositions_
recomputations20104105recomp_utations_
cementations1659016__cem_entations_
combinations1897926__combin_ations_
commendation1946516__commendation__
commensurations21182586__commensurations_
comminations18810486__commin_ations_
compellation1855106__compellation__
compensates1745726__compensat__es_
compensative2154656__compensati__ve
compensator1754676__compensat_o__r
compensatory2163646__compensat_o_ry
competitions1845536__compe_titions_
compilations1848686__comp_ilations_
complexations26134016__complexations_
complications2147436__complications_
compositions1846256__comp_ositions_
compunctions20145696__compun_ctions_
compurgations20123896__compurgations_
computations1848126__comp_utations_
condensation1546786__condensation__
condensational1753656__condensational
conversations1847456__conversations_
cooperations1659196__coope_rations_
deaminations151010136de_am_in_ations_
decantations1547946dec___antations_
decapitations1847666dec_ap_itations_
decarbonations19123156decarbon_ations_
decelerations1646426dec_ele_rations_
decerebrations1993746dec_erebrations_
decimalizations2957586decimalizations_
decimations16410166decim____ations_
declensions1443336dec__lens__ions_
declinations15410226dec__lin_ations_
decollations1547366deco___llations_
decolonizations27145966decolonizations_
decolorizations27136106decolorizations_
decommissions2052856decom_mis_sions_
decompression20102766decompres_sion__
deconcentration20103626deconcentration__
deconditions1645286deco___nditions_
decongestion1653926deconge_s_tion__
deconsecration1954786deconsecration__
decorations14312886deco____rations_
decortications1966776deco_rtications_
decrepitations1984346decrep_itations_
decussations1543676dec___ussations_
deforestations1853966defo_restations_
delaminations1647946delam_in_ations_
denomination15118836denom_in_ation__
denominational1752546denom_in_ational
deoxygenations2661746deoxygen_ations_
depigmentations21102846depigmentations_
depopulations1844496depo_p_ulations_
desperations1559526de__spe_rations_
detonations1239376deto___n_ations_
disorientations1683626disorientations_
dispensation1555606d__ispensation__
dispensational1762506d__ispensational
documentation18144726docum_entation__
documentational2061966docum_entational
dominations14611046d__om_in_ations_
emendations1446056_e__m_endations_
fermentations1856276fe_rm_entations_
fomentations1746796__fom_entations_
recombination19106176recombin_ation__
recombinational21102026recombin_ational
recompensing1953866recompens__i_n_g
recompilation1955156recomp_ilation__
recomposition1953416recomp_osition__
recomputation1974396recomp_utation__
reconsecrations1995106reconsecrations_
recuperations1746086rec_upe_rations_
regimentations1784856regim_entations_
renominations15108306renom_in_ations_
reoperations14410066re_o_pe_rations_
reorientations1465216re_orientations_
sedimentations1754416sedim_entations_
segmentations1655596se_gm_entations_

Search took 6 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.360496363.9
2DLD Change Limit658741055.40612185.3
3Display Results1051050.0931129.0
 (SQL Overall)1786911055.85930498.5
 
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.