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

321 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
deserted10101220(None) 
deserter91211601deserter
deserved13108131deserved
asserted957902asserted
deaerated11311112deaerated
decerned1237262decerned
defeated132812162defeated
defected15289972defected
deferred13106362deferred
degermed1335452degermed
dehorted1357302dehorted
dejected19307592dejected
deleted93314902dele_ted
demented12311272demented
demerged13157602demerged
demerited1339072demerited
departed1238822departed
depermed1436452depermed
deported1249702deported
desalted1038312desalted
descried1248072descried
desecrated1447952desecrated
desert72725492desert__
deserters10129982deserters
desertic1147742desertic
deserts82513052desert_s
deserve11108702deserve_
deserver12118382deserver
deserves12109892deserves
desexed1636172dese_xed
desired9311982desir_ed
desisted1039782desisted
desorbed1236442desorbed
despited1248322despited
detected12289732detected
deterged11127922deterged
deterred10137802deterred
detested10279622detested
devested13239132devested
disserted11109812disserted
diverted13199582diverted
everted112711852_everted
exerted152210052_exerted
exserted1636212exserted
inserted92413052inserted
reseated93220262reseated
resected112514742resected
resented92716962resented
reserved121010582reserved
resorted9313492resorted
reverted122714712reverted
absented1156613absented
adverted1336103adverted
alerted82512223_alerted
assented957513assented
asserter877573asserter
assorted956603assorted
averted112211613_averted
beseemed1334853beseemed
besetter10137973besetter
besotted1135843besotted
bested94922753bes__ted
bisected1336203bisected
caseated11310713caseated
cemented1338373cemented
coexerted1944763coexerted
darted84620923d__arted
deaerate9314173deaerate_
deaerates10313643deaerates
deaired9411533deair_ed
dealated103213603dealated
debarked16175823debarked
debarred12165633debarred
debated113916083de_bated
debeaked1634613debeaked
debearded1443373debearded
debited113311623de_bited
debuted11379333de_buted
decanted122310493decanted
deceased1247713deceased
deceived1535893deceived
decenter112412163decenter
decentred13236233decentred
decocted1437683decocted
decorated13312203decorated
decreed112710253de_creed
decried112612853de_cried
decurved1534843decurved
deducted1356243deducted
deeded94615543de_e_ded
deemed104713063de_e_med
deerweed1344183de_erweed
defatted1335673defatted
defeater122611663defeater
defecated1637493defecated
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferrer12135593deferrer
deflated133412303deflated
deflected1635983deflected
deforced15247373deforced
deformed15248263deformed
degreed10258883de_greed
degusted1135733degusted
dehorned1345683dehorned
delated93722873de_lated
deleaded1148333deleaded
deleaved1346573deleaved
delegated1238373delegated
delete73620703dele_te_
deletes83117933dele_tes
delisted10310563delisted
demarked16187223demarked
demasted1238763demasted
demeaned1237283demeaned
demerge11168023demerge_
demerger12127373demerger
demerges12129503demerges
demitted12288773demitted
demoted114313543de_moted
demurred1234933demurred
denervated1545113denervated
denoted93512763de_noted
dentated10411703dentated
dented84120513d__ented
departee1139723departee
depended1337983depended
depicted1437743depicted
depleted12258713depleted
deportee11510353deportee
deporter1169393deporter
depurated1338183depurated
deputed114610173de_puted
derated93623503de_rated
deratted1048403deratted
desalter938363desalter
desanded11227453desanded
descanted1336673descanted
descended1446283descended
described1544953described
descrier1157623descrier
descries11311923descries
desecrate1249083desecrate_
desecrater1346983desecrater
desecrates1348843desecrates
deselected1444083deselected
desertified1654103desertified
desertify1643643desertify
deserting11713143deserting
desertion10410203desertion
deservedly1852603deservedly
deservers13107293deservers
desexes1537833dese_xes
desiderated1444943desiderated
designed1136943designed
desire7415303desir_e_
desirer8310783desir_er
desires81316133desir_es
desolated1139653desolated
desperate12410843desperate_
despised1236923despised
despite10410123despite_
despites11410313despites
dessert82916453dessert__
desserts9247923dessert_s
destined103312453destined
destrier9311823destrier
destroyed1445083destroyed
destructed1445413destructed
detecter11298733detecter
detente83313603detente_
detentes92712873detentes
deterge9118463deterge_
deterger10147593deterger
deterges101510093deterges
deterrer9137013deterrer
detester9239683detester
deuterated1247533deuterated
deveined1336673deveined
develed123611933deve_led
deviated13311043deviated
devoted124111093de_voted
dewormed15236223dewormed
dieseled1035523diese_led
dieted83115493d_ie_ted
digested11208163digested
directed1238233directed
disarmed1238643disarmed
discepted1547523discepted
discerned1347863discerned
diseased103011713diseased
disherited1546703disherited
disjected2086353disjected
disparted1338853disparted
dispersed13119783dispersed
disported13310303disported
disputed1238353disputed
disrated10915573disrated
disseated11711083disseated
dissected13108663dissected
dissented1199723dissented
disserved14107003disserved
distorted1139373distorted
diverged14256883diverged
diverter12238623diverter
divested13268213divested
dowered122811553dower_ed
dueted84113593d_ue_ted
duetted937023d_uetted
dusted83918373dus__ted
egested938123_egested
ejected17297653_ejected
elected102812613_elected
emerged11158213_emerged
emersed10138513_emersed
enserfed1245193enserfed
erected103213993_erected
escorted1136703_escorted
escoted1038183_escoted
estated83715573_estated
experted1838053experted
exsected1835673exsected
federated1438423federated
ferreted1236323ferreted
festered122512103fester_ed
fevered14339723fever_ed
generated11310203generated
gestated102910573gestated
hearted113314023he_arted
inserter82312133inserter
insetted9249023insetted
inverted122312163inverted
jeered143912793je_er_ed
jested144416503jes__ted
leered73816223le_er_ed
levered114212303lever_ed
meseemed1343963meseemed
metered103514013meter_ed
nested74720063nes__ted
observed1444373observed
obverted1435103obverted
peered93819483pe_er_ed
perverted1546093perverted
pestered112814953pester_ed
petered103314963peter_ed
presented12311633presented
preserved15107563preserved
presorted1239453presorted
reasserted1145413reasserted
reested82916233re_ested
refected142311663refected
refereed12149693refereed
referred1297833referred
reheated122415003reheated
reinserted1146683reinserted
rejected182710113rejected
relented92614943relented
remelted11310153remelted
remerged12149173remerged
renested92212953renested
repeated113117443repeated
repented112614983repented
reperked15177793reperked
reported11312703reported
rerented92516163rerented
resealed92713963resealed
reseed74823293rese__ed
reseeded1038093reseeded
reseized1839213reseized
reserve101011203reserve_
reserver11119633reserver
reserves111011983reserves
resetter81511833resetter
resettled1035303resettled
resewed113011823rese_wed
resifted12310153resifted
resisted9312693resisted
resited85122423res_ited
reslated93517523reslated
resmelted1236033resmelted
resorbed1138533resorbed
resorter8312183resorter
respected1438493respected
respited11410813respited
restarted10410053restarted
restated93120183restated
rested74430783res__ted
resulted939713resulted
resurged1038623resurged
retested92212533retested
retorted9312333retorted
reverbed14269223reverbed
revered112819333rever_ed
reversed122711613reversed
reverter114812873reverter
revested122612243revested
revetted122210943revetted
rewetted12228353rewetted
rezeroed1835993rezeroed
seated75131053__seated
secerned1136103secerned
secreted1138633secreted
selected1159783selected
sered65737293__ser_ed
serged84118763__serged
served104616813__served
severed113513863sever_ed
sewered112911243sewer_ed
sorted74523713__sorted
tested74421523tes__ted
undeserved1544163undeserved
unseated91317683unseated
unserved12410233unserved
unsorted9312513unsorted
veered103612743ve_er_ed
venerated1339953venerated
vested104217353ves__ted
weeted103913793we_e_ted
westered122511863wester_ed
zested164214043zes__ted

Search took 10 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.1561145455.1
2DLD Change Limit1461623218.93616356.5
3Display Results3213210.1432244.8
 (SQL Overall)1786913219.23519349.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.