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

263 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
leanness83737(None) 
cleanness1144971cleanness
meanness1037181meanness
bleakness1543592bleakness
clearness1135632clearness
deadness1039232deadness
deafness1236212deafness
dearness939972dearness
keenness1234882keenness
lankness12237042l_ankness
lanners73618332l_anners
laxness1436042l_axness
leadenness1144442leadenness
leadless9248792leadless
leafiness1236482leafiness
leafless11246572leafless
leakiness1337502leakiness
leakless12246982leakless
leaners73718172lea_ners
leanest7415862lea_nest
leannesses10108342leannesses
learners8398152learners
lewdness1254172lewdness
lornness836492lornness
nearness838312nearness
neatness839152neatness
realness8410442realness
wanness102610682_wanness
weakness1535352weakness
alertness946053alertness
alienness945373alienness
awayness1443303awayness
badness1039573_badness
banners94018713_banners
bannets94013843_bannets
beadiness12249233beadiness
beakless14297383beakless
beamless12327003beamless
beanies93821093beanie_s
beatless103311593beatless
bennes86019013be_nne_s
bennets94712163be_nnets
biasness1035813biasness
blandness1235973blandness
blankness1544673blankness
bleariness1246053bleariness
branners104010923branners
cannels93413363_cannels
canners93822663_canners
canoness1039393_canoness
channels13388493channels
cheapness1643743cheapness
cleaners103610543clea_ners
cleanest10310293clea_nest
cleanliness1343263cleanliness
cleannesses13135823cleannesses
cleansers11335063cleansers
cleanses10358143cleanse_s
dankness13256693_dankness
deaconess1245543deaconess
deepness1136443deepness
deftness1236303deftness
demoness1138053demoness
dewiness1238453dewiness
drabness1135803drabness
dunness8298983_dunness
earless74316073_earless
earners74016453_earners
earnest7318733_earnest
earnests837853_earnests
easiness8313043_easiness
eeriness8311873eeriness
evenness1135543evenness
fanners103914653_fanners
farness102912203_farness
fatness103311293_fatness
fearless1137873fearless
fellness1135913fellness
fennecs12305693fe_nnecs
fennels10387903fe_nnels
fernless1136063fernless
fewness1335003fe_wness
feyness1334923fe_yness
flannels1134843flannels
flatness1138153flatness
fleetness1244753fleetness
frankness1655223frankness
gannets83811443_gannets
gayness1136843_gayness
gearless937373gearless
giantess933893giantess
gladness1036153gladness
gleaners9348073glea_ners
glegness1034613gle_gness
grandness1138303grandness
grayness1235933grayness
greatness1036903greatness
greenness1046793greenness
harness102413933_harness
headiness132510363headiness
headless12289863headless
heatless113011463heatless
heaviness15207063heaviness
humanness1443793humanness
inaneness948383inaneness
ironness836953ironness
jennets14517633je_nnets
joannes1436243joanne_s
kennels11387193ke_nnels
laciness102112553laciness
lameness102612673lameness
lancers93616643l_ancers
lances84824103l_ance_s
lancets93411163l_ancets
landers84026213l_anders
landless94011173l_andless
lanes54946793l_a_ne_s
lankest112714113l_ankest
lankiness1338053l_ankiness
lanner64920603l_anne_r
largess8408913l_argess
lateness82614073lateness
lawless1037033l_awless
laziness17239983laziness
leachers133712813leachers
leaches123319343leache_s
leadens83610983lea_dens
leaders83819603lea_ders
leadiest93314983leadiest
leafiest113410883leafiest
leaflets11244813leaflets
leaguers935063leaguers
leagues837943league_s
leakers113415423lea_kers
leakiest123212793leakiest
leaned73422543lea_ne_d
leaner64022193lea_ne_r
leanings94010183leanings
leans55536253lea_n__s
leapers93716663lea_pers
leariest83117843leariest
learned8329303learne_d
learnedness1243863learnedness
learner7319383learne_r
learns65513743learn__s
leasers74717843lea_sers
leases65428113lea_se_s
leashes103514403leashe_s
leathers114215083leathers
leavens10409303lea_vens
leavers103717783lea_vers
leaves94222383lea_ve_s
leaviest112910813leaviest
leeriness938323leeriness
legginess1135033legginess
legless838013le_gless
lenders84419643le_nders
lenes54738523le__ne_s
lenses64620893le_nse_s
lensless835583lensless
leones64417723le_one_s
levanters1254993levanters
levelness1245453levelness
lianes63819323lia_ne_s
likeness12229863likeness
liminess10510643liminess
limpness1246703limpness
linnets739833l_innets
lioness739103l_ioness
liteness82213213liteness
liveness112411393liveness
loaminess1137493loaminess
loamless10235213loamless
loaners73913623loa_ners
loathness1244703loathness
localness1145233localness
loginess9310163loginess
loneness8512093loneness
longness938553longness
looniness9137573looniness
lostness837683lostness
loudness937013loudness
lowness1037813l_owness
lushness1136233lushness
madness10310073_madness
manless93012933_manless
manners93417833_manners
mealiness11310063mealiness
mealless10288363mealless
meanders1168833meanders
meaners94415243mea_ners
meanest9315703mea_nest
meanies93620743meanie_s
meannesses12128163meannesses
meatiness11311183meatiness
meatless103410863meatless
meekness1434303meekness
meetness1036653meetness
newness1035703ne_wness
oleanders1035573oleanders
openness1035473openness
ovalness1134673ovalness
panners93621273_panners
pannes85522853_panne_s
patness92912283_patness
peakless14236683peakless
peartness1137773peartness
penners93414183pe_nners
pertness10310093pertness
plainness1155183plainness
planeness1138153planeness
planless1036813planless
planners10399933planners
pleatless1134613pleatless
pliantness1263643pliantness
rankness12267943_rankness
rawness1038153_rawness
readiness102611853readiness
reannex1434733reanne_x
reannexes1643163reannexes
reassess836513reassess
redness82012443re_dness
regalness1045473regalness
reinless8139433reinless
rennets75212633re_nnets
sadness8310613_sadness
saneness82313723_saneness
scanners10379703scanners
scantness1135733scantness
seaminess11310473seaminess
seamless10238723seamless
seances93015343seance_s
seatless83213003seatless
selfness1135153selfness
sennets73712583se_nnets
sexiness1537943sexiness
sleaziness19104703sleaziness
sleekness1344543sleekness
solemnness1243213solemnness
spanless10247363spanless
spanners103710773spanners
sternness946093sternness
tanners74018393_tanners
tannest72617853_tannest
teariness9310633teariness
tearless848713tearless
tenners74014923te_nners
thinness11277163thinness
uncleanness1352843uncleanness
vainness1136063vainness
vanners103612843_vanners
veinless11136263veinless
waeness102512783_waeness
wannest103915003_wannest
weaners104613833wea_ners
weariness1238843weariness
wellness1135793wellness
wetness10277723we_tness
whatness1435093whatness
womanness1444473womanness
wornness1136363wornness
yearners11346373yearners
zaniness1738663_zaniness

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 Limit1461622636.92321112.5
3Display Results2632630.1102390.9
 (SQL Overall)1786912637.45323975.7
 
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.