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

266 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
newness103570(None) 
fewness1335001fewness
nowness1037031nowness
dewiness1238452dewiness
dewless1137472dewless
feyness1334922feyness
lewdness1254172lewdness
lowness1037812lowness
nearness838312nearness
neatness839152neatness
nenes55329672ne_ne_s
netless739862netless
newels93710822new_els
newest9314212new_est
newies91014072newie_s
newnesses1236122newnesses
newsiness1236032newsiness
newsless1134532newsless
oneness7512142one_ness
rawness1038152rawness
redness82012442redness
skewness1533762skewness
wetness10277722wetness
aeneus61111143ae_neus
agedness1036683agedness
aptness9268573aptness
askewness1642043askewness
aweless1038723aweless
awless939263_awless
awnless1035923_awnless
badness1039573badness
bedless1039703bedless
benes75536233be_ne_s
bennes86019013benne_s
bennets94712163bennets
beweeps1494563beweeps
bigness1038193bigness
bowless123310313bowless
censes83721803ce_nses
chewiness1744823chewiness
coyness1277323coyness
crewless1335413crewless
deadness1039233deadness
deafness1236213deafness
dearness939973dearness
deepness1136443deepness
deftness1236303deftness
demoness1138053demoness
denes65639723de_ne_s
depress10239873depress
dewiest11312343dewiest
dimness1038843dimness
doneness9411513done_ness
downers113912773downers
downless1236363downless
dryness11114783dryness
dueness82310123dueness
dulness8307983dulness
dunness8298983dunness
eeriness8311873eeriness
egress73310433_egress
endless839833endless
ernes55224813_erne_s
esnes54817363_esne_s
evenness1135543evenness
ewers86018823_ew_ers
ewes76328703_ew_e_s
excess1546053_excess
eyedness1245103eyedness
farness102912203farness
fatness103311293fatness
fawners13388493fawners
feeless103511103feeless
fellness1135913fellness
fennecs12305693fennecs
fennels10387903fennels
fernless1136063fernless
fewest12311663few_est
fewnesses1534953fewnesses
fineness11310643fine_ness
fitness10299393fitness
freeness11710443freeness
fulness10248963fulness
gayness1136843gayness
genes65133093ge_ne_s
geneses82613523ge_neses
genesis82510823ge_nesis
genets75716663ge_nets
glegness1034613glegness
goneness9310763gone_ness
greyness1235243greyness
harness102413933harness
heiress1036813heiress
hewers123715273hew_ers
hipness12277383hipness
hotness1038613hotness
iciness938863iciness
illness736473illness
ineptness1145073ineptness
inertness947973inertness
inkiness1238693inkiness
innerness946913innerness
inverness1247133inverness
jawless1745653jawless
jennets14517633jennets
jewels16508613jew_els
keeners113610783keeners
keenest11410963keenest
keenness1234883keenness
kennels11387193kennels
kermess13396223kermess
kernels11417953kernels
kernes104717533kerne_s
keyless1436163keyless
lawless1037033lawless
laxness1436043laxness
leaners73718173leaners
leanest7415863leanest
leanness837373leanness
legless838013legless
lenes54738523le_ne_s
lenses64620893le_nses
leones64417723leone_s
lewdest1136283lewdest
lewises1039133lewises
lioness739103lioness
loneness8512093lone_ness
madness10310073madness
meaners94415243meaners
meanest9315703meanest
meanness1037183meanness
meekness1434303meekness
meetness1036653meetness
menses84222453me_nses
mesnes85216213mesne_s
mewlers12288983mewlers
nakedness1445043nakedness
napless93110283napless
nearest73415843nearest
neatens73310403neatens
neatest72516003neatest
neckers134210463neckers
neckless14236433neckless
needers84111903needers
neediness10227733neediness
needless9308333needless
needs65719633ne__eds
neems77316293ne__ems
neeps75617883ne__eps
neguses837933neguses
nemeses948663ne_meses
nemesis937373ne_mesis
nene45932063ne_ne__
neoned7311483neone_d
neons55818683neon__s
nephews1533323nephews
nerdiness10208333nerdiness
nereis6315343ne_reis
nerves94216193nerve_s
nerviness12226873nerviness
ness45526563___ness
nesses64718323nesse_s
nesters74422793nesters
netters73618583netters
neumes83112623neume_s
neuters74212273neuters
neves87021873ne_ve_s
newbies12147423newbies
newel86114133new_e_l
newer85717463new_e_r
newie81813483newie__
newish1237903new_ish
news76127373new___s
newsdesk1641733newsdesk
newsdesks1751393newsdesks
newsies101310383newsies
newsiest11107483newsiest
newsy11489393new__sy
newtons1036813newtons
newts86015283new__ts
nexuses1436743nexuses
niceness1039843niceness
nighness1236103nighness
nines55937343n_ine_s
nones55639133n_one_s
nonets64118703n_onets
nonnews1035313nonnews
nosiness83211393nosiness
notedness1047323notedness
nounless837253nounless
nownesses1236893nownesses
nudeness936733nudeness
numbness1234413numbness
oddness935313oddness
oldness836403oldness
openness1035473openness
owners94210703_owners
patness92912283patness
pawnees12298173pawnees
pawners124311073pawners
peeress939503peeress
pegless1038053pegless
penes75839223pe_ne_s
penners93414183penners
peones83821043peone_s
pertness10310093pertness
pewees11311393pew_ees
pewters124113353pewters
realness8410443realness
recess8314263re_cess
redress82511873redress
regress82711453regress
reinless8139433reinless
renest64529713re_nest
renests74014213re_nests
renews93811753re_news
rennets75212633rennets
repress92712683repress
reweds104412303rew_eds
rewets94617213rew_ets
sadness8310613sadness
saneness82313723sane_ness
sawneys13274643sawneys
seeress7311573seeress
seiners74219273seiners
seines65029903seine_s
selfness1135153selfness
sennets73712583sennets
senses63923943se_nses
sewers94719723sew_ers
sexiness1537943sexiness
sexless1467243sexless
shyness1344993shyness
sinewless1244363sinewless
slowness1135013slowness
slyness1035263slyness
snowiness1296243snowiness
snowless1145633snowless
snubness1044373snubness
snugness934323snugness
tawneys13324773tawneys
teeners74415453teeners
telnets738373telnets
tenets65518953te_nets
tenners74014923tenners
tenses64722553te_nses
ternes65422903terne_s
thewless1433923thewless
townees10269783townees
townless1135653townless
tweeness11246403tweeness
veiners104112523veiners
veinless11136263veinless
viewless1434033viewless
vowless13246603vowless
waeness102512783waeness
wanness102610683wanness
weakness1535353weakness
weaners104613833weaners
webless1237003webless
weiners103913063weiners
wellness1135793wellness
witness103010013witness
woeness1020211543woeness
wryness13113983wryness
yawners13367183yawners

Search took 7 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 Limit1340272666.42020876.5
3Display Results2662660.1102418.2
 (SQL Overall)1786912666.93625762.8
 
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.