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

150 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
deducting143684(None) 
deducing1336421deduc_ing
abducting1584082abducting
adducting1494302adducting
debuting12268632debu_ting
decocting1538122decocting
dedicating1539142dedicating
deduction1377082deduction
deductions1467132deductions
deductive1645472deductive
defecting162510222defecting
degusting1236162degusting
dejecting20217792dejecting
depicting1537812depicting
deputing12238792depu_ting
detecting13259982detecting
deucing1139392de_uc_ing
ducting113713592__ducting
educating1337932_educating
educing1137682_educ_ing
eructing112110172_eructing
inducting1338372inducting
redacting13612302redacting
reducing12310202reduc_ing
relucting1239772relucting
seducing1236502seduc_ing
abducing1474063abduc_ing
addicting1485073addicting
adducing1384113adduc_ing
bedecking1934283bedecking
bedumbing1742843bedumbing
beduncing1543913beduncing
conducting1648833conducting
daunting103310403d_aunting
dauting93814763d_au_ting
debating123213733de_bating
debauching1942473debauching
debiting122511203de_biting
debouching1942723debouching
debugging1542993debugging
debunking1733353debunking
decanting132510633decanting
decking153915593de__cking
decupling1534973decupling
decurving1634723decurving
deduct10610793deduct___
deducted1356243deduct_ed
deductible1643203deductible
deducts1166593deduct__s
defacing15238683defac_ing
defatting1436103defatting
defaulting1543393defaulting
defeating142311973defeating
defecating17237783defecating
deflating142610713deflating
deflecting1736503deflecting
defueling14255093defueling
defunding15216123defunding
defusing13227933defu_sing
defuzing22195253defu_zing
degumming1643133degumming
dehorting1447213dehorting
deicing11312193de_ic_ing
delating103119603de_lating
deleting103314423de_leting
delisting112710503delisting
deluding1137683delu_ding
deluging1137123delu_ging
demasting1338453demasting
dementing13311043dementing
demitting13239073demitting
demoting12311423de_moting
demounting1444963demounting
demurring1335253demurring
denoting10311753de_noting
denting94422183de__nting
denudating1345263denudating
denuding1137113denu_ding
departing1349513departing
depleting1378193depleting
deporting1369593deporting
depurating1438643depurating
derating103222283de_rating
deratting1139513deratting
desalting1138843desalting
deserting11713143deserting
desisting112810383desisting
despiting13179323despiting
destructing1546113destructing
detaching1637263detaching
detesting112610323detesting
deticking1736043deticking
detracting1438713detracting
devesting14249903devesting
deviating14311083deviating
devoting1338823de_voting
diluting10248983dilu_ting
directing1338823directing
doubting1237373d_oubting
douching15349843d_ouching
ducking154315053__ducking
ductings12346673__ductings
dueting93814393__dueting
dunting93418383__dunting
dusting93618993__dusting
editing9313133_ed_iting
eduction1169053_eduction
eductions1268773_eductions
eductive1476863_eductive
ejecting18268163_ejecting
electing112113783_electing
eluting84115293_elu_ting
enacting11311363_enacting
equating18310113_equating
erecting112415063_erecting
erupting11218443_erupting
evicting1437483_evicting
exacting1838523_exacting
exulting1637643_exulting
indicting1339613indicting
inducing1237873induc_ing
mediating13311203mediating
medicating1648953medicating
prededucting1952553prededucting
predicting1649873predicting
reacting113317893re_acting
rebutting1237523rebutting
recutting1239483recutting
redating102620173red_ating
redocking17126783redocking
redubbing1543573redubbing
reductant1246753reductant
reduction1259903reduction
reductions1359583reductions
reductive1547793reductive
reeducating1545163reeducating
refecting152413353refecting
refuting121911903refu_ting
reinducting1544383reinducting
rejecting192211153rejecting
reputing112412603repu_ting
requiting1939883requiting
resecting122816483resecting
resulting10311083resulting
sedating103014113sed_ating
seduction1266983seduction
seductions1366873seductions
seductive1545613seductive
selecting12310533selecting
subducting1644313subducting

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.483369960.7
2DLD Change Limit1486411507.37620152.0
3Display Results1501500.0602500.0
 (SQL Overall)1786911507.91922564.8
 
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.