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 “lankness” 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
lankness1223704(None) 
blankness1544671blankness
dankness13256691dankness
lankiness1338051lankiness
rankness12267941rankness
blackness1735662blackness
blandness1235972blandness
canoness1039392canoness
darkness13247342darkness
frankness1655222frankness
laciness102112552laciness
lameness102612672lameness
landless94011172landless
lankest112714112lank_est
lankiest122912502lankiest
lanknesses1437502lanknesses
lanners73618332lan_ners
larkiness1338112larkiness
lateness82614072lateness
laxness1436042la_xness
laziness17239982laziness
leanness837372lean_ness
loneness8512092loneness
longness938552longness
packness1636932packness
pinkness1436512pinkness
planeness1138152planeness
rankless12268232rankless
saneness82313722saneness
slackness1535432slackness
tankless12267822tankless
wanness102610682wan_ness
zaniness1738662zaniness
alanines8314803alanine_s
alikeness1336333alikeness
aloneness957313aloneness
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
blankest14439063blank_est
blankets14356503blank_ets
blanknesses1744933blanknesses
bleakness1543593bleakness
blindness1235343blindness
blondness1234963blondness
bluntness1144343bluntness
boniness102211803boniness
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
canines93724033canine_s
cankers134418753cank_ers
cannels93413363can_nels
canners93822663can_ners
canniness1138643canniness
clankiest1536673clankiest
cleanness1144973clean_ness
crankiness1636173crankiness
daftness1235533daftness
dampness1336073dampness
dankest122611673dank_est
danknesses1536253danknesses
doneness9411513doneness
dunness8298983dun_ness
easiness8313043easiness
faintness1235833faintness
fairness1136563fairness
fanciness1437673fanciness
fangless1237663fangless
fanners103914653fan_ners
farness102912203fa_rness
fastness11238763fastness
fatness103311293fa_tness
fineness11310653fineness
flakiness1636473flakiness
flankers15349303flank_ers
flannels1134843flan_nels
flatness1138153fla_tness
fondness1237213fondness
funkiness16226873funkiness
gameness112810693gameness
gaminess112911063gaminess
gannets83811443gan_nets
gastness9278473gastness
gauntness1044203gauntness
gawkiness1734753gawkiness
gayness1136843ga_yness
gladness1036153gla_dness
glandless1134163glandless
glariness1038553glariness
glaziness1935753glaziness
goneness9310763goneness
grandness1138303grandness
hackneys2033683hackneys
haleness11312623haleness
halfness1435563halfness
handiness132110933handiness
handless123512063handless
hangnest12311413hangnest
hangnests1344543hangnests
hankers144218133hank_ers
hankies143617763hankie_s
hardness122411083hardness
harness102413933ha_rness
haziness20248513haziness
inaneness948383inaneness
inkiness1238693_inkiness
inkless11348713_inkless
kindness13236653kindness
kinkiness1235763kinkiness
laceless10239853laceless
lackers134120543lack_ers
lackeys16458263lack_eys
lacunes9159623lacune_s
lagunes8148523lagune_s
lakers105225153la_k_ers
lakes95737653la_k_e_s
lakiest113517273la_kiest
lancers93616643lan_cers
lances84824103lan_ce_s
lancets93411163lan_cets
lanciers10308543lanciers
landers84026213lan_ders
landlers94312833landlers
landmass1144423landmass
lanes54946793la__ne_s
langleys1245103langleys
langrels9106173langrels
langues81211913langue_s
languets987243languets
lanker104123003lank_e_r
lankier113711633lankie_r
lankinesses1539013lankinesses
lanner64920603lan_ne_r
largeness1038273largeness
largess8408913la_rgess
larkers113014513lark_ers
larkiest123713323larkiest
latkes104715873latk_e_s
laundress1042813laundress
lawines103313563lawine_s
lawless1037033la_wless
leafiness1236483leafiness
leakiness1337503leakiness
leakless12246983leakless
lensless835583lensless
lewdness1254173lewdness
likeness12229863likeness
liminess10510643liminess
limpness1246703limpness
lineless82711943lineless
linkers114317713link_ers
linnets739833lin_nets
lintless82710013lintless
lioness739103l_ioness
liteness82213213liteness
liveness112411393liveness
loaminess1137493loaminess
loathness1244703loathness
loginess9310163loginess
looniness9137573looniness
lornness836493lornness
lostness837683lostness
loudness937013loudness
lowness1037813l_owness
luckiness1596573luckiness
luckless14265893luckless
lunkers113414603lunk_ers
lushness1136233lushness
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
plainness1155183plainness
plankters1544583plankters
planless1036813plan_less
planners10399933plan_ners
pliantness1263643pliantness
puniness101610273puniness
punkiness15226983punkiness
raciness102413453raciness
raininess949283raininess
randiness102511443randiness
ranginess101610213ranginess
rankers113217463rank_ers
rankest112713813rank_est
rankles113114543rankle_s
ranknesses1438093ranknesses
raptness1046733raptness
rareness81112853rareness
rashness1138093rashness
rawness1038153ra_wness
sadness8310613sa_dness
safeness11239633safeness
sageness92111983sageness
saltness82610243saltness
sameness102712683sameness
sandiness102111713sandiness
sandless93212343sandless
scantness1135733scantness
sickness1437833sickness
slanginess1146273slanginess
slatiness92511363slatiness
sleekness1344543sleekness
slickness1535903slickness
slinkiness1445153slinkiness
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 8 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.423422437.4
2DLD Change Limit1461622667.28020077.2
3Display Results2662660.1102418.2
 (SQL Overall)1786912667.81322871.0
 
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.