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

158 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
medicates1431211(None) 
dedicates13311691dedicates
mediates112814061medi_ates
medicares1446871medicares
medicate13513241medicate_
medicated15410071medicated
meditates1239811meditates
abdicates1448152abdicates
dedicate12312802dedicate_
dedicated14310252dedicated
dedicatee13410342dedicatee
dedicatees1445312dedicatees
delicates12314312delicates
educates1139622_educates
indicates12312582indicates
mediacies1447182mediacies
mediate103415212medi_ate_
mediated123011872medi_ated
medicaids1544002medicaids
medicals1349362medica_ls
medicants1466782medicants
medicare1347482medicare_
medicides1556582medicides
medicines1447902medicines
meditate11310622meditate_
meditated1348082meditated
metricates1449112metricates
predicates15410822predicates
radicates12412072radicates
redictates1348232redictates
vesicates14119032vesicates
abdicate1348903abdicate_
abdicated1547013abdicated
bedmates1349183bed_mates
bedplates1445493bedplates
celibates1358633celibates
decimates14410693decimates
dedicator1348253dedicator
dedicators1447743dedicators
defecates1538593defecates
delicate11315493delicate_
depilates12310923depilates
derivates13310093derivates
desiccates1545383desiccates
deviates12312733devi_ates
dictates11311383__dictates
dilates83220663__dilates
edicts94911703_edic_t_s
educate10310213_educate_
educated1237943_educated
emaciates1347883emaciates
emirates101214853_emirates
epilates10313503_epilates
eradicates1348263eradicates
federates13310153federates
geminates12310033geminates
hesitates1269793hesitates
imbricates1645293imbricates
implicates1646783implicates
indicate11313353indicate_
indicated13310953indicated
iodinates1048203iodinates
levigates1346493levigates
levirates1247493levirates
levitates1247863levitates
loricates11310123loricates
manducates1545593manducates
marinates112516383marinates
masticates1449843masticates
mediae94217413medi_a_e_
medials103914733medi_a_ls
medians103214213medi_a_ns
mediants11299493medi_ants
medias93620783medi_a__s
mediately1544613medi_ately
mediatizes2245603medi_atizes
mediator1139043medi_ator
mediators1248923medi_ators
medicable1647503medicable
medicaid1445783medica_id
medical12312513medica__l
medically17310113medically
medicament1744883medicament
medicaments1853713medicaments
medicant13910823medica_nt
medicating1648953medicating
medication15411173medication
medications1649933medications
medicide1447713medicide_
medicine1349543medicine_
medicined1545113medicined
medicks16368413medic__ks
medicos12339833medic__os
medics114115353medic___s
medigaps1463883mediga_ps
medinas103411463medina__s
meditator1246593meditator
meditators1346263meditators
medivaced1843133medivaced
medivacs1644003mediva_cs
melilites1149193melilites
melinites11310403melinites
meliorates1288903meliorates
mendicants1553943mendicants
mendicities1646383mendicities
meniscate1346213meniscate_
messmates1346233messmates
metates92720013me__tates
meticais1248183metica_is
meticals12310763metica_ls
metricate1349913metricate_
metricated1547293metricated
militates11310883militates
miseducates1652453miseducates
mitigates1248253mitigates
moderates12710753moderates
modistes1138643modi_stes
modulates1238053modulates
motivates1447073motivates
mudcats1236223mud_cat_s
muriates10312083muri_ates
muricate12311113muricate_
muricated1448243muricated
musicales1346703musicales
mutilates11310953mutilates
ordinates1049003ordinates
pedicabs1544593pedica_bs
pedicles1338683pedic_les
pediculates1645683pediculates
pedicures1445263pedicures
predicate14411783predicate_
predicated1649143predicated
radiates92415293radi_ates
radicate11412873radicate_
radicated13410123radicated
redates83423873red__ates
rededicates15115073rededicates
redictate1249063redictate_
redictated1447483redictated
reeducates1375193reeducates
relocates11712933relocates
remediates1346933remedi_ates
replicates1449453replicates
resinates9314763resinates
sedates83418043sed__ates
seriates82620673seri_ates
silicates11311523silicates
sonicates11410383sonicates
suricates11311743suricates
syndicates1644473syndicates
tunicates11268743tunicates
unmedicated1744103unmedicated
urticates1148893urticates
vellicates1545903vellicates
veritates12310973veritates
vesicate131210053vesicate_
vesicated15117653vesicated
vindicates1646093vindicates

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411587.40620070.3
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.90522604.8
 
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.