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

243 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
dankness1325669(None) 
darkness13247341darkness
lankness12237041lankness
rankness12267941rankness
blankness1544672blankness
canoness1039392canoness
daftness1235532daftness
dampness1336072dampness
dankest122611672dank_est
danknesses1536252danknesses
doneness9411512doneness
dunness8298982dun_ness
frankness1655222frankness
lankiness1338052lankiness
packness1636932packness
pinkness1436512pinkness
rankless12268232rankless
saneness82313722saneness
tankless12267822tankless
wanness102610682wan_ness
zaniness1738662zaniness
ancress978613_ancress
ankles104818383_ankle_s
anklets114310413_anklets
ankuses1148203_ankuses
aptness9268573_aptness
backless162910633backless
badness1039573ba_dness
baldness1137043baldness
balkiness1556903balkiness
bandiness122310243bandiness
bankers133919093bank_ers
banners94018713ban_ners
bannets94013843ban_nets
bareness10912813bareness
barkless14318023barkless
baroness101210063baroness
baseness10910943baseness
bassness1096743bassness
blackness1735663blackness
blandness1235973blandness
boniness102211803boniness
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
canines93724033canine_s
cankers134418753cank_ers
cannels93413363can_nels
canners93822663can_ners
canniness1138643canniness
crankiness1636173crankiness
dackers143417043dack_ers
daffiness1634843daffiness
daikers124010313daik_ers
dailiness1038673dailiness
dailyness1343643dailyness
daintiness1145963daintiness
damners104112113da_mners
dancers103413093dan_cers
dances95120653dan_ce_s
danders93921183dan_ders
dandies94121443dandie_s
dandiest103415033dandiest
dandlers103912053dandlers
dandles94218533dandle_s
dangers94818213dan_gers
danglers103610593danglers
dangles93618423dangle_s
danker114319663dank_e_r
daphnes13327683daphne_s
daringness1244743daringness
darkeners1435153darkeners
darkens12409873dark_ens
darkest122512623dark_est
darkeys15356533dark_eys
darkies124015753darkie_s
darkles124011933darkle_s
darknesses1537013darknesses
darnels83710433da_rnels
darners83815773da_rners
datedness1187753datedness
dateless9259963dateless
dauntless1033663dauntless
dazedness20114963dazedness
deaconess1245543deaconess
deadness1039233deadness
deafness1236213deafness
dearness939973dearness
deepness1136443deepness
deftness1236303deftness
demoness1138053demoness
denseness1046863denseness
dewiness1238453dewiness
dimness1038843d_imness
dinginess1137823dinginess
dinkeys15507263dink_eys
dinkies123716033dinkie_s
dinkiest133812873dinkiest
dinners83915443din_ners
direness9311303direness
donkeys15426663donk_eys
donnees84210363don_nees
dopiness11289973dopiness
dorkiness14248053dorkiness
dourness947683dourness
downiness13106713downiness
doziness18228553doziness
drabness1135803drabness
dryness11114783d_ryness
dueness82310123d_ueness
dullness934873dullness
dulness8307983d_ulness
dumbness1334613dumbness
dunkers123512193dunk_ers
dunnest83312263dun_nest
duskiness14216683duskiness
dwarfness1642793dwarfness
easiness8313043easiness
faintness1235833faintness
fairness1136563fairness
fanciness1437673fanciness
fangless1237663fangless
fanners103914653fan_ners
farness102912203fa_rness
fastness11238763fastness
fatness103311293fa_tness
fineness11310643fineness
fondness1237213fondness
funkiness16226873funkiness
gameness112810693gameness
gaminess112911063gaminess
gannets83811443gan_nets
gastness9278473gastness
gauntness1044203gauntness
gawkiness1734753gawkiness
gayness1136843ga_yness
goneness9310763goneness
grandness1138303grandness
hackneys2033683hackneys
haleness11312623haleness
halfness1435563halfness
handiness132110933handiness
handless123512063handless
hangnest12311413hangnest
hangnests1344543hangnests
hankers144218133hank_ers
hankies143617763hankie_s
hardness122411083hardness
harness102413933ha_rness
haziness20248513haziness
inaneness948383inaneness
inkiness1238693_inkiness
inkless11348713_inkless
kindness13236653kindness
kinkiness1235763kinkiness
laciness102112553laciness
lameness102612673lameness
landless94011173landless
lankest112714113lank_est
lankiest122912493lankiest
lanknesses1437503lanknesses
lanners73618333lan_ners
larkiness1338113larkiness
lateness82614073lateness
laxness1436043la_xness
laziness17239983laziness
leanness837373lean_ness
loneness8512093loneness
longness938553longness
madness10310073ma_dness
maleness10312313maleness
maneless102812343maneless
manginess122010413manginess
manless93012933man_less
manliness111310123manliness
manners93417833man_ners
matiness102114753matiness
maziness19239543maziness
meanness1037183mean_ness
meekness1434303meekness
nankeens1243243nankeens
oneness7512143_oneness
paleness10312983paleness
paneless102611763paneless
panners93621273pan_ners
pannes85522853pan_ne_s
pastness102510503pastness
patness92912283pa_tness
pawkiness1835443pawkiness
planeness1138153planeness
puniness101610273puniness
punkiness15226983punkiness
raciness102413453raciness
raininess949273raininess
randiness102511443randiness
ranginess101610213ranginess
rankers113217463rank_ers
rankest112713813rank_est
rankles113114543rankle_s
ranknesses1438093ranknesses
raptness1046733raptness
rareness81112853rareness
rashness1138093rashness
rawness1038153ra_wness
sadness8310613sa_dness
safeness11239633safeness
sageness92111983sageness
saltness82610243saltness
sameness102712683sameness
sandiness102111713sandiness
sandless93212343sandless
scantness1135733scantness
sickness1437833sickness
slackness1535433slackness
snakiness1367473snakiness
starkness1335963starkness
swankiness1744253swankiness
tackiness1557693tackiness
tackless14419483tackless
talkiness1356913talkiness
tallness837103tallness
tameness102411253tameness
tanginess10239283tanginess
tankers113416913tank_ers
tanners74018393tan_ners
tannest72617853tan_nest
tartness82210133tartness
tautness8217183tautness
tawniness1245123tawniness
thankless1633203thankless
tininess8310633tininess
vainness1136063vainness
vanners103612843van_ners
vastness11257293vastness
wackiness1836523wackiness
waeness102512783wa_eness
wankers144514713wank_ers
wannest103915003wan_nest
wariness11313213wariness
warmness1337063warmness
waviness1437723waviness
waxiness1836723waxiness
weakness1535353weakness

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622436.40322827.1
3Display Results2432430.1102209.1
 (SQL Overall)1786912436.91925826.1
 
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.