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

119 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
discanted133933(None) 
descanted1336671descanted
decanted122310492d_ecanted
descanter1246442descanter
disbanded1445642disbanded
discalced1545652discalced
discant103017262discant__
discants112912022discant_s
discarded1437082discarded
discased122510852disca_sed
discepted1547532discepted
discounted1447842discounted
dismantled1443692dismantled
dismasted1346832dismasted
disparted1338852disparted
displanted14126632displanted
disrated10915572disra_ted
dissented1199722dissented
distanced1348572distanced
distasted1137962distasted
incanted11259542_incanted
scanted104114392__scanted
canted94825783___canted
decanter112510793d_ecanter
desalted1038313des_alted
desanded11227453des_anded
descant104315593descant__
descanters1345013descanters
descants112910143descant_s
descended1446283descended
diamante1186423diamante_
diamantes1296263diamantes
dictated1239203di_ctated
dilated93115823di_la_ted
dinted84419843di___nted
disabled1248713dis_abled
disarmed1238643dis_armed
disaster949943dis_aster
disband1138243disban__d
disbarred1345283disbarred
discanting1449453discanting
discard11310213disca__rd
discarder1346753discarder
discarnate1346043discarnate_
discase102912863disca_se_
discases112014503disca_ses
disced104914653disc___ed
discerned1347863discerned
discharged1864453discharged
discipled1545673discipled
disclaimed1644413disclaimed
disclosed1347363disclosed
discoed11312483disc__oed
discontent13410253discontent
discorded1438133discorded
discounter1347023discounter
discrete11410283discrete_
discussed13256763discussed
disdained1246023disdained
diseased103011713disea_sed
disenchanted1952263disenchanted
disgusted1246123disgusted
disinter9310673dis_inter
disjected2086353disjected
disjointed1944833disjointed
dislocated1497523disloca_ted
dismantle1245043dismantle
dismantles1344333dismantles
dismayed1535743disma_yed
dismounted1445413dismounted
disowned1336433disown_ed
dispended14147823dispended
dispensed13158773dispensed
disported13310303disported
disputed1238353dis_puted
disrate81418523disra_te_
disrates91118153disra_tes
disrooted1147623disrooted
disrupted1345973disrupted
dissaved1337313dissa_ved
disseated11711083disseated
dissected13108663dissected
dissenter1059133dissenter
disserted11109813disserted
distained1139603distained
distance11311853distance_
distances12311653distances
distant83519953distant__
distantly1346393distantly
distaste939943distaste_
distastes1039633distastes
distended12157923distended
distorted1139373distorted
distracted1448873distracted
disunited1177273disunited
disvalued1444193disvalued
incented112412553_incented
islanded1035513_islanded
misacted1338673mis_acted
miscalled1447443miscalled
miscited13310423misc_ited
miscounted1546063miscounted
misdated121211123misda_ted
mishanter1446453mishanter
mismated131111333misma_ted
mispainted1545013mispainted
misparted1437263misparted
misplanted1565443misplanted
misrated111315383misra_ted
picante11310523pi_cante_
recanted112513513_recanted
scanned104110893__scanned
scanter94215183__scanter
scarted104816123__scarted
scatted103512773__scatted
scented102811893__scented
slanted83514743__slanted
unscanned1245133unscanned
unscented1237513unscented

Search took 8 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.420425454.8
2DLD Change Limit1486411196.69022218.4
3Display Results1191190.0601983.3
 (SQL Overall)1786911197.17024922.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.