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

106 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
decagons123589(None) 
decagon1135861decagon_
deacons10310392de_acons
decagonal1343722decagonal
decalogs1245632decalogs
decapods1444622decapods
demagogs1343882demagogs
dodecagons1551602dodecagons
dragons938382d_ragons
hexagons1943942hexagons
agons66423783___agons
beacons11410733be_acons
beckons15279143bec_kons
canons85522063__canons
capons104119503__capons
celadons1137003celadons
cogons96818113__cogons
dacrons103211033dac_rons
dagoes85714603d__agoes
dagos76419443d__ago_s
dalapons1145443dalapons
deacon9510423de_acon_
deadens93410693de_adens
deafens11317253de_afens
deans66131393de_a__ns
debags104211063debag__s
decadent1249003decadent
decadents1346393decadents
decades113615513deca_des
decafs124010883deca__fs
decagram1444653decagram
decagrams1543743decagrams
decalog1136003decalo_g
decals93717713deca__ls
decamps1435643deca_mps
decane93818873deca__ne
decanes103118913deca_nes
decant93524223deca__nt
decants103514443deca_nts
decapod1335433decapo_d
decapodans1651903decapodans
decares102818533deca_res
decathlons1642603decathlons
decayers14307963decayers
decaying15239453decaying
decays124612913deca__ys
decerns10119053dec_erns
decisions1248383decisions
decolors1187713decolors
decorous1138853decorous
decors94017773dec__ors
decos85522123dec__o_s
decoys123911283dec__oys
decrowns14265063decrowns
decurions1246023decurions
dedans85915073deda__ns
deigns8389983de_ig_ns
delations102616593delations
delators92314823delators
demagog1243853demago_g
demagogy1642953demagogy
demetons1137623demetons
demigods1343983demigods
demons94917723de__mons
dendrons1047393dendrons
deraigns1034883deraigns
designs9328313desig_ns
detains83716093deta_ins
devons104512253de__vons
dewans105215143dewa__ns
dictions111812673dictions
dodecagon1451793dodecagon_
dragon838843d_ragon_
dragoons1045013d_ragoons
epigons1048183_epigons
etalons739073_etalons
flagons1137973_flagons
flexagons2041673flexagons
glucagons1341903glucagons
hemagogs1544283hemagogs
heptagons1543453heptagons
hexagon1843823hexagon_
lections102413843lections
megatons11279703megatons
menazons1945733menazons
negatons9299273negatons
nonagons947223nonagons
octagons1144493octagons
paragons11311503paragons
pecans101515833peca__ns
pedagogs13123793pedagogs
pentagons1246153pentagons
perigons11310083perigons
reagins84215643re_agins
reasons72514943re_asons
reckons13269653rec_kons
recons84922993rec__ons
sacatons1038973sacatons
seasons72614233se_asons
sections102714703sections
tetragons1045353tetragons
wagons103911213__wagons
weakons14287803we_akons
weapons12278603we_apons
weasons102310583we_asons
zacatons1945703zacatons

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.406440125.6
2DLD Change Limit1461621066.56322270.6
3Display Results1061060.0303533.3
 (SQL Overall)1786911066.99925530.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.