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

207 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
element931780(None) 
clement11313771clement
elements10312171elements
aliment9316702aliment
cement103321662_cement
cerement12315132cerement
dement93825142_dement
easement10414162easement
elegant8311502elegant
elemental1145882elemental
eleven988302eleven_
elevens1066802elevens
eleventh1443772eleventh
elopement13118222elopement
eluent6315482el_uent
lament85024942_lament
loment84021472_loment
recement12315652recement
telemen9310172telemen_
tenement10412592tenement
vehement1647762vehement
weldment1445822weldment
abetment1248233abetment
ailment9314233ailment
aliments10311093aliments
alinement1149103alinement
ament76036543__ament
augment10910203augment
averment13311603averment
axemen1547493axemen_
basement12311493basement
bedemen12910183bedemen_
bellmen1138143bellmen_
besetment1346953besetment
blent76230953bl__ent
bodement13410123bodement
casement12311953casement
cementa112810533_cementa
cements112714223_cements
cerements13411453cerements
clamant11312433clamant
clemency1743693clemency
clemently1645063clemently
client8316343cl_ient
comment1310317703comment
credent10313973credent
decedent12310213decedent
decent94023703_decent
decrement14411053decrement
deferent122712873deferent
deferment151210303deferment
defilement1648063defilement
dements103016623_dements
detent73624483_detent
determent121312903determent
easements11410333easements
eeliest73516473eeliest
efferent1447203efferent
ejectment2044823ejectment
eldest72912683el_dest
elect74327033el__ect
elegist81311973elegist
elegit71212893ele_git
elementals1254793elementals
elementary1553643elementary
elemi7312503elem__i
elemis8312383elem_is
elephant1347553elephant
elevenths1542473elevenths
elevon977953elevon_
elevons1067573elevons
elint55436473el__int
elmiest9310743elmiest
eloinment1147253eloinment
elopements14146363elopements
eloquent1745003eloquent
eluant6315093el_uant
eluents738703el_uents
embedment1645613embedment
emblements1647793emblements
emend86214893__emend
emergent1149113emergent
eminent9313843eminent
emmet94221383e_mme_t
emolument1346733emolument
enlacement1458133enlacement
erodent8313823erodent
erumpent1245453erumpent
evenest10312103evenest
event85924443__event
evident1139993evident
evolvement1853913evolvement
examen1538283examen_
examens1637193examens
excrement2048063excrement
exempt1737453exem_pt
exeunt1338703exe_unt
exigent1539513exigent
extent132714913e_xtent
eyelet9514533eyele_t
ferment12315573ferment
figment1379743figment
filament13410033filament
fitment12710303fitment
flamen115215993flamen_
flamens124611063flamens
fleet85932333fle_e_t
flehmen1534913flehmen_
flehmens1643233flehmens
fleshment1745503fleshment
fluent9313933fl_uent
flymen14387773flymen_
foemen11310523foemen_
foment113718303_foment
garment10315233garment
gerent73223093_gerent
gleemen1035723gleemen_
gleet65532343gle_e_t
hellbent1345743hellbent
helmet113718933hel_me_t
helpmeet1544253helpmeet
hutment1239173hutment
icemen1037893icemen_
implement1549533implement
inclement1349913inclement
lambent113711303_lambent
laments94314853_laments
lamest84722763_lamest
latent64124303_latent
leant56737783_le_ant
learnt64019253_learnt
leben7314853_leben_
lebens8310093_lebens
leet45957903_le_e_t
legend837693_legend
legmen939343legmen_
leman75622603_leman_
lemans85316393_lemans
lemon75618183_lemon_
lemons84415053_lemons
lemony11419553_lemony
lenient7313843lenient
lent46360533_l__ent
levant9314493_levant
limen75426033_limen_
limens84618033_limens
lomenta92710133_lomenta
loments93413473_loments
lucent8313823_lucent
lumen75220903_lumen_
lumens85013973_lumens
memento11378133_memento
moment103319683_moment
movement1549433movement
oddment1145923oddment
pavement1549443pavement
payment14310703payment
pediment13411393pediment
pelmet103419243pel_me_t
pigment12510733pigment
placement1548183placement
precent113520263precent
premeet11615153premeet
premen105017803premen_
present94022733present
prevent124016553prevent
raiment9315413raiment
recements13312283recements
recent83630853_recent
recrement13411363recrement
referent112813423referent
regent74127673_regent
regiment114414053regiment
relearnt849213relearnt
relent64431853_relent
relevant1149243relevant
relucent1049283relucent
remeet86325473_remeet
remelt85123123_remelt
remend95216553_remend
remet74843723_reme_t
remint85329973_remint
repent84728873_repent
rerent63832453_rerent
resent63833623_resent
revehent14239083revehent
revelment1448773revelment
reverent112615093reverent
revetment1448323revetment
revilement1548483revilement
sarment9318763sarment
sediment11411103sediment
segment10312563segment
semen75724103_semen_
semens84616963_semens
settlement1246463settlement
siemens938413siemens
sleet55639133sle_e_t
tegument1177523tegument
teleman959573teleman_
teletext1545253teletext
tenements1149963tenements
torment9316173torment
varment12313243varment
velamen1237123velamen_
vestment13109203vestment
weldments1544423weldments

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272076.03022226.7
3Display Results2072070.0802587.5
 (SQL Overall)1786912076.26628517.6
 
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.