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

194 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
hardened133861(None) 
gardened1137001gardened
hardener1238881hardener
harkened1637481harkened
burdened1236422burdened
careened1139192careened
darkened1435942darkened
gardener1037102gardener
happened1635652happened
harden105718532harden__
hardeners1338082hardeners
hardens113815022harden_s
harkener1537572harkener
harshened1644452harshened
hastened12239102hastened
havened14429242ha_vened
hearkened1744452hearkened
heartened1347062heartened
hoarsened1344052hoarsened
hoidened1335652hoidened
hoydened1644642hoydened
ladened979052la_dened
maddened1334892maddened
pardoned12189332pardoned
rehardened1543942rehardened
saddened1135342saddened
sardined10268662sardined
sharpened1544482sharpened
addend9458453_adden_d
aliened81011743_aliened
ardency1346483_ardency
ardent73022613_arden_t
arene55329413_ar_ene_
arenes64928393_ar_enes
barbered13259543barbered
barded105426423bard__ed
barned95623583bar__ned
barreled1137843barreled
barrener1038333barrener
bartend1038753barten_d
bartended1344663bartended
bartered113113013bartered
battened11259573battened
bordered1248933bordered
brazened20134903brazened
burdener1136143burdener
cadenced1435523ca_denced
carded105424903card__ed
careener1039333careener
careered1139493careered
carpeted1338953carpeted
cartoned111312833cartoned
chartered15158393chartered
chastened1545883chastened
coarsened1245143coarsened
cordoned12229613cordoned
cravened1476723cravened
dampened1435623dampened
dandered112110963dandered
darkener1335993darkener
darned85018483dar__ned
davened124610073da_vened
deadened1137233deadened
earned74818333ear__ned
farded114518953fard__ed
fastened12257853fastened
fattened12268283fattened
gandered112211173gandered
garden84215083garden__
gardeners1136603gardeners
gardenia1045383gardenia
gardens93312093garden_s
garmented1345883garmented
garnered10247113garnered
garreted1057523garreted
gartered10319593gartered
gladdened1342583gladdened
greened93111263_greened
haded105227623ha_d__ed
haltered123112563haltered
hamboned1637003hamboned
hammered16218853hammered
hampered16239933hampered
handed114919983hand__ed
handled124114533hand_led
handseled1444403handseled
hankered16289443hankered
hanseled1237713hanseled
haptene123810933haptene_
haptenes133810823haptenes
harassed1237113harassed
harbored1438633harbored
hardedge1442923hardedge
hardedges1543633hardedges
hardening1438023hardening
harder105022403hard__er
hardest113118413harde_st
hardhanded1953113hardhanded
hardhead1645883hardhead
hardheaded1953853hardheaded
hardier114721543hard_ier
hardies114923233hard_ies
hardiness132310363hardiness
hardline12310273hardline_
hardness122411083hardness
hardset113415833hard_set
hardwired1742873hardwired
hardwood16155743hardwood
hared95742183har___ed
hareem114312063har_e_em
harked145422553har__ked
harken135116343harken__
harkeners1636073harkeners
harkens144112863harken_s
harmed125218833har__med
harmine122816193harmine_
harmines132715143harmines
harnessed13186193harnessed
harped124418403har__ped
harpooned1544323harpooned
harried113815533har_ried
harrowed1556263harrowed
harvested1644093harvested
hastener11259133hastener
havered144011453ha_vered
hawkeyed2242403hawkeyed
hayseed1435633hayse_ed
headend12398363headen_d
hearkener1644213hearkener
heartener1256763heartener
herded114215643herd__ed
hindered1339453hindered
hirseled12106253hirseled
hoarded12368343hoard__ed
horded115420483hord__ed
horned105718703hor__ned
hurdled12379833hurd_led
hyphened2044693hyphened
jargoned1735233jargoned
laddered1136743laddered
larcener1036493larcener
larded84319093lard__ed
latened8711923la_tened
leadened1036153leadened
loudened1044693loudened
margented1346813margented
margined1237743margined
marketed1537323marketed
marooned1138563marooned
marveled1436433marveled
mildened1235773mildened
murdered1236023murdered
nardine82712573nardine_
ordered9108533_ordered
pandered121812573pandered
parceled1338343parceled
parcener1238473parcener
pardee93922023parde_e_
pardine103616723pardine_
pardner10239473pard_ner
pardoner11189443pardoner
parented11912213par_ented
pargeted1238683pargeted
parleyed1436243parleyed
pattened11299393pattened
preened103214993_preened
prehardened1852413prehardened
rattened9218623rattened
ravened115012283ra_vened
reddened1136423reddened
sarcenet10413313sarcenet
sardine83317393sardine_
sardines92815573sardines
sarsenet8412943sarsenet
screened1137413screened
sharpener1444583sharpener
shortened1345663shortened
smartened1244263smartened
soddened1144643soddened
targeted1037483targeted
tarweed1137343tarwe_ed
tautened935423tautened
wakened1546873wa_kened
wandered132110793wandered
warded115021043ward__ed
warden104515513warden__
wardenry1542973wardenry
wardens113711903warden_s
warned104018913war__ned
warrener1136913warrener
widened12328053_widened
worsened1236053worsened
yarded114714023yard__ed
yarned105514023yar__ned

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.626285448.9
2DLD Change Limit1461621947.84318636.0
3Display Results1941940.0802425.0
 (SQL Overall)1786911948.54920902.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.