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

153 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
elements1031217(None) 
element9317801element_
aliments10311092aliments
cements112714222_cements
cerements13411452cerements
clement11313772clement_
dements103016622_dements
easements11410332easements
elemental1145882elemental
elementals1254792elementals
elevens1066802eleven_s
eleventh1443772eleventh
elevenths1542472elevenths
elopements14146362elopements
eluents738702el_uents
emblements1647792emblements
laments94314852_laments
loments93413472_loments
recements13312282recements
tenements1149962tenements
weldments1544422weldments
abetments1346073abetments
ailments1039433ailments
aliment9316703aliment_
alinements1247133alinements
aments85219803__aments
augments1137833augments
averments1449093averments
basements1348263basements
besetments1445293besetments
bodements1447613bodements
casements1348583casements
cement103321663_cement_
cementa112810533_cementa
cerement12315133cerement_
clemency1743693clemency
clemently1645063clemently
clients938093cl_ients
comments142913883comments
decedents1347323decedents
decrements1549383decrements
deferents13269393deferents
deferments16128583deferments
defilements1747073defilements
dement93825143_dement_
detents83615153_detents
determents131010313determents
easement10414163easement_
efferents1545333efferents
ejectments2144053ejectments
elects83315003el__ects
elegant8311503elegant_
elegists9128113elegists
elegits8149343ele_gits
elementary1553643elementary
elemis8312383elem__is
elephants1444803elephants
eleven988303eleven__
elevenses1244333elevenses
elevons1067573elevon_s
elints65816423el__ints
eloinments1245993eloinments
elopement13118223elopement_
eluants737583el_uants
eluent6315483el_uent_
embedments1744503embedments
emends95711433__emends
emergents1245973emergents
emmets10349153e_mme_ts
emoluments1455423emoluments
enlacements1546993enlacements
events94814073__events
evolvements1953743evolvements
examens1637193examen_s
excrements2146983excrements
exempts1844023exem_pts
extents142610173e_xtents
eyelets1057523eyele_ts
ferments13311473ferments
figments1446943figments
filaments1446653filaments
fitments1376793fitments
flamens124611063flamen_s
fleets96915063fle_e_ts
flehmens1643233flehmen_s
fleshments1843853fleshments
foments122912053_foments
garments1139963garments
gerents82612923_gerents
gleets75315053gle_e_ts
helmets12309073hel_me_ts
helpmeets1641923helpmeets
hutments1345603hutments
implements1647853implements
lament85024943_lament_
latents75214313_latents
lebens8310093_leben_s
leets54927123_le_e_ts
legends936073_legends
lemans85316393_leman_s
lemons84415053_lemon_s
levants1037723_levants
limens84618033_limen_s
loment84021473_loment_
lomenta92710133_lomenta
lumens85013973_lumen_s
memento11378133_memento
mementos12267373_mementos
moments113113123_moments
movements1647513movements
oddments1244103oddments
pavements1647003pavements
payments1536943payments
pediments1448343pediments
pelmets11309693pel_me_ts
pigments1337343pigments
placements1645973placements
precents123015043precents
presents103315643presents
prevents133012293prevents
raiments1039903raiments
recement12315653recement_
recrements1449353recrements
referents12259643referents
regents83416543_regents
regiments123910323regiments
relents74018503_relents
remeets93712413_remeets
remelts93511493_remelts
remends105013033_remends
remints95117293_remints
repents93717623_repents
rerents73319423_rerents
resents74221223_resents
revelments1546863revelments
revetments1546433revetments
revilements1647133revilements
sarments10311963sarments
sediments1248213sediments
segments1138903segments
semens84616963_semen_s
settlements1345543settlements
siemens938413siemen_s
sleets64318873sle_e_ts
teguments1265453teguments
telemen9310173telemen__
teletexts1642833teletexts
tenement10412593tenement_
torments10310453torments
varments1339063varments
vehement1647763vehement_
vestments1486813vestments
weldment1445823weldment_

Search took 7 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 Limit1461621536.43622710.1
3Display Results1531530.0632428.6
 (SQL Overall)1786911536.90525878.5
 
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.