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

188 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
lamented113819(None) 
lamenter1038861lamenter
agented939432_agented
alimented1245312alimented
amended11328312_amended
cemented1338372cemented
demented12311272demented
fomented1437802fomented
garmented1345892garmented
ladened979052laden_ed
lament85024942lament__
lamentedly1652262lamentedly
lamenters1137692lamenters
laments94314852lament_s
laminated122610282laminated
latened8711922laten_ed
parented11912212parented
patented1188892patented
talented938422talented
unlamented1344352unlamented
abetted1058333_abetted
absented1156623absented
accented13107803accented
alerted82512233_alerted
alienated1047743alienated
aliened81011743alien_ed
amend85717753_amen__d
amender10349613_amender
ament76036543_ament__
amentia9310153_amentia
aments85219803_ament_s
amerced1256523_amerced
amounted1135533_amounted
anted66328243_a__nted
assented957523assented
augmented1343833augmented
avenged1245503_avenged
averted112211623_averted
cadenced1435523cadenced
cameoed1238383came_oed
canted94825783ca__nted
caseated11310723caseated
catenated1238923catenated
caveated1439143caveated
cayenned1443163cayenned
cementer1239193cementer
commented16129613commented
damned104212913dam_n_ed
dampened1435623dampen_ed
daunted93810193da_unted
davened124610073daven_ed
dented84120513__dented
emended11329603_emended
faceted13509573face_ted
facetted1445753facetted
fainted114211723fa_inted
fermented1546623fermented
flaunted1234603fla_unted
fomenter1339263fomenter
fragmented1743033fragmented
galeated104111583galeated
gamester1137323gamester
gamete9313593game_te_
gametes10312253game_tes
gazetted19234853gazetted
hanted104124313ha__nted
haunted11399733ha_unted
havened14429243haven_ed
hented104218753__hented
incented112412553incented
indented101811733indented
invented122510663invented
jaunted15418563ja_unted
labeled102510563labe_led
labelled11278293labelled
labiated11109303labiated
lacerated122210693lacerated
lacertid1146393lacertid
lactated1138873lactated
lagend838743lagen__d
lagered92311153lage_red
lakebed1434783lake_bed
lambasted14103253lambasted
lambed115614783lam__bed
lambent113711303lambent__
lambently1643393lambently
lamed85235293lam___ed
lameness102612673lameness
lamenting1237703lamenting
lamest84722763lamest__
laminae93512973laminae_
laminate103014633laminate_
laminates112712903laminates
lamister1037653lamister
lammed113915623lam__med
lamped114017543lam__ped
lamster9109913lam_ster
lanated8313203la_nated
lanced93717723la__nced
lanceted1137083lanceted
landed84619243la__nded
lapeled10258893lape_led
lapelled11227083lapelled
lappeted13255833lappeted
lariated91212063lariated
lasted74323603la__sted
lated65240673la___ted
latent64124303latent__
latently1146353latently
latents75214313latent_s
laureated1096163laureated
laveered1235253laveered
lavender1235143lavender
layered11259413laye_red
layette1037133layette_
layettes1136263layettes
leadened1036153leaden_ed
leavened1235553leaven_ed
lenited8812433l__enited
lensed74015473l__ensed
lenten6312883l__enten
letted74118543l__etted
levanted1245323levanted
licenced13145783licenced
licensed11145723licensed
licente91210893licente_
likened12267353liken_ed
limited102310233lim_ited
limned94811473lim_n_ed
lineated9711063lineated
linted74021823l__inted
lisente71210703lisente_
livened11238933liven_ed
loment84021473loment__
lomenta92710133loment_a
loments93413473loment_s
lomentum1244753lomentum
lunted74517523l__unted
margented1346813margented
meated94222403__meated
melted94219063__melted
mended104418683__mended
mensed93916543__mensed
mentee84121293__mentee
meted85424433__me_ted
minted94220583__minted
omened93711003_omen_ed
oriented937483oriented
ornamented1342953ornamented
painted104214633pa_inted
panted95024823pa__nted
patentee1099943patentee
pigmented1544063pigmented
planted103516123pla__nted
ramenta9311183rament_a
ramentum1244863ramentum
ranted74324703ra__nted
ravened115012283raven_ed
relented92614943relented
remelted11310153remelted
remended123010393remended
reminted113615083reminted
rented74426593__rented
repented112614983repented
rerented92516163rerented
resented92716963resented
sainted84114243sa_inted
scented102811893_scented
segmented1345063segmented
sklented1335053sklented
slanted83514743sla__nted
smelted10399093_smelted
stamened1137633stamen_ed
tainted83512423ta_inted
taunted84310963ta_unted
tented74221003__tented
tormented1245963tormented
unamended1344853unamended
undented102313953undented
unmelted1169183unmelted
unmended12299093unmended
unrented92413923unrented
untented92613413untented
valeted1139013vale_ted
vaunted11438863va_unted
vented104617923__vented
wakened1546873waken_ed
wanted104319723wa__nted

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.423422437.4
2DLD Change Limit1461621887.01620832.7
3Display Results1881880.0762473.7
 (SQL Overall)1786911887.51523777.9
 
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.