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

228 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
oddness93531(None) 
oldness836401oldness
address956102address
badness1039572badness
boldness1136972boldness
coldness1137952coldness
fondness1237212fondness
goddess1035262godd_ess
goodness1036252goodness
loudness937012loudness
madness10310072madness
oddest81710862odd_est
oddnesses1136352oddnesses
oneness7512142oneness
redness82012442redness
sadness8310612sadness
voidness1235552voidness
acidness1136723acidness
addends10356053addends
adders84315703add_ers
addles84216603addle_s
addrest958633addrest
agedness1036683agedness
aidless83612073aidless
aptness9268573aptness
aridness939223aridness
avidness1246113avidness
baldness1137043baldness
bedless1039703bedless
bigness1038193bigness
blondness1234963blondness
bodiless1135913bodiless
bondless1148813bondless
boniness102211803boniness
boundness1235943boundness
boxiness17247813boxiness
broadness1256663broadness
budless1038873budless
codders114114453codd_ers
coddlers12359173coddlers
coddles114213593coddle_s
codeless112010113codeless
coolness1037743coolness
cordless11299963cordless
cosiness103214283cosiness
coyness1277323coyness
coziness19319823coziness
deadness1039233deadness
denes65639723_dene_s
dimness1038843dimness
diners75525953_diners
dines66449153_dine_s
dodders105511793dodders
dodgems12576443dodgems
dodgers105213823dodgers
dodges96119083dodge_s
dodginess1235283dodginess
dodoes85716103dodoe_s
donees74519493_donees
doneness9411513doneness
donnees84210363donnees
dopiness11289973dopiness
dourness947683dourness
dowdiness1485693dowdiness
downers113912773downers
downless1236363downless
doziness18228553doziness
dress65319833__dress
dryness11114783dryness
dueness82310123dueness
dulness8307983dulness
dunes65332173_dune_s
dunness8298983dunness
duress74712063_duress
dynels10536813_dynels
dynes95917583_dyne_s
eddies83313163eddie_s
eddoes8199143eddoe_s
edginess1036053edginess
eldress835003eldress
endless839833endless
eyedness1245103eyedness
fadedness1445613fadedness
farness102912203farness
fatness103311293fatness
fewness1335003fewness
feyness1334923feyness
fitness10299393fitness
fodders124010753fodd_ers
foodless12338383foodless
fordless12289003fordless
foulness11236653foulness
foxiness18257403foxiness
foziness20257803foziness
fulness10248963fulness
gayness1136843gayness
giddiness1234683giddiness
gladness1036153gladness
godless938403godless
godliness1136593godliness
goneness9310763goneness
goriness9310753goriness
hardness122411083hardness
harness102413933harness
hipness12277383hipness
hoddens12378803hodd_ens
hokiness152510183hokiness
holiness112512503holiness
hominess132712453hominess
hoodedness1544563hoodedness
hoodless12289733hoodless
hotness1038613hotness
iciness938863iciness
idleness936843idleness
illness736473illness
iodines83616633iodine_s
jadedness1844693jadedness
jokiness19227393jokiness
kidneys1533423kidneys
kindness13236653kindness
laxness1436043laxness
lewdness1254173lewdness
lidless8309273lidless
lioness739103lioness
loginess9310163loginess
loneness8512093loneness
longness938553longness
lordless9277483lordless
lornness836493lornness
lostness837683lostness
lowness1037813lowness
mildness1136523mildness
moldiness12227053moldiness
moodiness12197593moodiness
mootness1036753mootness
mopiness12259063mopiness
moreness10911573moreness
muddiness1334763muddiness
ness45526563___ness
newness1035703newness
nodders94410263nodd_ers
noddies93512043noddie_s
noddles92911293noddle_s
nosiness83211393nosiness
notedness1047323notedness
nowness1037033nowness
nudeness936733nudeness
oarless73913373oarless
obsess845943o_bsess
odder74515393odd_e_r
oddish11107653odd_ish
oddment1145923oddment
oddments1244103oddments
odds68919923odd___s
odes57243243o_d_e_s
odorless934173odorless
odyles10348563odyle_s
ogress7529503o_gress
oiliness8311563oiliness
oldest72114093old_est
oldies7314423oldie_s
oldnesses1037703oldnesses
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
patness92912283patness
pokiness14219863pokiness
poorness1036363poorness
poshness1356653poshness
proudness1246693proudness
rawness1038153rawness
redress82511873redress
roadless937703roadless
rodless8310073rodless
ropiness102311073ropiness
rosiness82613173rosiness
roundness1047013roundness
rowdiness1396233rowdiness
ruddiness1135123ruddiness
rudeness938083rudeness
shoddiness1543563shoddiness
shyness1344993shyness
sidedness1146783sidedness
slyness1035263slyness
sodaless936113sodaless
soddenness1242903soddenness
soddens9348413sodd_ens
soddies92312853soddie_s
softness1136433softness
soleness8814263soleness
solidness1036903solidness
sordidness1244633sordidness
soreness8914793soreness
soundness1036963soundness
sourness839543sourness
tidiness938793tidiness
toadless936313toadless
toddies93011993toddie_s
toddlers10346963toddlers
toddles93211533toddle_s
udders83911293udd_ers
undress838893undress
waeness102512783waeness
wanness102610683wanness
wetness10277723wetness
wideness12259473wideness
wildness1236203wildness
witness103010013witness
woeness1020211543woeness
woodiness13147873woodiness
woodless12278453woodless
wordiness13138633wordiness
wordless12258843wordless
wornness1136363wornness
wryness13113983wryness

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272288.26316220.1
3Display Results2282280.0802850.0
 (SQL Overall)1786912288.74920424.2
 
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.