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

240 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
neatness83915(None) 
nearness838311nearness
beatless103311592beatless
deadness1039232deadness
deafness1236212deafness
dearness939972dearness
deftness1236302deftness
fatness103311292_fatness
flatness1138152flatness
greatness1036902greatness
heatless113011462heatless
ineptness1145072ineptness
inertness947972inertness
leanness837372leanness
meanness1037182meanness
meatiness11311182meatiness
meatless103410862meatless
meetness1036652meetness
neatens73310402neat_ens
neatest72516002neat_est
neatnesses10310012neatnesses
neatniks1242762neatniks
netless739862ne_tless
newness1035702ne_wness
patness92912282_patness
peartness1137772peartness
pertness10310092pertness
realness8410442realness
seatless83213002seatless
weakness1535352weakness
wetness10277722we_tness
whatness1435092whatness
adeptness1273953adeptness
alertness946053alertness
apartness1146053apartness
aptness9268573_aptness
awayness1443303awayness
badness1039573_badness
beadiness12249233beadiness
beakless14297383beakless
beamless12327003beamless
beaters94925043beat_ers
beatniks1444043beatniks
beltless10297713beltless
biasness1035813biasness
bleakness1543593bleakness
centners1057243centners
cetanes9315133cetane_s
cheapness1643743cheapness
cleanness1144973cleanness
clearness1135633clearness
coatless1039693coatless
curtness1037263curtness
daftness1235533daftness
deaconess1245543deaconess
deathless1335223deathless
debtless1135653debtless
deepness1136443deepness
demoness1138053demoness
dewiness1238453dewiness
drabness1135803drabness
earless74316073_earless
earners74016453_earners
earnest7318733_earnest
earnests837853_earnests
easiness8313043_easiness
eaters65535953_eat_ers
eeriness8311873eeriness
enates64026433enat_e_s
erectness1146123erectness
exactness1843623exactness
farness102912203_farness
fastness11238763fastness
fatless103212203_fatless
fearless1137873fearless
feastless1235043feastless
featest102715113feat_est
feathers143513243feathers
feetless1137383feetless
fellness1135913fellness
fewness1335003fe_wness
feyness1334923fe_yness
fitness10299393_fitness
fleetness1244753fleetness
gastness9278473gastness
gayness1136843_gayness
gearless937373gearless
giantess933893giantess
gladness1036153gladness
grayness1235933grayness
harness102413933_harness
hatless103813443_hatless
headiness132510363headiness
headless12289863headless
heartiness1338033heartiness
heartless1236393heartless
heaters104225223heat_ers
heathens143210153heathens
heathers143914733heathers
heathless1535593heathless
heaviness15207063heaviness
heftiness1536313heftiness
hotness1038613_hotness
inaptness1144333inaptness
inexactness2052693inexactness
innateness1046893innateness
intactness1244313intactness
intentness1047363intentness
irateness9310493irateness
jettiness1675693jettiness
justness1535323justness
keenness1234883keenness
lateness82614073_lateness
laxness1436043_laxness
leadless9248793leadless
leafiness1236483leafiness
leafless11246573leafless
leakiness1337503leakiness
leakless12246983leakless
leaners73718173lea_ners
leanest7415863lea_nest
learners8398153learners
leathers114215083leathers
lewdness1254173lewdness
loathness1244703loathness
lostness837683lostness
madness10310073_madness
matiness102114753_matiness
matless93014043_matless
mealiness11310063mealiness
mealless10288363mealless
meaners94415243mea_ners
meanest9315703mea_nest
meatiest102816793meatiest
meatuses1038203meatuses
meekness1434303meekness
mootness1036753mootness
napless93110283n_apless
nastiness92310573nastiness
nates55238333n_at_e_s
nathless11127023n_athless
natters73718063n_atters
nattiness9239333nattiness
nearest73415843nea_rest
nearnesses1039103nearnesses
neaten64214543neat_e_n
neatened937043neatened
neater64424313neat_e_r
neatherd12107193neatherd
neatherds1395773neatherds
neatnik1143333neatn_ik
neats55931903neat___s
neckless14236433neckless
neediness10227733neediness
needless9308333needless
negaters9349783negat_ers
negates83215843negat_e_s
nenes55329673ne__ne_s
nerdiness10208333nerdiness
nerviness12226873nerviness
nesters74422793nest_ers
nestlers8359223nestlers
nestles73015463nestle_s
netters73618583ne_tters
nettiest83112433nettiest
nettlers8307513nettlers
nettles73214083nettle_s
neuters74212273neut_ers
newsiness1236033newsiness
newsless1134533newsless
niceness1039843niceness
niftiness1236363niftiness
nighness1236103nighness
nosiness83211393nosiness
nowness1037033n_owness
nudeness936733nudeness
numbness1234413numbness
nuttiness9207563nuttiness
oneness7512143one__ness
oratress834553oratress
ovalness1134673ovalness
overtness1238223overtness
pastness102510503pastness
peakless14236683peakless
peatiest103118803peatiest
peltless10267373peltless
pettiness1178703pettiness
pleatless1134613pleatless
raptness1046733raptness
rawness1038153_rawness
readiness102611853readiness
reassess836513reassess
redness82012443re_dness
regalness1045473regalness
restless82713163restless
restress82511773restress
sadness8310613_sadness
saltness82610243saltness
scantness1135733scantness
seaminess11310473seaminess
seamless10238723seamless
seaters74028943seat_ers
sedateness1146663sedateness
selfness1135153selfness
sexiness1537943sexiness
slatiness92511363slatiness
smartness1136143smartness
sneakiness1454873sneakiness
softness1136433softness
squatness1844943squatness
swartness1236113swartness
sweatiness1336463sweatiness
sweetness1245683sweetness
tartness82210133tartness
tautness8217183tautness
teariness9310633teariness
tearless848713tearless
tentless8229843tentless
testiness9209753testiness
textless15245793textless
titaness836723titaness
unaptness1154173unaptness
uneasiness1046393uneasiness
unfitness1244843unfitness
unharness1245253unharness
vastness11257293vastness
ventless11249053ventless
vestless11258843vestless
waeness102512783_waeness
wanness102610683_wanness
weaners104613833wea_ners
weariness1238843weariness
weathers143412833weathers
wellness1135793wellness
wheatless1534003wheatless
witness103010013_witness
yearners11346373yearners
yeastiness1344883yeastiness
yeastless1234053yeastless
zestless17247433zestless

Search took 9 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 Limit1461622407.76618820.8
3Display Results2402400.1102181.8
 (SQL Overall)1786912408.29621539.4
 
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.