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

246 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
detected1228973(None) 
defected15289971defected
dejected19307591dejected
detecter11298731detecter
detested10279621detested
decocted1437682decocted
deducted1356242deducted
defeated132812162defeated
defecated1637492defecated
deflected1635982deflected
deleted93314912dele_ted
demented12311272demented
depicted1437742depicted
deserted101012202deserted
detached1537732detached
detect94217402detect__
detecters12217752detecters
detector11278322detector
detects104011092detect_s
detente83313602detente_
detentes92712872detentes
deterged11127922deterged
deterred10137802deterred
detester9239682detester
deticked1635692deticked
detracted1357792detracted
devested13239132devested
directed1238232directed
ejected17297652_ejected
elected102812612_elected
erected103213992_erected
obtected1344552obtected
refected142311662refected
rejected182710112rejected
resected112514742resected
retested92212532retested
selected1159782selected
undetected1444872undetected
advected1534533advected
affected1744793affected
attested936293attested
bedecked1874573bedecked
betted94721163bet__ted
bisected1336203bisected
cathected1744543cathected
cemented1338373cemented
coerected1447643coerected
deaerated11311113deaerated
dealated103213603dealated
debated113916083de_bated
debeaked1634613debeaked
debited113311623de_bited
debuted11379333de_buted
decanted122310493decanted
deceased1247713deceased
deceived1535893deceived
decenter112412163decenter
decentred13236233decentred
decerned1237263decerned
decked145217623d__ecked
dedicated14310253dedicated
deduced1266683deduc_ed
deeded94615543de_e_ded
deemed104713063de_e_med
defaced142910973defac_ed
defatted1335673defatted
defeater122611663defeater
defecate1438793defecate_
defecates1538593defecates
defect124816173defect__
defector14277953defector
defects134511523defect_s
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferred13106363deferred
deflated133412303deflated
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
destructed1445413destructed
detacher1437543detacher
detaches1439653detaches
detailed10319873detailed
detained103111643detained
detecting13259983detecting
detection121310413detection
detective1548103detective
detectives1645783detectives
detectors12278303detectors
detent73624483detent__
detents83615153detent_s
deterge9118463deterge_
deterger10147593deterger
deterges101510093deterges
deterrer9137013deterrer
detest74122843detest__
detesters10298303detesters
detests83711743detest_s
deticker1545283deticker
detonated1138213detonated
detoured1036513detoured
detoxed1636103det_oxed
detruded1134883detruded
deuced104112123de_uc_ed
deuterated1247533deuterated
deveined1336673deveined
develed123611933deve_led
deviated13311043deviated
devoted124111093de_voted
dieted83115493d_ie_ted
digested11208163digested
directer1137583directer
disjected2086353disjected
dissected13108663dissected
ditched143711903dit_ched
diverted13199583diverted
divested13268213divested
dotted84717523dot__ted
ducted104012123d__ucted
dueted84113593d_ue_ted
duetted937023d_uetted
effected1744993effected
egested938123_egested
electee92513243_electee
enacted10310643_enacted
erecter93113393_erecter
eructed10228653_eructed
etched123613703_et_ched
everted112711853_everted
evicted1337243_evicted
exacted1737303_exacted
executed1835503_executed
exerted152210053_exerted
expected2036743expected
exsected1835673exsected
fetched163710473fet_ched
fetted104817893fet__ted
infected14229403infected
injected18226753injected
invected14258883invected
jetted143915083jet__ted
leeched13369503le_eched
letched133912053let_ched
letted74118543let__ted
metered103514013mete_red
neglected1354693neglected
netted74118713net__ted
objected2043493objected
obtested1135453obtested
outacted1139383outacted
patented1188893patented
perfected1736643perfected
petered103314973pete_red
petted94121523pet__ted
prelected1439133prelected
pretested12149113pretested
pretexted19135693pretexted
protected14158653protected
reacted103015713re_acted
redacted12410243redacted
redefected1743853redefected
reejected1955093reejected
reelected1238313reelected
reerected1238613reerected
reested82916233re_ested
reflected1547983reflected
reheated122415003reheated
rejectee17289623rejectee
rejecter17258943rejecter
relented92614943relented
relucted1138653relucted
remelted11310153remelted
renested92212953renested
repeated113117443repeated
repented112614983repented
rerented92516163rerented
reseated93220263reseated
resented92716963resented
respected1438493respected
retacked15169273retacked
retasted92412113retasted
retched133814273ret_ched
reteamed1138013reteamed
retinted94414363retinted
retorted9312333retorted
retracted12410953retracted
retreated10312623retreated
retted74826313ret__ted
reverted122714713reverted
revested122612243revested
revetted122210943revetted
rewetted12228353rewetted
selectee10910493selectee
stetted82610403_stetted
teated74924023__teated
teched124014433__teched
tented74221003__tented
tested74421523__tested
tetched133010773tet_ched
unelected1237823unelected
untented92613413untented
untested92612413untested
vetted104316323vet__ted
weeted103913793we_e_ted
wetted103717023wet__ted

Search took 9 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.436409841.7
2DLD Change Limit1461622467.64319123.6
3Display Results2462460.0932645.2
 (SQL Overall)1786912468.17221866.3
 
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.