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

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

87 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
detonating124882(None) 
decorating14312072decorating
derogating1348632derogating
desolating1239462desolating
detonation11310942detonation
detonations1239372detonations
detonative1447132detonative
donating10311802d__onating
intonating1148632intonating
resonating11311262resonating
automating1389303automating
catenating1348683catenating
coronating13410173coronating
deaerating12311563deaerating
deaminating1547973deaminating
debating123213733de__bating
deboning12109153debon__ing
decanting132510633decan_ting
decimating1648763decimating
decocting1538123deco_cting
decollating1545973decollating
dedicating1539143dedicating
defeating142311973de_feating
defecating17237783defecating
deflating142610713de_flating
defoaming1645653defo_aming
defoliating1645823defoliating
dehorting1447213deho_rting
deionizing2147653deionizing
delating103119603de__lating
delegating1337673delegating
delineating1346373delineating
dementing13311043demen_ting
demonising1447563demonising
demonizing2348853demonizing
demoting12311423demo__ting
demounting1444963demounting
denominating1645693denominating
denoting10311753de__noting
denting94422183de__n_ting
denudating1345263denudating
depilating1439193depilating
deponing121211213depon__ing
deporting1369593depo_rting
depositing1446933depositing
depurating1438643depurating
derating103222283de__rating
descanting1446923descanting
designating1446073designating
detecting13259983det_ecting
detesting112610323det_esting
detonate9311193detonat__e
detonated1138213detonat_ed
detonates10310433detonat_es
detonator1045983detonat_or
detonators1145853detonators
detouring1136973deto_uring
detoxicating2353863detoxicating
detoxing1736313deto__xing
detracting1438713detracting
deuterating1347273deuterating
deviating14311083de_viating
devoting1338823devo__ting
doating93816863d__o_ating
dominating1449403dominating
elongating1244523_elongating
emanating1239003_emanating
etiolating1146983_etiolating
festinating1547373festinating
geminating1447763geminating
ozonating1944323_ozonating
patinating1339883patinating
perorating13313133perorating
personating1447673personating
petnaping1444543pet_naping
phonating1537813_phonating
pronating12313763_pronating
protonating1448593protonating
recoating121317463reco_ating
relocating13310873relocating
renovating1447423renovating
resinating11313733resinating
retinting102215253retin_ting
retorting10613273reto_rting
retotaling1186883retotaling
retreating111414773retreating
venenating1446013venenating

Search took 7 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 Filter1786911406030.436409841.7
2DLD Change Limit140603875.72024580.9
3Display Results87870.0302900.0
 (SQL Overall)178691876.18628886.4
 
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.