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

84 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
deactivating195345(None) 
reactivating1844751reactivating
activating1647852__activating
deactivation18156082deactivation
deactivations19175062deactivations
inactivating1853462inactivating
aestivating1545803ae_stivating
captivating1944883_captivating
deactivate1644623deactivat__e
deactivated1843733deactivat_ed
deactivates1744393deactivat_es
deactivator1752843deactivat_or
deactivators1852573deactivators
deaminating1547973dea_minating
decapitating1854953decapitating
decimating1648753de_c_imating
deracinating1645223derac_inating
estivating1447633_e_stivating
reactivation17176953reactivation
reactivations18176143reactivations
remotivating1864333remotivating
activation15610134__activation
activations1669264__activations
activizing2545874__activizing
actuating1239224__act_uating
brachiating1944434brachi_ating
castigating1546004_castigating
cultivating1744944_cultivating
deadlifting1742504deadli_fting
deaerating12311564dea__erating
debilitating1654114debilitating
deceiving1635734de_ceiv__ing
decollating1545964de_collating
decorating14312074de_c_orating
decorticating1984244decorticating
decussating1543194de_cussating
dedicating1539144de__dicating
defoliating1645824defoli_ating
delaminating1645684delaminating
delectating1545994delect__ating
denervating1645924de_nervating
denitrating13128334denit_rating
denominating1645694denominating
depilating1439184de__pilating
desalinating1476314desalinating
destituting13155164de_stituting
detonating1248824de__tonating
detoxicating2353864detoxicating
deuterating1347274de_uterating
devastating1644704devast__ating
deviating14311084de__vi_ating
dictating1338884d_ict__ating
emaciating1546814emac_i_ating
estimating1348884_e_stimating
excavating2344114_exc_avating
festinating1547374fe_stinating
fractionating1953084fractionating
glaciating1445594glac_i_ating
inactivation1745094inactivation
inactivations1854244inactivations
lactating1239184_lact__ating
legitimating1653814legitimating
machinating1945614_machinating
masticating1647834_masticating
motivating1646804__motivating
negotiating1344244negoti_ating
nictitating1444384_nictitating
passivating1743784_passivating
patinating1339874_pa_tinating
quantitating2252924quantitating
reactivate1545844reactivat__e
reactivated1744974reactivat_ed
reactivates1645614reactivat_es
reactivities1756174reactivities
reanimating1447234rea_nimating
recultivating1953014recultivating
reestimating1545934reestimating
revaccinating2152704revaccinating
salivating1447434_sa_livating
satiating10311804_sa_ti_ating
titivating1445324__titivating
tittivating1552594_tittivating
vaccinating1945184_vaccinating
ventilating1546334ve_ntilating

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.390458182.1
2DLD Change Limit124790846.55019051.9
3Display Results84840.0761105.3
 (SQL Overall)178691847.01625469.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.