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 “medication” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
medication1541117(None) 
dedication14311961dedication
mediation12312291medi_ation
medications1649931medications
meditation13410741meditation
abdication1548222abdication
dedications15310872dedications
education12310202_education
indication13312032indication
mediations13310982medi_ations
medicating1648952medicating
meditations1449332meditations
metrication15410652metrication
predication16412432predication
abdications1657653abdications
addiction13146013addic_tion
coeducation1646233coeducation
decimation15411623decimation
dedicating1539143dedicating
dedicator1348253dedicat_or
deduction1377083deduc_tion
defecation1679803defecation
deification17411663deification
depiction1437273depic_tion
depilation13312033depilation
derivation14712783derivation
desiccation1646383desiccation
deviation13312403devi_ation
dictation12810563__dictation
diction102313053__dic_tion
dilation92215463__dilation
edification1749353_edification
edition8310853_edi__tion
educations1339233_educations
eduction1169053_educ_tion
emaciation1449283emaciation
epilation11312963_epilation
eradication14410113eradication
eviction13228683_evic_tion
evocation142010293_evocation
federation1449573federation
gemination131410663gemination
hesitation1349633hesitation
imbrication1746463imbrication
implication1747773implication
indications14310973indications
indiction1239813indic_tion
iodination1159983iodination
levigation1447023levigation
levitation1349443levitation
malediction1653113maledic_tion
marination12312813marination
mastication15610293mastication
mediating13311203medi_ating
mediational1445643medi_ational
mediative1548123medi_ative
mediatize2146903medi_atize
mediator1139053medi_at_or
medicaid1445783medica_i_d
medicaids1544003medica_ids
medicate13513243medicat__e
medicated15410073medicat_ed
medicates14312113medicat_es
meditating1448123meditating
meditative1646283meditative
meditator1246593meditat_or
melioration1368183melioration
mentation11313983me_ntation
metrications1649833metrications
miseducation1793453miseducation
mitigation1348643mitigation
moderation1348653moderation
modification20107203modification
modulation13147933modulation
motivation1548083motivation
mutilation1249753mutilation
ordination1149413ordination
plication13311683_plication
predications17411183predications
prediction15410303predic_tion
radiation10313403radi_ation
recitation12315943recitation
redaction1259663redac_tion
rededication1646503rededication
reduction1259903reduc_tion
reeducation1445933reeducation
reification16412903reification
reliction11310693relic_tion
relocation12312113relocation
remediation1449213remedi_ation
replication15712013replication
revocation15410813revocation
sedation9312453sed__ation
sedition939333sedi__tion
seduction1266983seduc_tion
seriation9318063seri_ation
sonication12411183sonication
syndication17124963syndication
urtication1249113urtication
vindication1746353vindication

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit1406031006.28022389.0
3Display Results1001000.0631587.3
 (SQL Overall)1786911006.74926476.7
 
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.