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

89 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
medicine134954(None) 
medicide1447711medicide
medicined1545111medicined
medicines1447901medicines
medicant13910832medicant
medicare1347482medicare
medicate13513242medicate
medicides1556582medicides
medicinal1445082medicinal
aedine73218393aed__ine
biomedicine18172043biomedicine
colicine12312993colicine
culicine1248343culicine
dedicate12312803dedicate
deducing1336423deducing
deicide1149403de_icide
deicing11312193de_icing
dicing105718763__dicing
divine103514463__divine
edifice1344933_edifice
editing9313133_editing
educing1137683_educing
epicene1148593_epicene
feminine13199783feminine
feticide1447503feticide
helicline1444693helicline
leucine938073le_ucine
meclizine2244123meclizine
medaling121912263medaling
meddling13257933meddling
mediacies1447183mediacies
mediae94217413med__iae
median94117543medi_an_
medians103214213medi_ans
mediant103516703medi_ant
mediate103415213medi_ate
mediating13311203mediating
mediative1548123mediative
mediatize2146903mediatize
medic104619653medic___
medicable1647503medicable
medicaid1445783medicaid
medicaids1544003medicaids
medical12312513medic_al
medicals1349363medicals
medicants1466783medicants
medicares1446873medicares
medicated15410073medicated
medicates14312113medicates
medicating1648953medicating
medicinable1852453medicinable
medicinals1543143medicinals
medicining1643883medicining
medick154010133medic__k
medicks16368413medic_ks
medico113711163medic__o
medicos12339833medic_os
medics114115353medic__s
medii84513493medi_i__
medina94114093med__ina
mediocre1343473mediocre
meditate11310623meditate
medivacing1943053medivacing
meinie82614523me_ini_e
melamine12310303melamine
melilite10410573melilite
melinite10411753melinite
menacing1339783menacing
mendicant1466543mendicant
mendicity1745073mendicity
meriting11314693meriting
merocrine1346233merocrine
metricize2247213metricize
midline102315103mid_line
miticide1347863miticide
pedicle1238973pedic_le
pedicure1345183pedicure
redecide12127183redecide
redefine1238973redefine
redivide1355933redivide
redline84218833red_line
reducing12310203reducing
regicide1245923regicide
salicine10311703salicine
seducing1236503seducing
seducive1444213seducive
sericin9312843sericin_
sericins10312463sericins
soricine10710883soricine

Search took 10 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.403443402.0
2DLD Change Limit146162899.33015665.8
3Display Results89890.0302966.7
 (SQL Overall)178691899.76318302.9
 
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.