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

269 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
doneness941151(None) 
goneness9310761goneness
loneness8512091loneness
oneness7512141_oneness
aloneness957312aloneness
boneless10310212boneless
boniness102211802boniness
dankness13256692dankness
denseness1046862denseness
direness9311302direness
donees74519492done_e_s
donenesses11310562donenesses
donnees84210362don_nees
dopeyness1543472dopeyness
dopiness11289972dopiness
dourness947682dourness
downiness13106712downiness
doziness18228552doziness
dueness82310122d_ueness
dunness8298982dun_ness
fineness11310642fineness
fondness1237212fondness
longness938552longness
moreness10911572moreness
proneness11310442proneness
saneness82313722saneness
soleness8814262soleness
soreness8914792soreness
toneless8610392toneless
woeness1020211542wo_eness
zoneless1737822zoneless
bareness10912813bareness
baseness10910943baseness
blondness1234963blondness
blueness1038213blueness
boldness1136973boldness
bondless1148813bondless
bonesets1036843bonesets
boneyest1347843boneyest
bonnes85621453bon_ne_s
bonnets94812803bon_nets
bonniness1136733bonniness
boundness1235943boundness
boxiness17247813boxiness
canoness1039393canoness
closeness1137613closeness
codeless112010113codeless
coldness1137953coldness
condenses12710133condenses
conenose1078593conenose
conenoses1188903conenoses
confess12399903con_fess
congeners122511133congeners
congress1138073congress
conines93827793conine_s
conners94023113con_ners
conveners142911443conveners
convenes132916913convene_s
coolness1037743coolness
coreless103013833coreless
corniness112611183corniness
cosiness103214283cosiness
coyness1277323co_yness
cozeners19297783cozeners
coziness19319823coziness
cuteness1039673cuteness
daftness1235533daftness
dampness1336073dampness
darkness13247343darkness
datedness1187753datedness
dateless9259963dateless
dazedness20114963dazedness
deadness1039233deadness
deafness1236213deafness
dearness939973dearness
deepness1136443deepness
defenses1237913defenses
deftness1236303deftness
demoness1138053demoness
denes65639723d__ene_s
dewiness1238453dewiness
dienes75719903d_iene_s
digeneses1147393digeneses
digenesis1145333digenesis
dimness1038843d_imness
dinginess1137823dinginess
dinners83915443din_ners
docents102810803docen_ts
dodginess1235283dodginess
doggedness1443513doggedness
domines102918973domine_s
donates83217223donate_s
donee66931013done_e__
dongles93212873dongle_s
donkeys15426663don_keys
donnas75511323don_n_as
donne65520463don_ne__
donned85015743don_ne_d
donnee74317063don_ne_e
donnerd9427813don_nerd
donnert82815523don_nert
donnish11187633don_nish
donzels1735393don_zels
doorless936713doorless
dorkiness14248053dorkiness
dottiness1058043dottiness
doubleness1345763doubleness
dovekeys1941723dovekeys
dovened12389063dovene_d
dovens104413903doven__s
dowdiness1485693dowdiness
dowerless1344013dowerless
downers113912773do_wners
downless1236363downless
doyennes1244363doyennes
doyens104810223doyen__s
dozened18377453dozene_d
dozens164612463dozen__s
dozenths2142793dozenths
drabness1135803drabness
drollness1043623drollness
dryness11114783d_ryness
dullness934873dullness
dulness8307983d_ulness
dumbness1334613dumbness
dunnest83312263dun_nest
evenness1135543evenness
foulness11236653foulness
foxiness18257403foxiness
foziness20257803foziness
freeness11710443freeness
gameness112810693gameness
gonenesses11310253gonenesses
goodness1036253goodness
gooeyness1343543gooeyness
goriness9310753goriness
governess1346173governess
haleness11312623haleness
hokeyness1943803hokeyness
hokiness152510183hokiness
holeless1189363holeless
holiness112512503holiness
homeless131110133homeless
homeyness1745013homeyness
hominess132712453hominess
hopeless13118303hopeless
hornedness1445403hornedness
horniness12309143horniness
hotness1038613ho_tness
hugeness1237373hugeness
idleness936843idleness
inaneness948383inaneness
innerness946913innerness
ionones7313883ionone_s
ironness836953iron_ness
jokiness19227393jokiness
joneses1438963jonese_s
keenness1234883keenness
kindness13236653kindness
lameness102612673lameness
lankness12237043lankness
lateness82614073lateness
likeness12229863likeness
lineless82711943lineless
liteness82213213liteness
liveness112411393liveness
loginess9310163loginess
loneliness1046083loneliness
lonenesses10311343lonenesses
looniness9137573looniness
looseness937473looseness
lornness836493lornness
lostness837683lostness
loudness937013loudness
loveless1168573loveless
lowness1037813lo_wness
maleness10312313maleness
maneless102812343maneless
moneyers1337423moneyers
moneyless1444653moneyless
mooniness11157863mooniness
mootness1036753mootness
mopiness12259063mopiness
moveless1367753moveless
muteness1039013muteness
nenes55329673__nene_s
newness1035703__newness
niceness1039843niceness
nobleness1147513nobleness
nonnews1035313non_news
nonsenses948343nonsenses
noseless839513noseless
nosiness83211393nosiness
notedness1047323notedness
noteless839403noteless
nowness1037033no_wness
nudeness936733nudeness
oddness935313_oddness
oldness836403_oldness
onenesses9311823_onenesses
oogeneses1047853oogeneses
oogenesis1046073oogenesis
ooziness17237513ooziness
openers9339493_openers
openest9312913_openest
openness1035473_openness
paleness10312983paleness
paneless102611763paneless
phoniness1436303phoniness
pinenes93416673pinene_s
pinkness1436513pinkness
planeness1138153planeness
poetess938933po_etess
pokiness14219863pokiness
poleless1089873poleless
poorness1036363poorness
popeless1288473popeless
poshness1356653poshness
puniness101610273puniness
pureness101110183pureness
rankness12267943rankness
rareness81112853rareness
rifeness1138583rifeness
ripeness1039363ripeness
ronnels7318613ron_nels
ropiness102311073ropiness
rosiness82613173rosiness
roundness1047013roundness
rudeness938083rudeness
safeness11239633safeness
sageness92111983sageness
sameness102712683sameness
soberness1186463soberness
softness1136433softness
soleless8910033soleless
songless9218823songless
sonless72612613son_less
sonnets74211993son_nets
soundness1036963soundness
sourness839543sourness
stoniness938343stoniness
sureness8912903sureness
tameness102411253tameness
tenseness947113tenseness
tininess8310633tininess
toeless72612393to_eless
tonemes9311683toneme_s
tonners73816403ton_ners
tonnes65320853ton_ne_s
trueness838683trueness
tuneless837913tuneless
tweeness11246403tweeness
venenes102712133venene_s
vileness1139983vileness
voidness1235553voidness
voteless1137493voteless
waeness102512783_waeness
wanness102610683wan_ness
wholeness1545373wholeness
wideness12259473wideness
wineless112711173wineless
wiseness112010753wiseness
wonners104312813won_ners
wontedness1445503wontedness
wornness1136363wornness
wrongness1344513wrongness
yokeless1535303yokeless
youngness1343373youngness
zaniness1738663zaniness

Search took 10 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.280638182.1
2DLD Change Limit1461622698.84316528.6
3Display Results2692690.1262134.9
 (SQL Overall)1786912699.24919320.0
 
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.