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

86 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
dedicator134825(None) 
dedicators1447741dedicators
dedicatory1745671dedicatory
abdicator1446262abdicator
decimator1447732decimator
dedicate12312802dedicat_e
dedicated14310252dedicated
dedicatee13410342dedicatee
dedicates13311692dedicates
dedication14311962dedication
defecator1546382defecator
depictor1355512depic_tor
depilator1247652depilator
desiccator1543992desiccator
deviator1248312devi_ator
educator1147152_educator
indicator1249012indicator
mediator1139042medi_ator
meditator1246592meditator
abdicators1546263abdicators
adjudicator2252093adjudicator
deaerator10128113deaerator
decimators1547503decimators
decorator1248573decorator
dedicatees1445313dedicatees
dedicating1539143dedicating
dedications15310873dedications
defalcator1643173defalcator
defecators1656253defecators
defector14277953defec_tor
deflator12328343de_flator
delator83015033de__lator
delegator1146243delegator
delicate11315493delicat_e
delicates12314313delicates
delineator1174173delineator
denigrator1245223denigrator
depicter1356853depic_ter
depictors1465943depic_tors
depilators1347333depilators
depilatory1645743depilatory
depurator1247023depurator
desecrator1346003desecrator
desiccators1643803desiccators
designator1244713designator
desolator1046673desolator
detector11278323detec_tor
detonator1045983detonator
detractor12147213detractor
deviators1358533devi_ators
deviatory1666443devi_atory
dictator1147263__dictator
dilator82712793__dilator
dominator1258233dominator
duplicator1544803duplicator
editor738663_edi__tor
educators1246993_educators
educatory1545443_educatory
eductor1035863_educ_tor
elicitor1045773_elicitor
epilator1049243_epilator
eradicator1345573eradicator
evictor12346363_evic_tor
evocator1346573_evocator
federator1346263federator
hesitator1286023hesitator
indicators1348613indicators
indicatory1646383indicatory
indictor1147463indic_tor
judicatory2343693judicatory
levitator1245493levitator
mediators1248923medi_ators
mediatory1546433medi_atory
medicate13513243medicat_e
medicated15410073medicated
medicates14312113medicates
medication15411173medication
meditators1346263meditators
predicatory1945563predicatory
predictor1447093predic_tor
radiator949203radi_ator
redactor1147033redac_tor
reductor1156433reduc_tor
sonicator1197263sonicator
syndicator1653523syndicator
vindicator1644513vindicator

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.423422437.4
2DLD Change Limit148641868.11018328.1
3Display Results86860.0302866.7
 (SQL Overall)178691868.56320867.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.