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

91 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
debilitating165411(None) 
debilitation1547782debilitation
debilitations1647132debilitations
habilitating1853382habilitating
debilitate1344863debilitat__e
debilitated1543813debilitat_ed
debilitates1444473debilitat_es
decapitating1854953decapitating
defoliating1645823defoli_ating
depilating1439193depil__ating
desalinating1476313desalinating
facilitating1854013facilitating
felicitating1853323felicitating
militating1348823__militating
rehabilitating2061853rehabilitating
affiliating1844174affili_ating
deactivating1953454deactivating
deadlifting1742504deadli_fting
deaminating1547974de_aminating
debating123213734deb____ating
debilities13411294debili__ties
debiting122511204deb__i__ting
decelerating1645594decelerating
decimating1648764de__cimating
decollating1545974decol_lating
decrepitating1953024decrepitating
dedicating1539144de__dicating
defalcating1844344defal_cating
defibrinating2052464defibrinating
defilading1643644defil__ading
definitizing2672994definitizing
deflating142610714de_fl__ating
delaminating1645684delaminating
delating103119604de__l__ating
delectating1545994de_lectating
delegating1337674de__legating
deliberating1645124deliberating
delighting1644994de__lighting
delimitation1597264delimitation
delimitations1676634delimitations
delimiting1445844de__limiting
delineating1346374deli_neating
delisting112710504de__li_sting
demilitarize2484104demilitarize
demilitarizing2762714demilitarizing
demitting13239074de__mit_ting
demyelinating2051624demyelinating
denigrating14146924deni_grating
denitrating13128334deni_trating
denominating1645694denominating
deracinating1645224deracinating
desiccating1744704desi_ccating
desiderating1544694desiderating
designating1446074desi_gnating
desolating1239464desol__ating
destituting13155164de_stituting
detoxicating2353864detoxicating
devaluating1645054deval_uating
devastating1644704de_vastating
deviating14311084de__vi_ating
dictating1338884d__i_ctating
dilating102714914d__il__ating
dimidiating1643994dimidi_ating
duplicating1745404d_uplicating
eliminating1445544_eliminating
epilating12310974_epil__ating
explicating2356124_explicating
filiating1339254__fili_ating
habilitation1795514habilitation
habilitations1884864habilitations
hebetating1645794heb__etating
helilifting1852044helili_fting
hesitating1448004he__sitating
humiliating1744084humili_ating
imitating1238764___imitating
jubilating2045234jubil__ating
legitimating1653814legitimating
levitating1446654le__vitating
meditating1448124me__ditating
obligating1445814_ob_ligating
precipitating2074034precipitating
redictating1546804redi_ctating
reinitiating1345764re_initiating
reinstating1248114re_instating
replicating1649094re_plicating
resplitting1444944resplit_ting
retaliating1248874retali_ating
revalidating1744184revalidating
sibilating1346974sibil__ating
sublimating1675464sub_limating
vellicating1744564ve_llicating

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 Filter1786911247900.403443402.0
2DLD Change Limit124790917.40616849.9
3Display Results91910.0501820.0
 (SQL Overall)178691917.85922737.1
 
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.