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

140 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
lamenting123770(None) 
agenting1039382_agenting
alimenting1344502alimenting
amending12308912_amending
cementing1438762cementing
dementing13311042dementing
fomenting1537232fomenting
garmenting1445492garmenting
ladening1078822laden_ing
laminating1348732laminating
latening9711492laten_ing
parenting12611582parenting
patenting1248952patenting
abetting1158293_abetting
absenting1236993absenting
accenting1487833accenting
agentings1134443_agentings
alerting91312383_alerting
alienating1147233alienating
aliening91510893alien_ing
amentia9310153_amenti_a
amentias1039413_amentias
amercing1337193_amercing
amounting1236643_amounting
anting75827023_a__nting
assenting1038163assenting
augmenting1443853augmenting
avenging1345863_avenging
averting122512733_averting
cadencing1544963cadencing
cameoing1379063came_oing
canting104725903ca__nting
caseating12311743caseating
catenating1348683catenating
caveating1539293caveating
commenting1749173commenting
damning114211633dam_n_ing
dampening1535463dampen_ing
daunting103310403da_unting
davening13258873daven_ing
denting94422183__denting
emending12298893_emending
faceting1438783face_ting
facetting1535283facetting
fainting123312163fa_inting
fermenting1646823fermenting
flaunting1335043fla_unting
fragmenting1843243fragmenting
gazetting2043243gazetting
hanting114124483ha__nting
haunting123510053ha_unting
havening15258553haven_ing
henting113719653__henting
incenting12912063incenting
indenting11911263indenting
inventing13109973inventing
jaunting16328633ja_unting
labeling11311653labe_ling
labelling1238103labelling
lacerating1349453lacerating
lacewing1435843lace_wing
lactating1239193lactating
lagering102212313lage_ring
lambasting1543343lambasting
lambing123412413lam__bing
lament85024943lament___
lamented1138193lament_ed
lamenter1038863lament_er
lamenters1137693lamenters
laments94314853lament__s
laming94528363lam___ing
laminin939973lamin_in_
laminins1039133lamin_ins
lamming123014583lam__ming
lamping123116003lam__ping
lancing103314123la__ncing
landing92819323la__nding
lariating10311793lariating
lasting84725243la__sting
laureating1146393laureating
laveering1336813laveering
layering122310353laye_ring
leadening1176733leaden_ing
leavening1365973leaven_ing
lending94118533l__ending
leniting9312353l__eniting
lensing84015103l__ensing
letting83218533l__etting
levanting1345523levanting
licencing1443853licencing
licensing1244753licensing
likening13246893liken_ing
limiting1138813lim_iting
limning103710323lim_n_ing
linting83820983l__inting
livening12248153liven_ing
lunting83817743l__unting
margenting1446153margenting
meeting103314963__meeting
melting103317753__melting
mending114018683__mending
mensing103915103__mensing
meting94320593__me_ting
minting103020813__minting
munting103718773__munting
omening10310103_omen_ing
orienting1038723orienting
ornamenting1452563ornamenting
painting113614423pa_inting
panting104025423pa__nting
parentings1355633parentings
pigmenting1653713pigmenting
planting113515383pla__nting
ranting84025413ra__nting
ravening122611293raven_ing
relenting102716773relenting
remeeting12311433remeeting
remelting12311703remelting
remending132311313remending
reminting122315103reminting
renting84026853__renting
repenting122316553repenting
rerenting102617663rerenting
resenting102619293resenting
sainting93215733sa_inting
scenting113212813_scenting
segmenting1445003segmenting
sklenting1475123sklenting
slanting94115093sla__nting
smelting11339713_smelting
tainting93613583ta_inting
taunting93510933ta_unting
tenting84621153__tenting
tormenting1345693tormenting
valentine1245893valentine
valeting1238853vale_ting
vaunting12338753va_unting
venting114218093__venting
wakening1636323waken_ing
wanting114220173wa__nting

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411407.43619989.4
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.92222556.3
 
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.