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

137 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
leadening117673(None) 
deadening1277581deadening
ladening1078821l_adening
leavening1365971leavening
deadenings1393322deadenings
deafening1476272deafening
latening9711492l_atening
leading93419552lead__ing
leaning83721202lea__ning
learning978552lea_rning
leavenings1472582leavenings
lessening1045332lessening
loudening1144742loudening
neatening1038352neatening
reddening1237432reddening
weakening1734842weakening
adenine8311213__adenine
awakening1743203awakening
beaconing1436633beaconing
beading113221863bead__ing
beaning103820683bea__ning
beavering1538703beavering
bedamning1534183bedamning
bedewing1537143be_dewing
bemaddening1851813bemaddening
brazening2185183brazening
broadening1444033broadening
burdening1335543burdening
cadencing1544963_cadencing
cheapening1883803cheapening
cleaning113112383clea__ning
cravening1547553cravening
davening13258873_davening
deaconing1337193deaconing
deadeningly1752643deadeningly
deadlining1364563deadlining
deafenings1562503deafenings
deaning94020473dea__ning
deepening1335613deepening
diademing1454323diademing
earning83418213_ea_rning
evening11310223_e_vening
fedexing2034493fe_dexing
flehmening1942243flehmening
gardening1236513gardening
gendering12249753gendering
gladdening1442693gladdening
gleaning10269323glea__ning
greatening1245443greatening
hardening1438023hardening
havening15258553_havening
heading122919113head__ing
headlining1553773headlining
hearkening1844533hearkening
heartening1446733heartening
hoidening1435633hoidening
hoydening1744353hoydening
keening123713153ke__ening
laagering1136833laagering
labeling11311643l_abeling
lacewing1435843l_acewing
laddering1237593laddering
lading84227123l_ad__ing
ladling92813393l_ad_ling
lagering102212313l_agering
lamenting1237693l_amenting
layering122310353l_ayering
leaching143012833lea_ching
leaden74515223leade__n_
leadened1036153leaden_ed
leadenly1244733leaden_ly
leadens83610983leade__ns
leadings103511243lead__ings
leafing113313583lea__fing
leafleting1442893leafleting
leaguering1243813leaguering
leaguing1035343lea_guing
leaking123616973lea__king
leanings94010183lea__nings
leaping103215993lea__ping
learnings1094323lea_rnings
leashing123310313lea_shing
leasing83920163lea__sing
leathering1488683leathering
leaving114216853lea__ving
lechering1538443lechering
leering83417643le__ering
lending94118533lend__ing
lesioning1046443lesioning
lessoning1044773lessoning
lettering102112073lettering
leveeing12265963le_veeing
leveling122910433le_veling
levering122212503le_vering
lichening1545673lichening
likening13246893l_ikening
lippening14234943lippening
listening10128953listening
livening12248153l_ivening
loading94114613load__ing
loaning83614833loa__ning
loosening1044933loosening
maddening1445113maddening
meandering1446983meandering
meaning103918703mea__ning
mildening1345673mildening
peening103318303pe__ening
pleading123011443plead__ing
ravening122611293_ravening
readding11411363read_ding
reading93327213read__ing
readorning1245723readorning
readying13410223read_ying
reasoning10310203reasoning
redenying1437783re_denying
rehardening1644143rehardening
rendering112213183rendering
reopening1248823reopening
rewakening1843793rewakening
rewidening1544083rewidening
saddening1245213saddening
seasoning1037413seasoning
sleekening1543073sleekening
soddening1244543soddening
teaseling1036913teaseling
teazeling1934543teazeling
teddering12256303teddering
tendering112210813tendering
wakening1636323_wakening
weaning114117193wea__ning
weaponing1545383weaponing
weaseling1335613weaseling
wedeling1338773we_deling
weening114113973we__ening
widening13237833_widening
yeaning113814633yea__ning
yearning1296983yea_rning

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.406440125.6
2DLD Change Limit1486411376.93621430.4
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.40524131.1
 
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.