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

259 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
devested1323913(None) 
detested10279621detested
divested13268211divested
revested122612241revested
defeated132812162defeated
defected15289972defected
degusted1135732degusted
dejected19307592dejected
deleted93314902dele_ted
delisted10310562delisted
demasted1238762demasted
demented12311272demented
deserted101012202deserted
desisted1039782desisted
detected12289732detected
detester9239682detester
deveined1336672deveined
develed123611932deve_led
devest104418702devest__
devests114410472devest_s
deviated13311042deviated
devised123712562devis_ed
devoted124111092dev_oted
digested11208162digested
diverted13199582diverted
egested938122_egested
everted112711852_everted
invested12229692invested
reested82916232re_ested
renested92212952renested
retested92212532retested
reverted122714712reverted
revetted122210942revetted
unvested122210222unvested
vested104217352__vested
advected1534533advected
adverted1336103adverted
arrested939153arrested
attested936293attested
averted112211613_averted
bemisted1368383bemisted
bested94922753__bested
beveled133811123beve_led
bevelled14327793bevelled
breveted1435623breve_ted
brevetted1543863brevetted
caveated1439133caveated
celeste949653celeste_
celestes10310013celestes
cemented1338373cemented
chested133811673_chested
coveted133011523cove_ted
crested103416533_crested
davened124610073dave_ned
deaerated11311113deaerated
dealated103213603dealated
deashed123411303de_ashed
debased113310583debas_ed
debated113916083de_bated
debeaked1634613debeaked
debited113311623de_bited
debuted11379333de_buted
decanted122310493decanted
deceased1247713deceased
deceived1535893deceived
decenter112412163decenter
decentred13236233decentred
decerned1237263decerned
decocted1437683decocted
deducted1356243deducted
deeded94615543de_e_ded
deemed104713063de_e_med
deemster1175713deemster
defatted1335673defatted
defeater122611663defeater
defecated1637493defecated
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferred13106363deferred
deflated133412303deflated
deflected1635983deflected
deforested1543843deforested
defrosted1444253defrosted
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
depleted12258713depleted
deported1249703deported
deposed113412023depos_ed
deposited1346773deposited
depressed1357623depressed
deputed114610173de_puted
derated93623503de_rated
deratted1048403deratted
dermestid1343533dermestid
desalted1038313desalted
deserter91211603deserter
deserved13108133deserved
desexed1636173dese_xed
despited1248323despited
detecter11298733detecter
detente83313603detente_
detentes92712873detentes
deterged11127923deterged
deterred10137803deterred
detest74122843detest__
detesters10298303detesters
detests83711743detest_s
devalued1335013devalued
devastated1544123devastated
developed16124313developed
devesting14249903devesting
deviate11312713deviate_
deviates12312733deviates
deviled124112183dev_iled
devilled1336743devilled
devise104215753devis_e_
devisee113812713devis_ee
devisees12358283devisees
deviser114212393devis_er
devises114116763devis_es
devoiced15276063devoiced
devolved16325513devolved
devote104513783dev_ote_
devotee113811823dev_otee
devotes113713753dev_otes
devoured1335723devoured
devouter1235513devouter
diester83013683d_iester
dieted83115493d_ie_ted
digester10258433digester
directed1238233directed
diverged14256883diverged
diverter12238623diverter
divest106820073divest__
divests114510933divest_s
dopester1137253dopester
dovened12389063dove_ned
dressed93511873d_ressed
dueted84113593d_ue_ted
duetted937023d_uetted
dusted83918373d__usted
ejected17297653_ejected
elected102812613_elected
erected103213993_erected
evened101010313_eve_ned
evicted1337243_evicted
evited104013143_ev_ited
exerted152210053_exerted
existed1538473_existed
feasted11310843fe_asted
fevered14339723feve_red
forested12312463forested
foveated1536293foveated
guested9157713_guested
harvested1644093harvested
heisted113210653he_isted
infested12249643infested
ingested10259003ingested
invected14258883invected
invented122510663invented
inverted122312163inverted
jested144416503__jested
keester11319913ke_ester
levanted1245323levanted
leveed104111373leve__ed
leveled114010383leve_led
levelled12327443levelled
levered114212303leve_red
molested11178243molested
nested74720063__nested
nonvested1346003nonvested
obtested1135453obtested
obverted1435103obverted
oersted839553oe_rsted
perverted1546093perverted
pretested12149113pretested
prevented1539003prevented
priested1138393priested
quested17168383_quested
recessed1139713recessed
refected142311663refected
reheated122415003reheated
reinvested1444793reinvested
rejected182710113rejected
relented92614943relented
relisted9312623relisted
remelted11310153remelted
repasted112611533repasted
repeated113117443repeated
repented112614983repented
requested1935893requested
rerented92516163rerented
reseated93220263reseated
resected112514743resected
resented92716963resented
resisted9312693resisted
rested74430783__rested
retasted92412113retasted
revealed123211213revealed
reveled113917753reve_led
revelled123712733revelled
revenged1337553revenged
revenued1237223revenued
reverbed14269223reverbed
revered112819333reve_red
reversed122711613reversed
reverter114812873reverter
revest94623603revest__
revests104413733revest_s
revised113815483revis_ed
revisited1346573revisited
revolted12319863revolted
revoted114314153rev_oted
rewetted12228353rewetted
riveted11258573rive_ted
rivetted12226093rivetted
selected1159783selected
semester1038903semester
severed113513863seve_red
tempested1444033tempested
tested74421523__tested
unrested91914513unrested
untested92612413untested
velveted1533833velve_ted
vented104617923__vented
vestee94319153__vestee
vetted104316323__vetted
weeted103913793we_e_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.1561145455.1
2DLD Change Limit1461622597.79618748.3
3Display Results2592590.1262055.6
 (SQL Overall)1786912598.07822120.7
 
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.