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

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

82 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
decongested166307(None) 
congested1338672__congested
decongest1345632decongest__
decongests1443242decongest_s
contested12310693__contested
decongestant1662463decongestant
decongesting1753733decongesting
decongestion1653923decongestion
decongestive1952393decongestive
deforested1543843defo_rested
reconnected1665103reconnected
reconverted1745653reconverted
uncontested1444563uncontested
conceited14310424__conceited
concerted14312114__concerted
confected1739074__confected
confessed1546054__confessed
congealed1346594__congealed
congeed113212314__conge__ed
congest104618774__congest__
congests113510384__congest_s
congressed1445464__congressed
connected1438754__connected
consented12311944__consented
consisted1238504__consisted
contented12313044__contented
contester11311184__contester
convected1738784__convected
convented15410754__convented
converted15311564__converted
deaconesses1445654deacon_esses
decanted122310494decan___ted
decentered1445324decente_red
decentest1249084decentest__
decocted1437684deco___cted
decollated14136284deco_llated
decollete12124784decolle_te_
decolletes13123984decolle_tes
decompensated21122904decompensated
decomposed1843894decompos_ed
decompressed20102424decompressed
decongestants1771894decongestants
decongestions1753564decongestions
deconsecrated19113854deconsecrated
decorated13312204deco__rated
degusted1135734de___gusted
delineated1246244delin_eated
demonesses1346704demon_esses
demonised1348234demon_is_ed
derogated1238674dero_g_ated
detested10279624de___tested
detonated1138214deton__ated
devested13239134de___vested
digested11208164d___igested
disconcerted1854344disconcerted
disconnected1853714disconnected
discontented1655314discontented
disinfested1653724disinfested
disinvested1653474disinvested
egested938124_e___gested
elongated1144284_elong_ated
ingested10259004___ingested
nonvested1346004__nonvested
preconcerted1953864preconcerted
recognised1444124recognis_ed
recollected1643854recollected
reconceived1953784reconceived
recondensed1543924recondensed
reconducted1744284reconducted
reconferred1783664reconferred
reconsulted1454244reconsulted
recontacted1654714recontacted
reconvened1645394reconve_ned
reconveyed1943474reconve_yed
reconvicted1944274reconvicted
redigested1354114re_digested
reforested1445384refo_rested
reinvested1444794re_invested
renested92212954re__n_ested
unconfessed1762834unconfessed
unconnected1644314unconnected
unconverted1744774unconverted

Search took 9 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 Filter1786911488190.423422437.4
2DLD Change Limit148819828.40617703.9
3Display Results82820.0461782.6
 (SQL Overall)178691828.87520134.2
 
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.