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

124 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
descanted133667(None) 
decanted122310491de_canted
descanter1246441descanter
discanted1339331discanted
decanter112510792de_canter
desalted1038312des_alted
desanded11227452des_anded
descant104315592descant__
descanters1345012descanters
descants112910142descant_s
descended1446282descended
recanted112513512re_canted
scanted104114392__scanted
canted94825783___canted
deaconed1237493deacon_ed
dealated103213603deala_ted
deaned84620453de__an_ed
debated113916083de_ba_ted
decamped1634963de_camped
decane93818873de_can_e_
decanes103118913de_can_es
decant93524223de_cant__
decanters12229223de_canters
decants103514443de_cant_s
decayed14309333de_ca_yed
decenter112412163de_center
decentred13236233de_centred
decocted1437683de_cocted
dedicated14310253dedica_ted
defanged1435433de_fanged
defatted1335673de_fatted
defeated132812163defea_ted
defecated1637493defeca_ted
deflated133412303defla_ted
delated93722873de_la_ted
demanded13348513de_manded
demasted1238763de_masted
demeaned1237283demean_ed
demented12311273de_mented
demounted1344903demounted
dentated10411703denta_ted
dented84120513de___nted
depainted1375843depainted
departed1238823de_parted
deplaned1238663deplan_ed
deranged1137693de_ranged
derated93623503de_ra_ted
deratted1048403de_ratted
desalter938363des_alter
desand84812633des_an__d
descanting1446923descanting
descend11248153descen__d
descender1346663descender
descent102616293descent__
descents112511203descent_s
described1544953described
descried1248073desc_ried
desecrated1447953desecrated
deserted101012203des_erted
desiccated1644993desiccated
designated1345933designated
designed1136943design_ed
desisted1039783des_isted
desolated1139653desolated
despaired1344503despaired
despited1248323des_pited
desponded1445323desponded
destained1158253destained
destined103312453destin_ed
detonated1138213detonated
detracted1357793detracted
deviated13311043devia_ted
disbanded1445643disbanded
discalced1545653discalced
discant103017263discant__
discants112912023discant_s
discarded1437083discarded
discased122510853disca_sed
discepted1547523discepted
discounted1447843discounted
dismantled1443693dismantled
dismasted1346833dismasted
disparted1338853disparted
displanted14126633displanted
disrated10915573disra_ted
dissented1199723dissented
distanced1348573distanced
distasted1137963distasted
educated1237943educa_ted
enchanted1546553_enchanted
escalated1247303_escalated
escaped12388853_esca_ped
escarped1355163_escarped
escorted1136703_escorted
escoted1038183_esc_oted
estated83715573_esta_ted
gestated102910573gesta_ted
incanted11259543_incanted
levanted1245323le_vanted
merchanted1844483merchanted
recaned102817203re_can_ed
recanter101913153re_canter
regranted1137703regranted
replanted1248063replanted
rescaled113311303resca_led
rescinded1335763rescinded
reseated93220263resea_ted
resented92716963res_ented
resinated10413283resinated
reslated93517523resla_ted
resonated10510613resonated
restarted10410053restarted
restated93120183resta_ted
scanned104110893__scanned
scanter94215183__scanter
scarted104816123__scarted
scatted103512773__scatted
scented102811883__scented
slanted83514743__slanted
tenanted937043te_nanted
unscanned1245133unscanned
unscented1237513unscented
vesicated15117653vesica_ted
webcasted1741973webcasted

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411247.86018911.1
3Display Results1241240.0631968.3
 (SQL Overall)1786911248.37621333.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.