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

275 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
oldness83640(None) 
boldness1136971boldness
coldness1137951coldness
oddness935311oddness
badness1039572badness
baldness1137042baldness
eldress835002eldress
fondness1237212fondness
gladness1036152gladness
goodness1036252goodness
holiness112512502holiness
illness736472illness
loudness937012loudness
lowness1037812lowness
madness10310072madness
mildness1136522mildness
moldiness12227052moldiness
oiliness8311562oiliness
oldest72114092old_est
oldies7314422oldie_s
oldnesses1037702oldnesses
oneness7512142oneness
redness82012442redness
sadness8310612sadness
slyness1035262slyness
soleness8814262soleness
solidness1036902solidness
voidness1235552voidness
wildness1236202wildness
acidness1136723acidness
address956103address
agedness1036683agedness
aidless83612073aidless
alders74218423ald_ers
aldoses8311203aldoses
algidness1144273algidness
aliners74717723aliners
alines65735223aline_s
almners9399563almners
aptness9268573aptness
aridness939223aridness
avidness1246113avidness
bedless1039703bedless
bigness1038193bigness
blandness1235973blandness
bless75917813bl__ess
blindness1235343blindness
blondness1234963blondness
blueness1038213blueness
boldest102613063bold_est
boldnesses1337233boldnesses
boloneys1334503boloneys
boltless10338283boltless
bondless1148813bondless
boniness102211803boniness
boundness1235943boundness
boxiness17247813boxiness
broadness1256663broadness
budless1038873budless
calmness1236643calmness
clines84926043cline_s
cloners94514823cloners
clones84526563clone_s
coldest102514763cold_est
coldnesses1338423coldnesses
colonels104210463colonels
colones96124433colone_s
coolness1037743coolness
cordless11299963cordless
cosiness103214283cosiness
coyness1277323coyness
coziness19319823coziness
deadness1039233deadness
dimness1038843dimness
doneness9411513doneness
dopiness11289973dopiness
dourness947683dourness
dowdiness1485693dowdiness
doziness18228553doziness
dress65319833__dress
drollness1043623drollness
dryness11114783dryness
dueness82310123dueness
dullness934873dullness
dulness8307983dulness
dunness8298983dunness
elders74817303eld_ers
eldest72912683eld_est
endless839833endless
eyedness1245103eyedness
farness102912203farness
fatness103311293fatness
fellness1135913fellness
fewness1335003fewness
feyness1334923feyness
fitness10299393fitness
flanes94522423flane_s
flatness1138153flatness
flenses1039473flenses
fluidness1344293fluidness
flyless1335003flyless
folders113514393fold_ers
foodless12338383foodless
fordless12289003fordless
foulness11236653foulness
foxiness18257403foxiness
foziness20257803foziness
fullness1135443fullness
fulness10248963fulness
gayness1136843gayness
gelidness1144473gelidness
glegness1034613glegness
glibness1134133glibness
gluiness937363gluiness
glumness1135203glumness
goddess1035263goddess
godless938403godless
godliness1136593godliness
goldenest1147873goldenest
goldenness1243413goldenness
goldest92411173gold_est
goneness9310763goneness
goriness9310753goriness
haleness11312623haleness
halfness1435563halfness
hardness122411083hardness
harness102413933harness
hipness12277383hipness
hokiness152510183hokiness
holders113715903hold_ers
holeless1189363holeless
hominess132712463hominess
hoodless12289733hoodless
hotness1038613hotness
iciness938863iciness
idleness936843idleness
jokiness19227393jokiness
jolliness1636213jolliness
jowliness1934853jowliness
kidneys1533423kidneys
kindness13236653kindness
lanes54946793_lane_s
laxness1436043laxness
lenes54738523_lene_s
lenses64620893_lenses
less45635103_l__ess
lewdness1254173lewdness
lidless8309273lidless
linens64818393_linens
liners65428853_liners
lines57054573_line_s
lioness739103lioness
loaners73913623loaners
lodens74315063lod_ens
lodes66436913lod_e_s
lodgers95113833lodgers
lodges86820153lodge_s
loess55714703_l_oess
loginess9310163loginess
loneness8512093loneness
loners64225813_loners
longness938553longness
looneys10487013looneys
lordless9277483lordless
lornness836493lornness
lostness837683lostness
lowliness1236403lowliness
lunes55337773_lune_s
lunets66914763_lunets
maleness10312313maleness
molders103315553mold_ers
moldiest11249693moldiest
moodiness12197593moodiness
mootness1036753mootness
mopiness12259063mopiness
moreness10911573moreness
ness45526563___ness
newness1035703newness
nobleness1147523nobleness
nosiness83211393nosiness
notedness1047323notedness
nowness1037033nowness
nudeness936733nudeness
oarless73913373oarless
obsess845943o_bsess
oddest81710863o_ddest
oddnesses1136353oddnesses
odes57243243o_d_e_s
ogress7529503o_gress
olden65114853old_e_n
older65121173old_e_r
oldie6415473oldie__
oldish10169313old_ish
olds55926573old___s
oldsters996733oldsters
oleines7313393oleine_s
oleos55419683ol__eos
oles46453473ol__e_s
olingos846013olingos
olives94313953olive_s
ones46146533o__ne_s
oodles73517183oodle_s
ooziness17237513ooziness
openers9339493openers
openest9312913openest
openness1035473openness
opines84820703opine_s
oppress1135993oppress
orbless937493orbless
orders74315993ord_ers
ordines83014903ordine_s
outdress9137323outdress
ovalness1134673ovalness
ovines94614343ovine_s
owners94210703o_wners
ozones1539393ozone_s
paleness10312983paleness
patness92912283patness
planers94517943planers
planes85028083plane_s
planets93914083planets
planless1036813planless
pokiness14219863pokiness
polders103617373pold_ers
poleless1089873poleless
poorness1036363poorness
poshness1356653poshness
proudness1246693proudness
rawness1038153rawness
redress82511873redress
roadless937703roadless
rodless8310073rodless
ropiness102311073ropiness
rosiness82613173rosiness
roundness1047013roundness
rowdiness1396233rowdiness
rudeness938083rudeness
saltness82610243saltness
selfness1135153selfness
shyness1344993shyness
slimness1036523slimness
slowness1135013slowness
softness1136433softness
solders83517773sold_ers
soldiers9277773soldiers
soleless8910033soleless
solonets838233solonets
soreness8914793soreness
soundness1036963soundness
sourness839543sourness
tallness837103tallness
tidiness938793tidiness
toadless936313toadless
tolanes74216313tolane_s
ugliness936863ugliness
undress838893undress
validness13125363validness
vileness1139983vileness
waeness102512783waeness
wanness102610683wanness
weldless12285813weldless
wellness1135793wellness
wetness10277723wetness
wholeness1545373wholeness
wideness12259473wideness
wiliness1139113wiliness
witness103010013witness
woeness1020211543woeness
woodiness13147873woodiness
woodless12278453woodless
wooliness12147693wooliness
wordiness13138633wordiness
wordless12258843wordless
wornness1136363wornness
wryness13113983wryness

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 Filter1786911340270.423422437.4
2DLD Change Limit1340272756.76319817.7
3Display Results2752750.1102500.0
 (SQL Overall)1786912757.29624491.6
 
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.