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 “lavendering” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
lavendering164213(None) 
calendering1543472calendering
laundering1245182la_undering
laveering1336812lave__ering
calendaring1553003calendaring
dandering122511063da__ndering
daundering1364463da_undering
degendering1543633degendering
engendering1453083engendering
gandering122111293ga__ndering
gendering12249753__gendering
laddering1237593la__ddering
lavender1235143lavender___
lavendered1541943lavender_ed
lavenders1334753lavender__s
maundering1455353ma_undering
pandering133211963pa__ndering
rendering112213183__rendering
slandering1237243sla__ndering
tendering112210813__tendering
veneering1337663__veneering
wandering143310983wa__ndering
adventuring1652974adventuring
amending12308914_amend__ing
angering102113804_a__ngering
avenging1345864_aven__ging
aventurin1244034_aventurin_
aventurine1344124_aventurine
aventurins1344214_aventurins
averring12239064_ave__rring
bannering12208804ba__nnering
bantering122414234ba__ntering
blundering1444824_blundering
cankering162110794ca__nkering
cantering122417374ca__ntering
careering12311204care__ering
carpentering1753014carpentering
cavaliering1752554cavaliering
centering122915144__centering
cindering13311224__cindering
clavering1538374clav___ering
coenduring1444234_coenduring
cylindering1842514cylindering
dangering12239304da__ngering
davening13258874daven___ing
decentering1546484decentering
endearing1139324___endearing
enduring10310014___enduring
entering91920054___entering
everduring1543294_everduring
floundering1642484floundering
foundering1545354_foundering
garnering11298084ga_rn_ering
hankering17239384ha__nkering
havening15258554haven___ing
havering152211054hav___ering
hindering14310274__hindering
laagering1136834la__agering
lackering1639374la__ckering
lacquering2243604la_cquering
ladening1078824la___dening
lagering102212314la___gering
lamenting1237694lamen__ting
landing92819324la__nd__ing
lappering14258844la__ppering
latening9711494laten___ing
lathering13912254la__thering
lawyering1655214la__wyering
layering122310354la___yering
leadening1176734l__eadening
leavening1365974leaven___ing
lechering1538444l__echering
leering83417644l__e__ering
legendizing2352554legendizing
lending94118534l__end__ing
lettering102112074l__ettering
leveeing12265964leve__e_ing
levering122212504l__e_vering
lingering11310514l__ingering
livening12248154liven___ing
livering122012384liv___ering
malingering1563194malingering
maneuvering17142374maneuvering
meandering1446984_meandering
misentering1446374misentering
misrendering1683304misrendering
overdaring1539504_overdaring
partnering1345554partn_ering
plundering1444174_plundering
pondering132411334__pondering
ravening122611294raven___ing
reentering1149984_reentering
relaundering1452174rela_undering
renderings12256084__renderings
sanderling1256654sa__nderling
sauntering1137224sa_untering
slavering1338724slav___ering
squandering2242954squandering
sundering11312324__sundering
surrendering1452034surrendering
teddering12256304__teddering
tentering102313204__tentering
thundering1544574_thundering
unendearing1343044_unendearing
veering113213684__ve__ering
vending124015264__vend__ing
veneerings1443584__veneerings
venturing1337554__venturing
wanderings15215834wa__nderings
wavering152410544wav___ering
wondering142110464__wondering

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit1488191119.28316031.3
3Display Results1111110.0601850.0
 (SQL Overall)1786911119.76618297.3
 
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.