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

226 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
madnesses123983(None) 
badnesses1239241badnesses
sadnesses10310301sadnesses
baldnesses1337642baldnesses
deadnesses1238942deadnesses
farnesses122310812farnesses
fatnesses121710462fatnesses
gaynesses1336562gaynesses
gladnesses1236682gladnesses
hardnesses141810542hardnesses
harnesses121812072harnesses
laxnesses1646632laxnesses
madness10310072madne_s_s
malenesses12312202malenesses
matinesses12314522matinesses
mazednesses2345402mazednesses
mazinesses2139902mazinesses
meannesses12128162meannesses
mildnesses1397392mildnesses
oddnesses1136352oddnesses
oldnesses1037702oldnesses
patnesses111611792patnesses
rawnesses1288122rawnesses
rednesses10312302rednesses
waenesses1239772waenesses
wannesses1239232wannesses
abbesses1235333_abbesses
accesses1287493_accesses
acidnesses1337253acidnesses
addresses1165633addresses
adenoses947903_adenoses
admasses1135413_admasses
agednesses1237413agednesses
aptnesses11168993aptnesses
aridnesses1139933aridnesses
assesses737383_assesses
avidnesses1436463avidnesses
awaynesses1644273awaynesses
badasses1136173bad_asses
badness1039573badne_s_s
bandinesses14109723bandinesses
barenesses12311693barenesses
baronesses1238903baronesses
basenesses12310553basenesses
bassnesses1136833bassnesses
bawdinesses17126313bawdinesses
beadinesses1449553beadinesses
biasnesses1236943biasnesses
bignesses1267953bignesses
blandnesses1446623blandnesses
boldnesses1337223boldnesses
broadnesses1446183broadnesses
caginesses13310933caginesses
cakinesses16310603cakinesses
calmnesses1436833calmnesses
canonesses1238413canonesses
caresses10314063ca_resses
coldnesses1338423coldnesses
coynesses1437573coynesses
daftnesses1436383daftnesses
dampnesses1535603dampnesses
danknesses1536253danknesses
darknesses1537013darknesses
datednesses1357893datednesses
dazednesses2245153dazednesses
deafnesses1436223deafnesses
dearnesses1139573dearnesses
dimnesses1238213dimnesses
drabnesses1336483drabnesses
dresses83716173__dresses
drynesses1335363drynesses
duenesses1039323duenesses
dulnesses1037743dulnesses
dunnesses1037693dunnesses
easinesses10314413easinesses
eldresses1045673eldresses
eyednesses1445803eyednesses
fadednesses16126563fadednesses
fairnesses1357383fairnesses
fastnesses1389073fastnesses
fewnesses1534953fewnesses
feynesses1535223feynesses
finesses111912333_finesses
fitnesses12219373fitnesses
flatnesses1337763flatnesses
fondnesses1437703fondnesses
fulnesses1239033fulnesses
gamenesses1368983gamenesses
gaminesses13410453gaminesses
gastnesses11129133gastnesses
gaudinesses1337843gaudinesses
goddesses1243453goddesses
goodnesses1236433goodnesses
grandnesses1348113grandnesses
graynesses1436143graynesses
halenesses13312033halenesses
halfnesses1636263halfnesses
handinesses151410273handinesses
hardinesses151110213hardinesses
harnessed13186193harnessed
hazinesses2239213hazinesses
headinesses1539843headinesses
hipnesses1436753hipnesses
hotnesses1238903hotnesses
humannesses1643853humannesses
humidnesses1744573humidnesses
icinesses11310053icinesses
idlesses936003_idlesses
illnesses937273illnesses
jadednesses20145773jadednesses
kindnesses1537213kindnesses
lacinesses12312103lacinesses
lamenesses12610563lamenesses
lanknesses1437503lanknesses
largesses10246273largesses
latenesses10413353latenesses
lazinesses19310143lazinesses
leannesses10108343leannesses
lewdnesses1435393lewdnesses
lionesses939423lionesses
loudnesses1138433loudnesses
lownesses1236983lownesses
madhouses1545743madhouses
madrases112610003mad_rases
madrassas12304703madrassas
magnesias1245693magnesias
magnesites131898333magnesites
magnetises136710093magnetises
maltinesses13310223maltinesses
maneges103612143ma_ne_ges
maneless102812343ma_neless
manginesses1499593manginesses
manlinesses13910193manlinesses
mannoses1039083ma_nnoses
manses84225513ma_n__ses
mantises10317923ma_ntises
markednesses1944173markednesses
marquesses2143353marquesses
masses85028713ma___sses
masseuses1144793masseuses
massinesses12128683massinesses
mateynesses1645163mateynesses
matrasses1157283matrasses
mattresses1245433mattresses
mayoresses1543693mayoresses
mealinesses13310973mealinesses
meatinesses13311973meatinesses
meeknesses1644803meeknesses
meetnesses1237443meetnesses
messes84924343m___esses
mirinesses121512303mirinesses
moldinesses14138043moldinesses
moodinesses14147643moodinesses
mootnesses1237153mootnesses
mopinesses14139113mopinesses
morenesses12811383morenesses
muchnesses1744693muchnesses
muddinesses1535263muddinesses
mutenesses1289933mutenesses
nakednesses1645843nakednesses
nearnesses1039093nearnesses
neatnesses10310003neatnesses
nesses64718323___nesses
newnesses1236123newnesses
nownesses1236883nownesses
nudenesses1157853nudenesses
onenesses9311823onenesses
ovalnesses1346043ovalnesses
packnesses1856623packnesses
palenesses12312653palenesses
pastnesses12910503pastnesses
rabidnesses1476123rabidnesses
racinesses12313493racinesses
randinesses121311203randinesses
ranknesses1438093ranknesses
rapidnesses1476463rapidnesses
raptnesses1248523raptnesses
rarenesses10313093rarenesses
rashnesses1338713rashnesses
readinesses12611263readinesses
realnesses10310843realnesses
redresses10410293redresses
rudenesses1188863rudenesses
sadness8310613sadne_s_s
safenesses1349373safenesses
sagenesses11510823sagenesses
saltnesses10310163saltnesses
samenesses12410853samenesses
sandinesses12911393sandinesses
sanenesses10412693sanenesses
shadinesses1538643shadinesses
shynesses1535313shynesses
slynesses1235863slynesses
smallnesses1344963smallnesses
smartnesses1337143smartnesses
smugnesses1344563smugnesses
staidnesses1237193staidnesses
tallnesses1037463tallnesses
tamenesses1259963tamenesses
tardinesses121110243tardinesses
tartnesses101110713tartnesses
tautnesses10118283tautnesses
tidinesses1139213tidinesses
timidnesses1445143timidnesses
tumidnesses1444603tumidnesses
undresses1039313undresses
vainnesses1337343vainnesses
validnesses1576023validnesses
vapidnesses1774893vapidnesses
vastnesses13128193vastnesses
voidnesses1436833voidnesses
wardresses1445413wardresses
warinesses131514513warinesses
warmnesses15167353warmnesses
wavinesses16199273wavinesses
waxinesses20138753waxinesses
weaknesses1735463weaknesses
wetnesses12208213wetnesses
whatnesses1635733whatnesses
widenesses1438773widenesses
wildnesses14157363wildnesses
witnesses12219923witnesses
woenesses1239133woenesses
womannesses1644373womannesses
wrynesses1534843wrynesses
zaninesses19310373zaninesses

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486412268.06318434.9
3Display Results2262260.1261793.7
 (SQL Overall)1786912268.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.