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

171 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
deducted135624(None) 
deduced1266681deduc_ed
abducted1444092abducted
adducted1343912adducted
debuted11379332debu_ted
decocted1437682decocted
dedicated14310252dedicated
deduce1079252deduc_e_
deduces1168792deduc_es
deduct10610792deduct__
deducts1166592deduct_s
defected15289972defected
degusted1135732degusted
dejected19307592dejected
depicted1437742depicted
deputed114610172depu_ted
detected12289732detected
deuced104112122de_uc_ed
ducted104012122__ducted
educated1237942_educated
educed10418852_educ_ed
eructed10228652_eructed
inducted1237272inducted
redacted12410242redacted
reduced11610322reduc_ed
relucted1138652relucted
seduced1186752seduc_ed
abduced1374843abduc_ed
abductee1344783abductee
addicted1345073addicted
adduced1274353adduc_ed
bedecked1874573bedecked
bedotted1234983bedotted
bedumbed1643023bedumbed
bedunced1453903bedunced
conducted1547313conducted
daunted93810193d_aunted
dauted84114933d_au_ted
dealated103213603dealated
debated113916083de_bated
debauched18123343debauched
debited113311623de_bited
debouched18123633debouched
debugged1433223debugged
debunked1633193debunked
decanted122310493decanted
decked145217623de__cked
decupled1494983decupled
decurved1534843decurved
dedicate12312803dedicate_
dedicatee13410343dedicatee
dedicates13311693dedicates
deducing1336423deducing
deducting1436843deducting
deduction1377083deduction
deductive1645473deductive
defaced142910973defac_ed
defatted1335673defatted
defaulted1443313defaulted
defeated132812163defeated
defecated1637493defecated
deflated133412303deflated
deflected1635983deflected
defueled1374513defueled
defunded1435163defunded
defused125211093defu_sed
defuzed21447043defu_zed
degummed1542603degummed
dehorted1357303dehorted
deiced104214483de_ic_ed
delated93722873de_lated
deleted93314913de_leted
delisted10310563delisted
deluded10158763delu_ded
deluged10167413delu_ged
deluster936903deluster
demasted1238763demasted
demented12311273demented
demitted12288773demitted
demoted114313543de_moted
demounted1344903demounted
demurred1234933demurred
denoted93512763de_noted
dentated10411703dentated
dented84120513de__nted
denudated1244933denudated
denuded10167663denu_ded
departed1238823departed
depicter1356853depicter
depleted12258723depleted
deported1249703deported
depurated1338183depurated
depute94512303depu_te_
deputes104911783depu_tes
derated93623503de_rated
deratted1048403deratted
desalted1038313desalted
deserted101012203deserted
desisted1039783desisted
despited1248323despited
destructed1445413destructed
detached1537733detached
detecter11298733detecter
detested10279623detested
deticked1635693deticked
detracted1357793detracted
deuce84517493de_uc_e_
deuces94015513de_uc_es
devested13239133devested
deviated13311043deviated
devoted124111093de_voted
diluted9248933dilu_ted
directed1238233directed
doubted11307483d_oubted
douched144012113d_ouched
ducked144718013__ducked
dueted84113593__dueted
dunted84718503__dunted
dusted83918373__dusted
edited83913673_ed_ited
educate10310213_educate_
educates1139623_educates
educe84313453_educ_e_
educes94011953_educ_es
educt85017103_educt__
eductor1035863_eductor
educts9439893_educt_s
ejected17297653_ejected
elected102812613_elected
eluted74915263_elu_ted
enacted10310643_enacted
equated171910403_equated
erected103213993_erected
erupted10207163_erupted
evicted1337243_evicted
exacted1737303_exacted
exulted1536303_exulted
indicted1249203indicted
induced11298933induc_ed
inductee1158053inductee
mediated123011873mediated
medicated15410073medicated
pedicled1436463pedicled
peduncled1542523peduncled
prededucted1852333prededucted
predicted1538913predicted
reacted103015713re_acted
rebutted11126783rebutted
redated93120923red_ated
redocked16206823redocked
redubbed1433143redubbed
reduce9713253reduc_e_
reducer1059003reduc_er
reduces10513343reduc_es
reductor1156433reductor
reeducated1484823reeducated
refected142311663refected
refuted114313803refu_ted
reinducted1464413reinducted
rejected182710113rejected
reputed104613483repu_ted
requited18169723requited
resected112514743resected
resulted939713resulted
sedated93714353sed_ated
seduce9610023seduc_e_
seducer1056503seduc_er
seduces1069283seduc_es
selected1159783selected
subducted1544223subducted
uneducated1444523uneducated

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621717.25020160.3
3Display Results1711710.0632714.3
 (SQL Overall)1786911717.73323107.6
 
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.