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

145 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
medicated1541007(None) 
dedicated14310251dedicated
mediated123011871medi_ated
medicate13513241medicate_
medicates14312111medicates
meditated1348081meditated
abdicated1547012abdicated
dedicate12312802dedicate_
dedicatee13410342dedicatee
dedicates13311692dedicates
educated1237942_educated
indicated13310952indicated
mediate103415212medi_ate_
mediates112814062medi_ates
medicaid1445782medica_id
medicare1347482medicare_
medicares1446872medicares
medicined1545112medicined
meditate11310622meditate_
meditates1239812meditates
medivaced1843132medivaced
metricated1547302metricated
muricated1448242muricated
predicated1649142predicated
radicated13410122radicated
redictated1447482redictated
unmedicated1744102unmedicated
vesicated15117652vesicated
abdicate1348903abdicate_
abdicates1448153abdicates
addicted1345073addic_ted
bedighted1744583bedighted
decimated1548953decimated
dedicatedly1952503dedicatedly
dedicatees1445313dedicatees
dedicator1348253dedicator
deducted1356243deduc_ted
defecated1637493defecated
delicate11315493delicate_
delicates12314313delicates
depicted1437743depic_ted
depilated1339653depilated
desiccated1644993desiccated
deviated13311043devi_ated
dictated1239203__dictated
dilated93115823__dilated
edited83913673_edi__ted
educate10310213_educate_
educates1139623_educates
elicited1139093_elicited
emaciated1446933emaciated
epilated11310753_epilated
eradicated1446873eradicated
evicted1337243_evic_ted
federated1438423federated
geminated1338553geminated
hesitated1377783hesitated
imbricated1744563imbricated
implicated1745973implicated
indicate11313353indicate_
indicates12312583indicates
indicted1249203indic_ted
iodinated1146943iodinated
levigated1445643levigated
levitated1346413levitated
loricated1247903loricated
maledicted1642543maledic_ted
manducated1644563manducated
marinated122513173marinated
masticated1548233masticated
meated94222403me___ated
medaled113411613med__aled
medevaced1842333medevaced
mediacies1447183mediacies
mediad104313713medi_a__d
mediae94217413medi_a_e_
mediately1544613medi_ately
mediatized2344753medi_atized
mediator1139043medi_ator
medicable1647503medicable
medicaids1544003medicaids
medical12312513medica__l
medically17310113medically
medicals1349363medica_ls
medicament1744883medicament
medicant13910833medica_nt
medicants1466783medicants
medicating1648953medicating
medication15411173medication
medicide1447713medicide_
medicides1556583medicides
medicine1349543medicine_
medicines1447903medicines
meditator1246593meditator
medivacked2351283medivacked
medullated1442993medullated
meliorated1377013meliorated
meniscate1346223meniscate_
merited10313853meri__ted
metricate1349923metricate_
metricates1449123metricates
militated1248803militated
miseducated1752223miseducated
mitigated1347083mitigated
moderated1388143moderated
modulated1336713modulated
motivated1545963motivated
muriated1139793muri_ated
muricate12311113muricate_
mutilated1239453mutilated
myelinated1643353myelinated
pedicled1436463pedic_led
pedicured1543593pedicured
plicated13310643_plicated
predicate14411783predicate_
predicates15410823predicates
predicted1538913predic_ted
radiated102512593radi_ated
radicate11412873radicate_
radicates12412073radicates
redacted12410243redac_ted
redated93120923red__ated
rededicated16144813rededicated
redialed10310793redi_aled
redictate1249063redictate_
redictates1348233redictates
reeducated1484823reeducated
relocated12710813relocated
remediated1446553remedi_ated
replicated1548773replicated
resinated10413283resinated
sedated93714353sed__ated
seriated92717023seri_ated
sonicated1248453sonicated
spicated13309903_spicated
syndicated1743743syndicated
tunicated12257493tunicated
undedicated1654813undedicated
uneducated1444523uneducated
unmediated1445163unmedi_ated
urticated1247703urticated
vellicated1644803vellicated
vesicate131210053vesicate_
vesicates14119033vesicates
vindicated1745123vindicated

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.406440125.6
2DLD Change Limit1486411458.14018260.6
3Display Results1451450.0801812.5
 (SQL Overall)1786911458.62620715.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.