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

245 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
detested1027962(None) 
detected12289731detected
detester9239681detester
devested13239131devested
retested92212531retested
attested936302attested
defeated132812162defeated
defected15289972defected
degusted1135732degusted
dejected19307592dejected
deleted93314912dele_ted
delisted10310562delisted
demasted1238762demasted
demented12311272demented
deserted101012202deserted
desisted1039782desisted
detecter11298732detecter
detente83313602detente_
detentes92712872detentes
deterged11127922deterged
deterred10137802deterred
detest74122842detest__
detesters10298302detesters
detests83711742detest_s
digested11208162digested
divested13268212divested
egested938122_egested
obtested1135452obtested
pretested12149112pretested
reested82916232re_ested
renested92212952renested
retasted92412112retasted
revested122612242revested
tested74421522__tested
untested92612422untested
arrested939163arrested
attester836503attester
bemisted1368383bemisted
bested94922763__bested
betted94721163bet__ted
celeste949653celeste_
celestes10310013celestes
cemented1338373cemented
chested133811673_chested
contested12310703contested
crested103416543_crested
deaerated11311123deaerated
dealated103213603dealated
deashed123411303de_ashed
debased113310583debas_ed
debated113916083de_bated
debeaked1634613debeaked
debited113311623de_bited
debuted11379333de_buted
decanted122310493decanted
deceased1247723deceased
deceived1535893deceived
decenter112412163decenter
decentred13236233decentred
decerned1237263decerned
decocted1437693decocted
deducted1356243deducted
deeded94615543de_e_ded
deemed104713063de_e_med
deemster1175713deemster
defatted1335673defatted
defeater122611663defeater
defecated1637493defecated
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferred13106363deferred
deflated133412303deflated
deflected1635983deflected
deforested1543853deforested
defrosted1444263defrosted
deftest112611713deftest__
defused125211093defus_ed
degassed11275963degassed
degermed1335453degermed
dehisced1583683dehisced
dehorted1357303dehorted
delated93722873de_lated
deleaded1148333deleaded
deleaved1346573deleaved
delegated1238373delegated
delete73620703dele_te_
deletes83117933dele_tes
deluster936903deluster
demeaned1237283demeaned
demerged13157603demerged
demerited1339073demerited
demesne1035573demesne_
demesnes1137083demesnes
demised113613683demis_ed
demister11310223demister
demitted12288773demitted
demoted114313543de_moted
dempster1355773dempster
denoted93512763de_noted
dentated10411703dentated
dented84120513d__ented
departed1238823departed
depended1337983depended
depermed1436453depermed
depicted1437743depicted
depleted12258723depleted
deported1249703deported
deposed113412033depos_ed
deposited1346783deposited
depressed1357633depressed
deputed114610173de_puted
derated93623503de_rated
deratted1048403deratted
dermestid1343533dermestid
desalted1038313desalted
deserter91211603deserter
deserved13108133deserved
desexed1636183dese_xed
despited1248323despited
detached1537733detached
detailed10319873detailed
detained103111643detained
detassel943653detassel
detect94217403detect__
detecters12217753detecters
detector11278323detector
detects104011093detect_s
detent73624483detent__
detents83615153detent_s
deterge9118463deterge_
deterger10147593deterger
deterges101510093deterges
deterrer9137013deterrer
detesting112610323detesting
deticked1635693deticked
detonated1138213detonated
detoured1036513detoured
detoxed1636103det_oxed
detracted1357793detracted
detruded1134883detruded
deuterated1247543deuterated
deveined1336673deveined
develed123611933deve_led
devest104418703devest__
devests114410473devest_s
deviated13311043deviated
devised123712563devis_ed
devoted124111093de_voted
diester83013683d_iester
dieted83115493d_ie_ted
digester10258433digester
directed1238233directed
distasted1137963distasted
diverted13199583diverted
dopester1137253dopester
dotted84717523dot__ted
dressed93511873d_ressed
dueted84113593d_ue_ted
duetted937023d_uetted
dusted83918373d__usted
ejected17297653_ejected
elected102812613_elected
erected103213993_erected
everted112711853_everted
exerted152210053_exerted
existed1538473_existed
feasted11310843fe_asted
fetted104817893fet__ted
forested12312463forested
guested9157713_guested
heisted113210653he_isted
infested12249643infested
ingested10259003ingested
invested12229693invested
jested144416503__jested
jetted143915083jet__ted
keester11319913ke_ester
letted74118543let__ted
metered103514013mete_red
molested11178243molested
nested74720073__nested
netted74118713net__ted
obtected1344553obtected
oersted839563oe_rsted
patented1188893patented
petered103314973pete_red
petted94121523pet__ted
pretasted12147963pretasted
pretexted19135693pretexted
priested1138393priested
protested12159113protested
quested17168393_quested
recessed1139723recessed
refected142311663refected
reheated122415003reheated
rejected182710113rejected
relented92614943relented
relisted9312623relisted
remelted11310153remelted
repasted112611533repasted
repeated113117443repeated
repented112614983repented
requested1935893requested
rerented92516163rerented
reseated93220263reseated
resected112514743resected
resented92716963resented
resisted9312693resisted
rested74430783__rested
retaste72313133retaste_
retastes82212903retastes
reteamed1138013reteamed
retest64028453retest__
retests73813853retest_s
retinted94414363retinted
retorted9312333retorted
retreated10312633retreated
retted74826313ret__ted
retwisted1344893retwisted
reverted122714713reverted
revetted122210943revetted
rewetted12228353rewetted
selected1159783selected
semester1038903semester
stetted82610403_stetted
tasted74123973__tasted
teated74924023__teated
tempested1444033tempested
tented74221003__tented
testee64323303__testee
tester64227153__tester
testes65125823__testes
undetected1444873undetected
unrested91914523unrested
untasted92011573untasted
untented92613413untented
unvested122210223unvested
vested104217353__vested
vetted104316323vet__ted
weeted103913793we_e_ted
wetted103717023wet__ted
wrested113410933_wrested
yeasted1138503ye_asted
zested164214043__zested

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.470380193.6
2DLD Change Limit1461622457.53319402.9
3Display Results2452450.1062311.3
 (SQL Overall)1786912458.10922036.1
 
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.