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

184 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
harkened163748(None) 
darkened1435941darkened
hardened1338611hardened
harkener1537571harkener
hearkened1744461hearkened
careened1139192careened
darkener1335992darkener
gardened1137002gardened
hankered16289442hankered
happened1635652happened
hardener1238882hardener
harked145422552hark__ed
harken135116342harken__
harkeners1636082harkeners
harkens144112862harken_s
harshened1644452harshened
hastened12239102hastened
havened14429242ha_vened
hawkeyed2242402hawkeyed
hearkener1644222hearkener
heartened1347082heartened
hoarsened1344052hoarsened
marketed1537322marketed
sharpened1544482sharpened
wakened1546872wa_kened
akene95818663_a_kene_
akenes104817343_a_kenes
aliened81011743_aliened
alkene104114003_alkene_
alkenes114212753_alkenes
arene55329413_ar_ene_
arenes64928393_ar_enes
awakened1653473awakened
barbered13259553barbered
barked135027313bark__ed
barkeep1536363barke_ep
barned95623583bar__ned
barreled1137853barreled
barrener1038343barrener
bartend1038753barten_d
bartended1344673bartended
bartered113113033bartered
battened11259573battened
bedarkened1842223bedarkened
blackened1845273blackened
brazened20134903brazened
burdened1236423burdened
cankered153010223cankered
careener1039333careener
careered1139503careered
carked134024823cark__ed
carpeted1338963carpeted
cartoned111312833cartoned
casketed1534953casketed
charked174814013chark__ed
chartered15158403chartered
chastened1545883chastened
chickened2144623chickened
coarsened1245143coarsened
cravened1476723cravened
dackered16116893dackered
daikered1495223daikered
dampened1435623dampened
darked123919633dark__ed
darken114013443darken__
darkeners1435163darkeners
darkens12409873darken_s
darkled13378723dark_led
darned85018483dar__ned
davened124610073da_vened
earned74818333ear__ned
fastened12257853fastened
fattened12268283fattened
gardener1037113gardener
garmented1345893garmented
garnered10247123garnered
garreted1057523garreted
gartered10319603gartered
greened93111263_greened
hacked164923513hack__ed
hackee154921833hacke_e_
hackees165014103hacke_es
hackled173312493hack_led
hackney1935123hack_ney
hackneyed2242243hackneyed
hakeem15407383ha_ke_em
haltered123112573haltered
hamboned1637003hamboned
hammered16218853hammered
hampered16239933hampered
hanked144220603hank__ed
hankerer15248233hankerer
hanseled1237713hanseled
haptene123810933haptene_
haptenes133810823haptenes
harassed1237113harassed
harbored1438643harbored
harden105718533harden__
hardeners1338093hardeners
hardens113815023harden_s
hared95742183har___ed
hareem114312063har_e_em
harkening1746923harkening
harking154120943harkin_g
harmed125218843har__med
harmine122816203harmine_
harmines132715163harmines
harnessed13186203harnessed
harped124418403har__ped
harpooned1544323harpooned
harried113815543har_ried
harrowed1556283harrowed
harvested1644103harvested
hastener11259143hastener
havered144011453ha_vered
hawked174712673hawk__ed
hawkweed2242203hawkweed
hayseed1435633hayse_ed
hearken14338033hearken__
hearkeners1743983hearkeners
hearkens15336693hearken_s
heartener1256773heartener
hirseled12106253hirseled
hoidened1335653hoidened
horned105718703hor__ned
hoydened1644643hoydened
hunkered16186923hunkered
hyphened2044693hyphened
jacketed22146543jacketed
jargoned1735233jargoned
lackered15108683lackered
lackeyed18104513lackeyed
ladened979053la_dened
lakebed1434783la_kebed
larcener1036493larcener
larked114519473lark__ed
latened8711923la_tened
likened12267353_likened
maddened1334893maddened
margented1346813margented
margined1237763margined
marked133921623mark__ed
marketer1437383marketer
marooned1138573marooned
marveled1436433marveled
narked114116743nark__ed
packeted17148293packeted
parceled1338343parceled
parcener1238473parcener
pardoned12189333pardoned
parented11912213par_ented
pargeted1238683pargeted
parked134425143park__ed
parleyed1436243parleyed
pattened11299393pattened
pinkened1535753pinkened
preened103214993_preened
racketed15169133racketed
rattened9218633rattened
ravened115012283ra_vened
rehardened1543943rehardened
saddened1135343saddened
sarcenet10413313sarcenet
sardined10268673sardined
sarsenet8412943sarsenet
screened1137413screened
sharked153613913shark__ed
sharpener1444583sharpener
shortened1345663shortened
sickened1546783sickened
slackened1644243slackened
smartened1244273smartened
targeted1037483targeted
tarweed1137343tarwe_ed
tautened935423tautened
thickened1944303thickened
tokened1236393_tokened
wakener1446913wa_kener
warked144421213wark__ed
warned104018913war__ned
warrener1136923warrener
weakened1634823weakened
worsened1236053worsened
yarned105514023yar__ned

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.423422437.4
2DLD Change Limit1461621848.68616827.3
3Display Results1841840.0762421.1
 (SQL Overall)1786911849.18519454.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.