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

190 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
desanded1122745(None) 
demanded13348511demanded
deaned84620452de_an_ed
decanted122310492decanted
defanged1435432defanged
defended1437222defended
defunded1435162defunded
demander12238722demander
depended1337982depended
deranged1137692deranged
desalted1038312desalted
desand84812632desan__d
desands94810162desand_s
descanted1336672descanted
descended1446282descended
desponded1445322desponded
disbanded1445642disbanded
relanded102410462relanded
remanded123011322remanded
sanded84920612__sanded
banded105223173__banded
beaded104922423be_a_ded
beaned95621473be_an_ed
bearded114212133be_arded
belauded1244793belauded
bended105521233be__nded
branded114414103_branded
danced105315253d__anced
dander811222993d__ander
dandled103313543d__andled
danged94819483d__anged
deaden83714323de_a_den
deader84220473de_a_der
deaired9411533de_aired
deashed123411303de_ashed
deaved114916553de_a_ved
debagged1433723debagged
debarked16175823debarked
debarred12165633debarred
debased113310583deba_sed
debated113916083deba_ted
debearded1443373debearded
deboned113411633debon_ed
debrided1336583debrided
debunked1633193debunked
decade104216163deca_de_
decades113615513deca_des
decamped1634963decamped
decane93818873decan_e_
decanes103118913decan_es
decanter112510793decanter
decayed14309333deca_yed
decided124312423de_cided
decoded123212383de_coded
deeded94615543de__eded
defaced142910973defa_ced
defamed14309833defa_med
defatted1335673defatted
defenced1537203defenced
defender1337293defender
defensed1336223defensed
defined123813823defin_ed
defrauded1542823defrauded
degassed11275963degassed
degender1136893degender
degraded12288323degraded
deigned1037503deign_ed
delated93722873dela_ted
delayed123310763dela_yed
deleaded1148333deleaded
deluded10158763de_luded
demand104314253deman__d
demanders13247573demanders
demands114311413demand_s
demarked16187223demarked
demasted1238763demasted
demeaned1237283demean_ed
demented12311273demented
demoded123611123de_moded
denied84318633de__nied
denned84215633de__nned
dented84120513de__nted
denuded10167663de_nuded
depainted1375843depainted
departed1238823departed
deplaned1238663deplan_ed
deponed113712873depon_ed
derailed102410403derailed
derange939813derange_
deranger1037353deranger
deranges1039973deranges
derated93623503dera_ted
deratted1048403deratted
derided102914253de_rided
desalter938363desalter
desanding12207653desanding
descanter1246443descanter
descender1346663descender
descried1248073descried
deserted101012203deserted
deserved13108133deserved
desexed1636183des_exed
designed1136943designed
desired9311983des_ired
desisted1039783desisted
desorbed1236443desorbed
despaired1344503despaired
despised1236923despised
despited1248323despited
destained1158253destained
destined103312453destined
detached1537733detached
detailed10319873detailed
detained103111643detained
detruded1134883detruded
devalued1335013devalued
dewaxed19316053dewa_xed
dezinced2183903dezinced
disabled1248713disabled
disarmed1238643disarmed
discanted1339333discanted
discarded1437083discarded
dispended14147823dispended
distanced1348573distanced
distended12157923distended
dreaded103612023drea_ded
drownded14334433drownded
emended11329603_emended
ended74421263_e__nded
evaded1137063_eva_ded
expanded19145163expanded
fended114216913fe__nded
handed114919983__handed
headed114020473he_a_ded
heralded1335443heralded
husbanded1642853husbanded
islanded1035513islanded
jeaned143813463je_an_ed
landed84619243__landed
leaded84221543le_a_ded
leaned73422543le_an_ed
levanted1245323levanted
meander1049973me_ander
mended104418683me__nded
misadded1335753misadded
penanced1338163penanced
pended103819013pe__nded
pesade9311103pesa_de_
pesades10310903pesa_des
readded103310733re_added
recaned102817203recan_ed
recanted112513513recanted
redemanded1543233redemanded
refunded1336953refunded
regarded11279803regarded
rehandled1444763rehandled
rehanged1357833rehanged
remanned11319353remanned
remended123010393remended
reminded123411523reminded
rended84524103re__nded
resaddled1294253resaddled
resailed93613063resailed
resawed113111183resa_wed
rescinded1335763rescinded
reseeded1038093reseeded
resented92716963resented
resided95217703res_ided
resined84522653resin_ed
resodded1136353resodded
resounded1136323resounded
respaded1238133respaded
responded1336513responded
retarded102410753retarded
rewarded13229523rewarded
rewinded13277673rewinded
sander74828533__sander
saned65636273__san_ed
seconded1236353seconded
sended85121233__sended
stranded102710813stranded
tenanted937043tenanted
tended83819483te__nded
unbanded123010563unbanded
unhanded132910183unhanded
vended114416353ve__nded
verandaed1443143verandaed
weaned103816153we_an_ed
wended113616153we__nded
yeaned103813903ye_an_ed

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621907.08020644.4
3Display Results1901900.0603166.7
 (SQL Overall)1786911907.56023636.4
 
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.