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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
detonated113821(None) 
detonate9311191detonate_
detonates10310431detonates
decorated13312202decorated
derogated1238672derogated
desolated1139652desolated
detonator1045982detonator
donated93513862d__onated
intonated1048302intonated
resonated10510612resonated
automated1248813automated
catenated1238913catenated
coronated123313323coronated
deaerated11311113deaerated
dealated103213603de_alated
deaminated1448013deaminated
debated113916083de__bated
deboned113411633debon__ed
decanted122310493decan_ted
decimated1548953decimated
decocted1437683deco_cted
decollated14136283decollated
decorate11315193decorate_
decorates12314743decorates
dedicated14310253dedicated
defeated132812163de_feated
defecated1637493defecated
deflated133412303de_flated
defoamed15356243defo_amed
defoliated1545833defoliated
dehorted1357303deho_rted
deionized2057153deionized
delated93722873de__lated
delegated1238373delegated
delineated1246243delineated
demented12311273demen_ted
demonised1348233demonised
demonized2239853demonized
demoted114313543demo__ted
demounted1344903demounted
denominated15166253denominated
denoted93512763de__noted
dentated10411703de_ntated
dented84120513de__n_ted
denudated1244933denudated
depilated1339653depilated
deponed113712873depon__ed
deported1249703depo_rted
deposited1346773deposited
depurated1338183depurated
derated93623503de__rated
derogate10311353derogate_
derogates11310973derogates
descanted1336673descanted
designated1345933designated
desolate9411993desolate_
desolater1038383desolater
desolates10311793desolates
detected12289733det_ected
detente83313603deten_te_
detentes92712873deten_tes
detested10279623det_ested
detonable1247623detonable
detonating1248823detonating
detonation11310943detonation
detonative1447133detonative
detonators1145853detonators
detoured1036513deto_ured
detoxed1636103deto__xed
detoxicated2253493detoxicated
detracted1357793detracted
deuterated1247533deuterated
deviated13311043de_viated
devoted124111093devo__ted
doated84118183d__o_ated
dominated1339883dominated
donate73619503d__onate_
donates83217223d__onates
elongated1144283_elongated
emanated1139163_emanated
etiolated1047073_etiolated
festinated1447533festinated
geminated1338543geminated
intonate8310923intonate_
intonates9410243intonates
neonate7311333ne_onate_
neonates8310063ne_onates
ozonated1864593_ozonated
patinated123911413patinated
pennated11299543pe_nnated
perorated12412453perorated
personated13258293personated
phonated1447893_phonated
pronated11414053_pronated
protonated1348593protonated
recoated113416783reco_ated
relocated12710813relocated
renovated1347173renovated
resinated10413283resinated
resonate8513513resonate_
resonates9412403resonates
retinted94414363retin_ted
retorted9312333reto_rted
retotaled1045953retotaled
retreated10312623retreated
saponated1245733saponated
togated94410663__togated
venenated1345903venenated
zonated173310533__zonated

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411097.12620859.0
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.32824384.7
 
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.