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

261 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
defected1528997(None) 
defeated132812161defeated
defecated1637491defecated
deflected1635981deflected
dejected19307591dejected
detected12289731detected
refected142311661refected
affected1744802affected
decocted1437692decocted
deducted1356242deducted
defaced142910972defac_ed
defatted1335672defatted
defeater122611662defeater
defecate1438792defecate_
defecates1538592defecates
defect124816172defect__
defector14277952defector
defects134511522defect_s
defenced1537202defenced
defended1437222defended
defensed1336222defensed
deferred13106362deferred
deflated133412302deflated
deleted93314912dele_ted
demented12311272demented
depicted1437742depicted
deserted101012202deserted
detecter11298732detecter
detested10279622detested
devested13239132devested
directed1238232directed
effected1744992effected
ejected17297652_ejected
elected102812612_elected
erected103213992_erected
infected14229402infected
perfected1736642perfected
redefected1743852redefected
reflected1547982reflected
rejected182710112rejected
resected112514742resected
selected1159782selected
advected1534543advected
affecter1644523affecter
bedecked1874573bedecked
befitted14305723befitted
beflecked2142653beflecked
befretted1544373befretted
bisected1336203bisected
cemented1338373cemented
coerected1447643coerected
confected1739073confected
deaerated11311123deaerated
deafened1335853deafe_ned
dealated103213603dealated
debated113916083de_bated
debeaked1634613debeaked
debited113311623de_bited
debuted11379333de_buted
decanted122310493decanted
deceased1247723deceased
deceived1535893deceived
decenter112412163decenter
decentred13236233decentred
decerned1237263decerned
decked145217623d__ecked
dedicated14310253dedicated
deduced1266683deduc_ed
deeded94615543de_e_ded
deemed104713063de_e_med
deface123113863defac_e_
defacer132810363defac_er
defaces133213403defac_es
defalcated1744183defalcated
defamed14309833def_amed
defanged1435433defanged
defaulted1443313defaulted
defeat103817163defeat__
defeaters13289103defeaters
defeats113511233defeat_s
defecator1546383defecator
defecting162510223defecting
defection151610643defection
defective1848003defective
defectives1945683defectives
defectors15237883defectors
defence1339893defence_
defences1439633defences
defend113910493defe__nd
defender1337293defender
defense1137503defense_
defenses1237913defenses
deferrer12135593deferrer
defied115016383def__ied
defiled124013103def_iled
defined123813823def_ined
deflate113613943deflate_
deflater123211603deflater
deflates123013943deflates
defleaed1344953defleaed
deflect13399973deflect__
deflector1555063deflector
deflects14336733deflect_s
deflexed2043883deflexed
defoamed15356243defoamed
defocused16143533defocused
defogged1533783defogged
deforced15247373deforced
deforested1543853deforested
deformed15248263deformed
defrayed1635403defrayed
defrocked2043063defrocked
defrosted1444263defrosted
defter104215923def__ter
defueled1374513defueled
defuelled1443133defuelled
defunded1435163defunded
defused125211093def_used
defuzed21447043def_uzed
degermed1335453degermed
degusted1135733degusted
dehorted1357303dehorted
deiced104214483de_ic_ed
deject164512843deject__
dejecta17376363deject_a
dejectedly2452393dejectedly
dejects17389223deject_s
delated93722873de_lated
deleaded1148333deleaded
deleaved1346573deleaved
delectated1446723delectated
delegated1238373delegated
delete73620703dele_te_
deletes83117933dele_tes
delisted10310563delisted
demasted1238763demasted
demeaned1237283demeaned
demerged13157603demerged
demerited1339073demerited
demitted12288773demitted
demoted114313543de_moted
denoted93512763de_noted
dentated10411703dentated
dented84120513d__ented
departed1238823departed
depended1337983depended
depermed1436453depermed
depicter1356853depicter
depleted12258723depleted
deported1249703deported
deprecated1646673deprecated
deputed114610173de_puted
derated93623503de_rated
deratted1048403deratted
desalted1038313desalted
desecrated1447953desecrated
deselected1444083deselected
deserter91211603deserter
deserved13108133deserved
desexed1636183dese_xed
desisted1039783desisted
despited1248323despited
detached1537733detached
detect94217403detect__
detecters12217753detecters
detector11278323detector
detects104011093detect_s
detente83313603detente_
detentes92712873detentes
deterged11127923deterged
deterred10137803deterred
detester9239683detester
deticked1635693deticked
detracted1357793detracted
deuced104112123de_uc_ed
deveined1336673deveined
develed123611933deve_led
deviated13311043deviated
devoted124111093de_voted
dieted83115493d_ie_ted
digested11208163digested
directer1137583directer
disjected2086353disjected
dissected13108663dissected
diverted13199583diverted
divested13268213divested
ducted104012123d__ucted
dueted84113593d_ue_ted
duetted937023d_uetted
effecter1664773effecter
egested938123_egested
electee92513243_electee
enacted10310643_enacted
erecter93113393_erecter
eructed10228653_eructed
everted112711853_everted
evicted1337243_evicted
exacted1737303_exacted
executed1835503_executed
exerted152210053_exerted
expected2036743expected
exsected1835673exsected
felted103714653__felted
feted94420933__fe_ted
fetted104817893__fetted
hefted134911423hef__ted
infecter13229153infecter
infested12249643infested
inflected1546053inflected
injected18226753injected
invected14258883invected
leeched13369503le_eched
neglected1354693neglected
objected2043493objected
obtected1344553obtected
perfecter1646043perfecter
prelected1439133prelected
reacted103015713re_acted
redacted12410243redacted
redefeated1544883redefeated
reejected1955093reejected
reelected1238313reelected
reerected1238613reerected
reested82916233re_ested
refaced133713573refac_ed
refect114319333refect__
refects124012743refect_s
refeed104717623refe__ed
refelled122810173refelled
refenced1439003refenced
refereed12149693refereed
referred1297833referred
refitted12309413refitted
reflated123514293reflated
refracted1557393refracted
refuted114313803ref_uted
reheated122415003reheated
reinfected1645253reinfected
rejectee17289623rejectee
rejecter17258943rejecter
relented92614943relented
relucted1138653relucted
remelted11310153remelted
renested92212953renested
repeated113117443repeated
repented112614983repented
rerented92516163rerented
reseated93220263reseated
resented92716963resented
respected1438493respected
retested92212533retested
reverted122714713reverted
revested122612243revested
revetted122210943revetted
rewetted12228353rewetted
selectee10910493selectee
undefeated1546203undefeated
undetected1444873undetected
unelected1237823unelected
unfelted1279403unfelted
weeted103913793we_e_ted

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.466383457.1
2DLD Change Limit1461622616.87621256.8
3Display Results2612610.1102372.7
 (SQL Overall)1786912617.45223978.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.