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

157 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
lenition831008(None) 
lenitions939471lenitions
dentition1049632dentition
edition8310852_edition
enation73419232_enation
ignition946532ignition
lection92614862le_ction
legation92412932legation
lenities8315942lenities
leniting9312352leniting
lenitive1148492lenitive
lunation8311922lunation
mention9314372men_tion
monition10311722monition
munition1038762munition
petition10711752petition
punition1038372punition
rendition1058932rendition
sedition939332sedition
venation11513502venation
vendition1345692vendition
addition1096893addition
adnation9310783adnation
aeration8319933aeration
agnation9311723agnation
alienation1048793alienation
ambition1246563ambition
audition979173audition
benison937123beni_son
benthon1237693ben_thon
cognition1247013cognition
coition9314313_coition
conation101420883conation
condition12411163condition
crenation11412923crenation
decision1148523decision
definition1445963definition
delation92318083delation
deletion92011973deletion
demotion1169073demotion
dentation10315243dentation
dentin73919573den_ti_n
dentitions1148853dentitions
depiction1437273depiction
derision939073derision
detrition1049133detrition
deviation13312403deviation
devotion1256763devotion
donation91513783donation
editions9310403_editions
elation73620453_elation
election102015353election
elevation1239233elevation
elision72311103_elision
elution72913823_elution
emotion9711303_emotion
enations83316903_enations
envision1145953_envision
eviction13228683_eviction
fenthion1444613fenthion
fetation11613143fetation
flection13239563fle_ction
fruition11106103fruition
function1337843function
gelation93014433gelation
genitive1247643genitive
genitor837273genit_or
gentian8310103gen_tian
herniation1348443herniation
ignitions1045803ignitions
ignitron943203ignitron
inanition947293inanition
junction1736203junction
kenotron1244463kenotron
lavation1139973lavation
laxation1538423laxation
lecithin1344313lecithin
lectin82515013le_cti_n
lections102413843le_ctions
legations102711923legations
legion75712983le__gion
lengthen1243533lengthen
lenite6719983lenit__e
lenited8812433lenit_ed
lenites7818443lenit_es
lenitives1247503lenitives
lenity9612713lenit__y
lenten6312883len_t_en
lentic83515743len_ti_c
lentigo846063len_tigo
lentil64315393len_ti_l
lentils73912973len_tils
lentisk1136063len_tisk
lento57223393len_t_o_
lentoid8310683len_toid
lentos65317403len_t_os
leptin82512333le_pti_n
lepton82510803le_pt_on
lesion64715063le__sion
levigation1447023levigation
levitation1349443levitation
levities11310713levities
lewisson1142023lewisson
lexicon1643903lexi_con
libation102411363libation
ligation92313093ligation
lineation9310763lineation
lobation102110553lobation
location102113913location
locution10227663locution
lotion65716523l__otion
lunations9310723lunations
luxation1538233luxation
mediation12312293mediation
mentation11313983mentation
mentions10312893men_tions
monitions11310883monitions
munitions1138173munitions
nation64322803__nation
negation92913023negation
niton55418283__nit_on
notion64516583__notion
pension9412203pen_sion
perdition1249013perdition
petitions11511083petitions
planation11310123planation
position10912193position
prenotion1149173prenotion
punitions1137923punitions
reaction10612603reaction
recision10310273recision
reedition1047833reedition
reignition1144893reignition
relation82619773relation
reliction11310693reliction
religion996743religion
remotion10410233remotion
renditions1149183renditions
revision1138723revision
sanction1049533sanction
section92515663se_ction
sedation9312453sedation
seditions1039013seditions
seniti64317223seniti__
sensation9510583sensation
seriation9318063seriation
tension7311803ten_sion
tuition738823_tuition
unction9310663_unction
venations12311723venations
venditions1445523venditions
venetian1146073venetian
venison1036453veni_son
vernation12311083vernation
vexation1838783vexation
volition1179173volition
zonation171410723zonation

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.420425454.8
2DLD Change Limit1461621577.40619735.6
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.88922650.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.