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

89 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
decompensated2112290(None) 
decompensate19123641decompensate_
decompensates20113201decompensates
compensated1844862__compensated
uncompensated2062742uncompensated
compensate1646143__compensate_
compensates1745723__compensates
decompensating2262523decompensating
decompensation2193363decompensation
overcompensated2582763overcompensated
recompensed18103943recompens__ed
commentated1886214__commentated
compensator1754674__compensator
decompensations22103044decompensations
decomposed1843904decomp_os__ed
decompressed20102424decompres_sed
deconcentrated2093004deconcentrated
decongested1663074deconge_s_ted
deconsecrated19113854deconsecrated
denominated15166254denom_in_ated
overcompensate2393014overcompensate_
overcompensates2482844overcompensates
recompense1694404recompens__e_
recompenses17114354recompens__es
commentate16108175__commentate_
commentates17107615__commentates
commented16129615__commen__ted
compensable1955195__compensable
compensating1955005__compensating
compensation18126505__compensation
compensative2154655__compensative
compensators1854375__compensators
compensatory2163645__compensatory
competed154113595__compe___ted
complicated2046095__complicated
composited1756005__comp_osited
composted16378825__comp_os_ted
condensate1345545__condensate_
condensates1445315__condensates
cooperated1567335__coope_rated
deaminated1448015de_am_in_ated
decaffeinated2361125decaffeinated
decapitated1744945dec_ap_itated
decarbonated1853445decarbon_ated
decelerated1545925dec_ele_rated
decerebrated1853315dec_erebrated
decimated1548955decim____ated
decollated14136285deco___llated
decomposable2152345decomp_osable
decompose1644545decomp_os__e_
decomposer1753495decomp_os__er
decomposes1745195decomp_os__es
decompresses1972825decompres_ses
deconcentrate1873475deconcentrate_
deconcentrates1993145deconcentrates
deconsecrate17114175deconsecrate_
deconsecrates1894045deconsecrates
decorated13312215deco____rated
decorticated18144175deco_rticated
decoupaged1751935decoup___aged
decrepitated1872615decrep_itated
decussated1442895dec___ussated
deforested1543855defo_re_s_ted
delaminated1545785delam_in_ated
demented12311275de__m_en__ted
denominate13167685denom_in_ate_
denominates14167205denom_in_ates
deoxygenated2561825deoxygen_ated
depopulated1743645depo_p_ulated
detonated1138215deto___n_ated
disorientated1562365disorientated
documented1653205docum_en__ted
dominated1339885d__om_in_ated
emendated1344665_e__m_endated
recemented1546165recem_en__ted
recommenced2053815recommen__ced
recommended1953145recommen__ded
recompensing1953865recompens_ing
recomposed1744875recomp_os__ed
recomputed1744735recomp___uted
reconcentrated1983345reconcentrated
recondensed1543925recondens__ed
reconsecrated1884395reconsecrated
recuperated1645175rec_upe_rated
renominated14146975renom_in_ated
reoperated1348155re_o_pe_rated
reorientated1352705re_orientated
tempested1444035te__mpe_s_ted
uncomplicated2253765uncomplicated

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 Filter1786911247900.393454684.5
2DLD Change Limit124790899.37313313.8
3Display Results89890.0461934.8
 (SQL Overall)178691899.81218211.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.