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 “enneagons” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
enneagons104213(None) 
enneagon942171enneagon_
endeavors1343413endeavors
enneads834733ennea__ds
enterons8314153ente_rons
estragons1044653estragons
nonagons947223_nonagons
pendragons1452243pendragons
pentagons1246153pentagons
unreasons9114343unreasons
agons66423784____agons
annealers944564annealers
annealing1047454annealing
anneals7449954annea__ls
annexations1844264annexations
bandwagons1751624bandwagons
beacons11410734__beacons
cannelons1145214canne_lons
cinnamons1343034cinnamons
connexions1974624connexions
contagions1346604contagions
deacons10310394__deacons
decagons1235894_decagons
dodecagons1551604dodecagons
dragons938384__dragons
echelons1385544eche_lons
elevons1067574e_le_vons
emblazons2242774emblazons
enamors939124e_n_amors
enations83316904e_nations
encages103313784e_ncag_es
encaging1258734e_ncaging
enchains1348524encha_ins
endearing1139324endearing
endears83710054endea__rs
endeavor1243244endeavo_r
endeavour1351974endeavour
endeavours1451774endeavours
endergonic1453064endergonic
endogens1047954e_ndogens
energids1045584e_nergids
energies9310784e_nergies
engagers10246554e_ngagers
engages92912494e_ngag_es
engaging1147374e_ngaging
engrains937584engra_ins
enhaloes1197344e_nhaloes
enhalos1087534e_nhalo_s
ennead736254ennea___d
enneadic1142774ennea_dic
enrages83114854e_nrag_es
enraging1049574e_nraging
ensigns836354e_nsig_ns
enteron7313344ente_ron_
entrains8312964entra_ins
envelops1343494enve_lops
envenoms1343854enve_noms
environs1144674e_nvirons
envisions1245614envisions
epigons1048184e__pigons
estragon944794estragon_
etalons739074e__talons
ethephons1743374ethephons
eudaemons1262844eudaemons
eudemons1164864eude_mons
fanfarons1573624fanfarons
flagons1137974__flagons
flexagons2041674flexagons
glucagons1341904glucagons
gonfalons1342534gonfalons
gonfanons1342364gonfanons
heptagons1543454heptagons
hexagons1943944_hexagons
inhesions12116124inhesions
innages82911304inn_ag_es
lineages979184lineag_es
lineations1039544lineations
martagons1245124martagons
menazons1945734men_azons
monaxons1744814mon_axons
neatens73310404__neatens
negatons9299274_negatons
nektons1136394__nektons
nelsons738004__nelsons
neocons936914__neocons
neons55818684__ne__ons
neuraxons1642544neuraxons
neurons7410454__neurons
newtons1036814__newtons
nonagon847314_nonagon_
nonegos837144none_go_s
nonpagans1243834nonpagans
octagons1144494_octagons
paragons11311504_paragons
pendragon1352284pendragon_
pennons939714penn___ons
pentagon1146324pentagon_
reagins84215644__reagins
reasons72514944__reasons
reseasons944874reseasons
seasons72614234__seasons
synagogs1343274syn_agogs
synanons1144634syn_anons
tarragons1044484tarragons
tetragons1045354tetragons
treasons848684_treasons
undergods1246334undergods
undergoes1139054undergoes
undergone1158274undergone
unlearns844454unlea_rns
unpersons1146854unpersons
unreason8104484unreason_
unzealous1842734unzealous
wagons103911214___wagons
weakons14287804__weakons
weapons12278604__weapons
weasons102310584__weasons

Search took 14 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 Filter1786911653290.453394461.4
2DLD Change Limit16532911712.73312984.3
3Display Results1171170.0631857.1
 (SQL Overall)17869111713.24913487.1
 
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.