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

101 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
discarded143708(None) 
discarder1346751discarder
discorded1438131discorded
disarmed1238642dis_armed
disbanded1445642disbanded
disbarred1345282disbarred
discalced1545652discalced
discanted1339332discanted
discard11310212discar__d
discarders1445042discarders
discards1238912discard_s
discased122510852disca_sed
discerned1347862discerned
discharged1864452discharged
disparted1338852disparted
ascared10399523_ascar_ed
carded105424903___carded
cascaded14135703casca_ded
debearded1443373debearded
desanded11227453des_anded
descanted1336673descanted
descended1446283descended
descried1248083desc_ried
disabled1248713dis_abled
disaccorded1851923disaccorded
disagreed1245463disagreed
disarmer1138033dis_armer
disbudded1543293disbudded
disburden1344143disburden
disbursed1365763disbursed
discarding1547343discarding
discase102912863disca_se_
discases112014503disca_ses
disced104914653disc___ed
discepted1547533discepted
discerner1246943discerner
discharge1664843discharge_
dischargee1774553dischargee
discharger1763893discharger
discharges1765443discharges
discipled1545673discipled
disclaimed1644413disclaimed
disclosed1347363disclosed
discoed11312483disc__oed
discord1139993discor__d
discords1238593discord_s
discoursed1445793discoursed
discreet11413183disc_reet
discussed13256763discussed
disdained1246023disdained
diseased103011713disea_sed
disgorged1345263disgorged
disgraced1446743disgraced
dismasted1346833dismasted
dismayed1535743disma_yed
disorder1038133dis_order
disparaged1545043disparaged
dispended14147823dispended
dispersed13119783dispersed
disploded1446543disploded
disported13310303disported
disrated10915573disra_ted
disregarded1562083disregarded
dissaved1337313dissa_ved
disserted11109813disserted
disserved14107003disserved
dissuaded1265433dissuaded
distained1139603distained
distanced1348573distanced
distasted1137963distasted
distended12157923distended
distorted1139373distorted
disturbed13195583disturbed
disvalued1444193disvalued
escarped1355163_escarped
islanded1035513_islanded
mascaraed1454093mascaraed
misadded1335753mis_added
misawarded1742713misawarded
miscalled1447443miscalled
miscarried1543823miscarried
mischarged1964273mischarged
miscoded1437983misc_oded
misgraded1446233misgraded
mismarked1845243mismarked
misparsed1446253misparsed
misparted1437263misparted
misworded1644233misworded
niggarded1342643niggarded
piscaries13410073piscaries
placarded1543263placarded
scalded11409763__scalded
scared95227293__scar_ed
scarfed134711183__scarfed
scarped124314403__scarped
scarred104512633__scarred
scarted104816123__scarted
swarded1238153__swarded
uncarded12310133_uncarded
unscarred1235673unscarred
vizarded2242753vi_zarded

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.500357382.0
2DLD Change Limit1486411017.73319221.6
3Display Results1011010.0462195.7
 (SQL Overall)1786911018.27921583.6
 
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.