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

112 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
demetons113762(None) 
demeton1037681demeton_
deletions102610932deletions
demeans1039722deme_ans
demons94917722dem__ons
demotions1258442demotions
emetins9812652_emetins
ademptions1543383ademptions
bemeans1148743beme_ans
betons84919553__betons
daemons10269233d_aemons
daltons8310403d_altons
damsons1038013dam_sons
deacons10310393de_acons
debtors1038533de_btors
decagons1235893decagons
deceptions1547863deceptions
decerns10119053dece_rns
deepens10307813de_epens
deets65330243de_et__s
deewans11306903de_ewans
defections161510203defections
defectors15237883defectors
dejections20168353dejections
delations102616593delations
delators92314833delators
deletes83117933delet_es
deleting103314423deleting
deletion92011973deletion_
demagogs1343883demagogs
demean9510563deme_an_
demeanor1143833demeanor
demeanors1243743demeanors
dement93825153deme__nt
dementias1257413dementias
dementing13311043dementing
dements103016623deme_nts
demerges12129503demerges
demerits11310763demerits
demes86032693deme___s
demesne1035573deme_sne
demesnes1137083demesnes
demigods1343983demigods
demijohns2241573demijohns
demits94918073demit__s
demobs11429483dem__obs
demon86520313dem__on_
demos86022993dem__o_s
demotes104717673demot_es
demotics1338753demotics
demoting12311423demoting
demotion1169073demotion_
dendrons1047393dendrons
dentins83419223de_ntins
depletions1355743depletions
desertions1139883desertions
desktops1542463desktops
detections131410043detections
detectors12278303detectors
detentions11148803detentions
deuterons1046783deuterons
deveins1138813deve_ins
develops14145323develops
devons104512253d__evons
devotions1356593devotions
dimerous1139323dimerous
dimeters11411093dimeters
duvetyns1541323duvetyns
edematous1244423edematous
elevons1067573_elevons
emerods10137653_emerods
emetics11610723_emetics
emetin8613463_emetin_
emetine9712943_emetine
emetines10611053_emetines
emotions10610283_emotions
emptins1179403_emptins
gemstone1145843gemstone
gemstones1245563gemstones
hegemons1444893hegemons
hematins131714683hematins
hometowns1743643hometowns
jetons134512613__jetons
jettons1437273je_ttons
lemons84415053lem__ons
leptons91910433le_ptons
megatons11279703megatons
melons84117713__melons
meltons9410923me_ltons
mementoes13325383mementoes
mementos12267373memento_s
memetics1447803memetics
mesons83215843__mesons
metols84115773__metols
mutons84314363__mutons
negatons9299273negatons
nektons1136393ne_ktons
neustons836833neustons
newtons1036813ne_wtons
pelotons1038913pelotons
pereions10310853pereions
pereons92815003pere_ons
phaetons1345853phaetons
remotions1149703remotions
semens84616973seme__ns
semitone1048973semitone
semitones1148943semitones
setons64620173__setons
sextons143710413se_xtons
skeletons1343933skeletons
telethons1246023telethons
testons7313563te_stons

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621127.06320694.0
3Display Results1121120.0432604.7
 (SQL Overall)1786911127.52923733.7
 
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.