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

159 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
dedicates1331169(None) 
dedicate12312801dedicate_
dedicated14310251dedicated
dedicatee13410341dedicatee
dedicatees1445311dedicatees
delicates12314311delicates
medicates14312111medicates
abdicates1448152abdicates
decimates14410692decimates
dedicator1348252dedicator
dedicators1447742dedicators
defecates1538592defecates
delicate11315492delicate_
depilates12310922depilates
derivates13310092derivates
desiccates1545382desiccates
deviates12312732devi_ates
educates1139622_educates
indicates12312582indicates
mediates112814062medi_ates
medicares1446872medicares
medicate13513242medicate_
medicated15410072medicated
meditates1239812meditates
predicates15410822predicates
radicates12412072radicates
rededicates15115072rededicates
redictates1348232redictates
vesicates14119032vesicates
abdicate1348903abdicate_
abdicated1547013abdicated
adjudicates2252163adjudicates
bedmates1349183bed_mates
bedplates1445493bedplates
celibates1358633celibates
deaerates10313643deaerates
dealates92716683de_alates
deaminates1349383deaminates
debates103718533de__bates
decades113615513de__cades
decanes103118913de__canes
decares102818533de__cares
deciares11510633deci_ares
decimate13411123decimate_
decimated1548953decimated
decorates12314743decorates
dedicatedly1952503dedicatedly
dedicating1539143dedicating
dedication14311963dedication
dedications15310873dedications
dedicatory1745673dedicatory
deduces1168793deduc__es
deducted1356243deduc_ted
deducts1166593deduc_t_s
defalcates1644543defalcates
defecate1438793defecate_
defecated1637493defecated
deficits1447273deficit_s
defilades14134073defilades
deflates123013943de_flates
deices94119373de_ic__es
deicides1249303de_icides
delates83526283de__lates
delectates1348193delectates
delegates1139843delegates
delicacies1545133delicacies
delicately1644533delicately
delicts104012253delic_t_s
delineates1147123delineates
demarcates1545973demarcates
denigrates1298113denigrates
denitrates1169513denitrates
denudates1145583denudates
depicted1437743depic_ted
depicter1356853depic_ter
depicters1435823depic_ters
depicts12358463depic_t_s
depilate11311703depilate_
depilated1339653depilated
deprecates1547283deprecates
depurates1239823depurates
derates84028893de__rates
derivate12311203derivate_
derogates11310973derogates
desecrates1348843desecrates
desiccate1445923desiccate_
desiccated1644993desiccated
designates1246363designates
desolates10311793desolates
detonates10310433detonates
detoxicates2154063detoxicates
deviate11312713devi_ate_
deviated13311043devi_ated
devices133212583devic__es
dictates11311383__dictates
dilates83220663__dilates
dominates12311743dominates
duplicates1546633duplicates
edicts94911703_edic_t_s
educate10310213_educate_
educated1237943_educated
emirates101214853_emirates
epilates10313503_epilates
eradicates1348263eradicates
federates13310153federates
geminates12310033geminates
hesitates1269793hesitates
indicate11313353indicate_
indicated13310953indicated
iodinates1048203iodinates
levigates1346493levigates
levirates1247493levirates
levitates1247863levitates
loricates11310123loricates
mediacies1447183mediacies
mediate103415213medi_ate_
mediated123011873medi_ated
medicaids1544003medicaids
medicals1349363medica_ls
medicants1466783medicants
medicare1347483medicare_
medicides1556583medicides
medicines1447903medicines
meditate11310623meditate_
meditated1348083meditated
metricates1449113metricates
ordinates1049003ordinates
pedicabs1544593pedica_bs
pedicles1338683pedic_les
pediculates1645673pediculates
pedicures1445263pedicures
predicate14411773predicate_
predicated1649143predicated
radiates92415293radi_ates
radicate11412873radicate_
radicated13410123radicated
redates83423873red__ates
rededicate14125573rededicate_
rededicated16144813rededicated
redictate1249063redictate_
redictated1447483redictated
reeducates1375193reeducates
relocates11712933relocates
replicates1449453replicates
resinates9314763resinates
sedates83418033sed__ates
seriates82620673seri_ates
silicates11311523silicates
sonicates11410383sonicates
suricates11311743suricates
syndicates1644473syndicates
tunicates11268743tunicates
undedicated1654813undedicated
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.423422437.4
2DLD Change Limit1486411597.18620684.8
3Display Results1591590.0801987.5
 (SQL Overall)1786911597.68923239.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.