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

256 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
goneness931076(None) 
doneness9411511doneness
loneness8512091loneness
oneness7512141_oneness
aloneness957312aloneness
boneless10310212boneless
boniness102211802boniness
fineness11310642fineness
fondness1237212fondness
gameness112810692gameness
gonenesses11310252gonenesses
goodness1036252goodness
gooeyness1343532gooeyness
goriness9310752goriness
governess1346172governess
longness938542longness
moreness10911572moreness
proneness11310442proneness
saneness82313722saneness
soleness8814262soleness
soreness8914792soreness
toneless8610392toneless
woeness1020211542wo_eness
zoneless1737822zoneless
agileness1046493agileness
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
congeners122511123congeners
congress1138073congress
conines93827793conine_s
conners94023113con_ners
conveners142911443conveners
convenes132916913convene_s
coolness1037743coolness
coreless103013833coreless
corniness112611183corniness
cosiness103214283cosiness
coyness1277323co_yness
cozeners19297783cozeners
coziness19319823coziness
cuteness1039673cuteness
dankness13256693dankness
denseness1046863denseness
direness9311303direness
donees74519493done_e_s
donenesses11310563donenesses
donnees84210363don_nees
dopeyness1543473dopeyness
dopiness11289973dopiness
dourness947683dourness
downiness13106713downiness
doziness18228553doziness
dueness82310123_dueness
dunness8298983dun_ness
evenness1135543evenness
foulness11236653foulness
foxiness18257403foxiness
foziness20257803foziness
freeness11710443freeness
gaminess112911053gaminess
gannets83811443gan_nets
gastness9278473gastness
gateless9279953gateless
gauntness1044203gauntness
gayness1136843g_ayness
genes65133093g__ene_s
geneses82613523g__eneses
genesis82510823g__enesis
genets75716663g__enets
gentleness1145593gentleness
ginners84314213gin_ners
gladness1036153gladness
glegness1034613glegness
glibness1134133glibness
glueyness1342913glueyness
gluiness937363gluiness
glumness1135203glumness
gneiss765953g_ne_iss
goalless935723goalless
goddess1035263go_ddess
godless938403go_dless
godliness1136593godliness
goldenest1147873goldenest
goldenness1243413goldenness
gomerels1144563gomerels
gonefs10439873go__nefs
goners74420163go__ners
goofiness1365603goofiness
gooneys11407073go_oneys
gormless11235443gormless
goutiness1038763goutiness
governessy1741853governessy
grandness1138303grandness
graveness13288383graveness
grayness1235933grayness
greenest9312623greenest
greenness1046793greenness
greyness1235243greyness
grimness1175993grimness
grossness1045963grossness
groveless13235363groveless
gunless8299633gun_less
gunnels8358563gun_nels
gunners83111723gun_ners
gyrenes11267523gyrene_s
haleness11312623haleness
hokeyness1943793hokeyness
hokiness152510183hokiness
holeless1189363holeless
holiness112512503holiness
homeless131110133homeless
homeyness1745003homeyness
hominess132712453hominess
hopeless13118303hopeless
hornedness1445403hornedness
horniness12309143horniness
hotness1038603ho_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
looseness937463looseness
lornness836493lornness
lostness837683lostness
loudness937013loudness
loveless1168573loveless
lowness1037813lo_wness
maleness10312313maleness
maneless102812343maneless
moneyers1337423moneyers
moneyless1444653moneyless
mooniness11157863mooniness
mootness1036753mootness
mopiness12259063mopiness
moveless1367753moveless
muteness1039013muteness
nenes55329673__nene_s
newness1035703__newness
niceness1039843niceness
nobleness1147513nobleness
nonnews1035313non_news
nonsenses948333nonsenses
noseless839513noseless
nosiness83211393nosiness
notedness1047323notedness
noteless839403noteless
nowness1037033no_wness
nudeness936733nudeness
oddness935313_oddness
oldness836403_oldness
onenesses9311823_onenesses
oogeneses1047853oogeneses
oogenesis1046063oogenesis
ooziness17237513ooziness
openers9339493_openers
openest9312913_openest
openness1035473_openness
paleness10312983paleness
paneless102611763paneless
phoniness1436293phoniness
pinenes93416673pinene_s
pinkness1436513pinkness
planeness1138153planeness
poetess938933po_etess
pokiness14219863pokiness
poleless1089873poleless
poorness1036353poorness
popeless1288473popeless
poshness1356643poshness
puniness101610273puniness
pureness101110183pureness
rankness12267943rankness
rareness81112853rareness
rifeness1138583rifeness
ripeness1039363ripeness
ronnels7318613ron_nels
ropiness102311073ropiness
rosiness82613173rosiness
roundness1047003roundness
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.1701051123.5
2DLD Change Limit1461622569.17315933.9
3Display Results2562560.1102327.3
 (SQL Overall)1786912569.45318903.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.