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

95 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
decapitating185495(None) 
decapitation1748682decapitation
decapitations1847662decapitations
decrepitating1953022decrepitating
cavitating1646913__cavitating
deactivating1953453deactivating
deaminating1547973de_aminating
debilitating1654113debilitating
decapitate1545873decapitat__e
decapitated1744943decapitat_ed
decapitates1655643decapitat_es
decapitator1653803decapitat_or
decapitators1753263decapitators
decimating1648763dec__imating
delaminating1645683delaminating
depilating1439193de__pilating
deracinating1645223deracinating
desalinating1476313desalinating
devastating1644703deva_stating
dilapidating1762023dilapidating
precipitating2074033precipitating
recapitulating1962053recapitulating
agitating1138864___agitating
capacitating1952554capacitating
capitation14311364__capitation
capitations1549854__capitations
capitulating1773974__capitulating
captivating1944884__captivating
cogitating1447214__cogitating
crepitating1645804_crepitating
deaerating12311564de_a_erating
decantation1448944deca_ntation
decantations1547944deca_ntations
decanting132510634deca___nting
decarbonating1953234decarbonating
decelerating1645594decelerating
decollating1545974dec_ollating
decorating14312074dec__orating
decorticating1984244decorticating
decrepitation1884804decrepitation
decrepitations1984344decrepitations
decussating1543194dec_ussating
dedicating1539144de__dicating
defalcating1844344defa_lcating
defatting1436104defa__t_ting
defoliating1645824defoli_ating
delectating1545994de_lectating
demarcating1745204dema_rcating
demitting13239074de__mit_ting
denitrating13128334de__nitrating
denominating1645694denominating
depainting14156154depa_i_nting
depicting1537814de__pi_cting
depopulating1853734depopulating
depurating1438644de__purating
deratting1139514dera__t_ting
despiting13179324de_spi__ting
despumating1743694de_spumating
destituting13155164de_stituting
detoxicating2353864detoxicating
devaluating1645054deva_luating
deviating14311094de__vi_ating
dictating1338884dic___tating
divaricating1953594divaricating
emaciating1546824_emaci_ating
epilating12310974_e__pilating
eradiating1248734_eradi_ating
eradicating1556634_eradicating
evaginating1644914_evaginating
evaporating1744194_evaporating
excogitating2352464excogitating
expatiating2144364_expatiating
expiating1938544_e_xpi_ating
facilitating1854014facilitating
felicitating1853324felicitating
gravitating1644004_gravitating
hesitating1448004he__sitating
incapacitating2161234incapacitating
lapidating1445244__lapidating
levitating1446654le__vitating
meditating1448124me__ditating
necessitating1662374necessitating
nictitating1444384nic_titating
palpitating1644654_palpitating
reactivating1844754reactivating
reanimating1447234re_animating
recalibrating1852964recalibrating
recapitalize25125234recapitalize
recapitalizing2863664recapitalizing
recapturing1643764recap_turing
recuperating1744994recuperating
reradiating1347264reradi_ating
retaliating1248874retali_ating
revalidating1744184revalidating
sanitating1149654__sanitating

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.406440125.6
2DLD Change Limit124790957.14317470.3
3Display Results95950.0462065.2
 (SQL Overall)178691957.59523527.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.