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

340 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
hardness12241108(None) 
hardiness132310361hardiness
harness102413931har_ness
aridness939222_aridness
badness1039572ba_dness
baldness1137042baldness
bareness10912812bareness
baroness101210062baroness
chariness14310062chariness
darkness13247342darkness
farness102912202far_ness
hairiness1238012hairiness
haleness11312622haleness
halfness1435562halfness
handiness132110932handiness
handless123512062handless
hardass1139752hard_ass
hardeners1338082hardeners
hardens113815022hard_ens
hardest113118412hard_est
hardies114923232hardie_s
hardiest123416342hardiest
hardnesses141810542hardnesses
hardnose1245722hardnose
hardnoses1346232hardnoses
harmless1337402harmless
harshness1545962harshness
haziness20248512haziness
hoariness1238822hoariness
madness10310072ma_dness
pardners11269192pardners
rareness81112852rareness
sadness8310612sa_dness
sharpness1434942sharpness
tardiness10229922tardiness
tartness82210132tartness
wardless12249302wardless
wardress12256162wardress
wariness11313212wariness
warmness1337062warmness
acidness1136723acidness
acridness1245073acridness
address956103_address
agedness1036683agedness
aidless83612073_aidless
airiness8412213airiness
apartness1146053apartness
aptness9268573_aptness
archness1337513_archness
ardebs937013_ard_ebs
arenes64928393_arene_s
armless9369943_armless
artiness81615403_artiness
artless73712513_artless
avidness1246113avidness
awareness1236343awareness
bandiness122310243bandiness
barbless12318713barbless
bardes95026933bard_e_s
barkless14318023barkless
barless94317003bar_less
barneys12569563bar_neys
baronets101410903baronets
baseness10910943baseness
bassness1096743bassness
bawdiness15235543bawdiness
beardless1234913beardless
blandness1235973blandness
boldness1136973boldness
caginess11310303caginess
cakiness1449553cakiness
calmness1236643calmness
canoness1039393canoness
carders104820353card_ers
careless102813633careless
caress85720263car__ess
carless95118493car_less
carnets93918403car_nets
carneys124310543car_neys
chadless1436403cha_dless
charmless1633583charmless
charnels13328173char_nels
chartless1435703chartless
coldness1137953coldness
cordless11299963cordless
curtness1037263curtness
daftness1235533daftness
dampness1336073dampness
dankness13256693dankness
darndest1067223darndest
darndests1183143darndests
darnels83710433dar_nels
darners83815773dar_ners
datedness1187753datedness
dazedness20114963dazedness
deadness1039233deadness
dearness939973dear_ness
direness9311303direness
drabness1135803drabness
dryness11114783_dryness
dwarfness1642793dwarfness
earless74316073ear_less
earliness939693earliness
earners74016453ear_ners
earnest7318733ear_nest
earnests837853ear_nests
easiness8313043easiness
eeriness8311873eeriness
eyedness1245103eyedness
fadedness1445613fadedness
fairness1136563fairness
fardels11389893fard_els
fastness11238763fastness
fatness103311293fa_tness
firmness1334743firmness
fondness1237213fondness
fordless12289003fordless
gameness112810693gameness
gaminess112911063gaminess
garbless11388253garbless
gardeners1136603gardeners
gardens93312093gard_ens
garners83815983gar_ners
garnets84115403gar_nets
gastness9278473gastness
gaudiness1136253gaudiness
gayness1136843ga_yness
gladness1036153gladness
glariness1038553glariness
goodness1036253goodness
goriness9310753goriness
grandness1138303grandness
grayness1235933grayness
hackneys2033683hackneys
haddest122711993ha_ddest
hades96035113ha_d_e_s
hadjees18356383ha_djees
hadjes175210403ha_dje_s
haggardness1752333haggardness
hairless1157413hairless
hairnets1195633hairnets
haltless11308443haltless
hamminess1635713hamminess
handedness1545903handedness
handers114224333hand_ers
handiest123417783handiest
handlers124014143handlers
handles114020653handle_s
handpress1544033handpress
handsels12317253handsels
handsets12258343handsets
hangnest12311413hangnest
hangnests1344543hangnests
hanses95022633ha__nses
hapless123311333ha_pless
happiness1636003happiness
harass9313943har__ass
harasses11311033harasses
hardasses1346453hardasses
hardcase1445623hardcase
harden105718533hard_e_n
hardened1338613hardened
hardener1238883hardener
harder105022403hard_e_r
hardhats1546833hardhats
hardhead1645883hardhead
hardheads1745773hardheads
hardier114721543hardie_r
hardinesses151110223hardinesses
hardpans1436453hardpans
hards96435653hard___s
hardset113415833hardse_t
hardtops1444843hardtops
hareems12428203har_eems
harems115513823har__ems
hares86255543har__e_s
harkeners1636073harkeners
harkens144112863har_kens
harmers124116593har_mers
harmines132715143harmine_s
harnessed13186193har_nessed
harnesses121812073har_nesses
harpers124916203har_pers
harpies123818323harpie_s
harriers113712433harriers
harries103525493harrie_s
harshens1437603harshens
harshest14310193harshest
harslets1137833harslets
harvest132112753har_vest
harvests14246173har_vests
hastiness122410883hastiness
hatless103813443ha_tless
headdress1443753headdress
headiness132510363headiness
headless12289863headless
heartiness1338033heartiness
heartless1236393heartless
heaviness15207063heaviness
heedless12278813heedless
herbless1336663herbless
herders113914123herd_ers
highness1536053highness
hipness12277383h_ipness
hoarders12307433hoard_ers
hoarseness1345313hoarseness
hokiness152510183hokiness
holiness112512503holiness
hominess132712463hominess
hoodless12289733hoodless
hordes104921633hord_e_s
hornedness1445403hornedness
hornets104113553hor_nets
horniness12309143horniness
hornless1137363hornless
horridness1443843horridness
horsiness12259473horsiness
hotness1038613h_otness
hugeness1237373hugeness
humidness1544023humidness
hurdies114015663hurdie_s
hurdlers12337493hurdlers
hurdles113613373hurdle_s
hurtless11307783hurtless
inwardness1443773inwardness
jadedness1844693jadedness
kindness13236653kindness
laciness102112553laciness
lameness102612673lameness
landless94011173landless
lankness12237043lankness
larders83516943lard_ers
lardiest93813893lardiest
largeness1038273largeness
largess8408913lar_gess
larkiness1338113larkiness
lateness82614073lateness
laxness1436043la_xness
laziness17239983laziness
lewdness1254173lewdness
lordless9277483lordless
lornness836493lornness
loudness937013loudness
luridness1045193luridness
maleness10312313maleness
mariners103113863mariners
marines93928013marine_s
markedness1744023markedness
marquess19204953marquess
matiness102114753matiness
mazedness2194573mazedness
maziness19239543maziness
mildness1136523mildness
miriness10310463miriness
moreness10911573moreness
nakedness1445043nakedness
nearness838313near_ness
nerdiness10208333nerdiness
oarless73913373oar_less
oddness935313_oddness
oldness836403_oldness
packness1636933packness
paleness10312983paleness
pardner10239473pardne_r
pardoners12208213pardoners
partners102711133partners
pastness102510503pastness
patness92912283pa_tness
patroness1137483patroness
peartness1137773peartness
pertness10310093pertness
pureness101110183pureness
rabidness12145263rabidness
raciness102413453raciness
randiness102511443randiness
rankness12267943rankness
rapidness12155473rapidness
raptness1046733raptness
rashness1138093rashness
rawness1038153ra_wness
redness82012443_redness
sacredness1344543sacredness
safeness11239633safeness
sageness92111983sageness
saltness82610243saltness
sameness102712683sameness
sandiness102111713sandiness
sandless93212343sandless
saneness82313723saneness
sardines92815573sardine_s
sarsnets836783sarsnets
scariness11310183scariness
shadiness1337463shadiness
shakiness1637083shakiness
shortness1236733shortness
smartness1136143smartness
soreness8914793soreness
spareness1139863spareness
spryness1334003spryness
staidness1037033staidness
starkness1335963starkness
sureness8912903sureness
swartness1236113swartness
tallness837103tallness
tameness102411253tameness
tardies84225863tardie_s
tardiest93515243tardiest
tarriness9229243tarriness
tartiness92112053tartiness
tautness8217183tautness
teariness9310633teariness
tiredness1036933tiredness
unharness1245253unhar_ness
upwardness1642653upwardness
vainness1136063vainness
validness13125363validness
vapidness15144423vapidness
vastness11257293vastness
voidness1235553voidness
waeness102512783wa_eness
wanness102610683wa_nness
wardens113711903ward_ens
warders113416813ward_ers
warless104015103war_less
warners103315563war_ners
wartless11279923wartless
waviness1437723waviness
waxiness1836723waxiness
weariness1238843weariness
weirdness1343593weirdness
whatness1435093wha_tness
wildness1236203wildness
wiriness1138953wiriness
wordiness13138633wordiness
wordless12258843wordless
wornness1136363wornness
wryness13113983_wryness
yarders113211593yard_ers
yarners104312203yar_ners
zaniness1738663zaniness

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623407.83018666.9
3Display Results3403400.1402428.6
 (SQL Overall)1786913408.39321290.5
 
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.