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

142 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
hardening143802(None) 
gardening1236511gardening
hardenings1544241hardenings
harkening1746921harkening
burdening1335542burdening
careening12310012careening
darkening1535682darkening
happening1735592happening
harshening1744172harshening
hastening13259482hastening
havening15258552ha_vening
hearkening1844532hearkening
heartening1446732heartening
hoarsening1444402hoarsening
hoidening1435632hoidening
hoydening1744352hoydening
ladening1078822la_dening
maddening1445112maddening
pardoning1338762pardoning
rehardening1644142rehardening
saddening1245212saddening
sardining1137572sardining
sharpening1644882sharpening
adenine8311213_a_denine
aliening91510893_aliening
barbering14229683barbering
barding113822893bard__ing
barning104320353bar__ning
barreling1238043barreling
bartending1444913bartending
bartering122313643bartering
battening12268853battening
bordering1338833bordering
brazening2185183brazening
cadencing1544963ca_dencing
carding113922443card__ing
careering12311203careering
carpeting1439483carpeting
cartoning12311113cartoning
chartering16109253chartering
chastening1656523chastening
coarsening1345543coarsening
cordoning1338063cordoning
cravening1547553cravening
dampening1535463dampening
dandering122511063dandering
darning93817333dar__ning
davening13258873da_vening
deadening1277583deadening
earning83418213ear__ning
farding123716743fard__ing
farseeing1344383farseeing
fastening13268603fastening
fattening13287833fattening
gandering122111293gandering
gardenia1045383gardeni_a
gardenias1145403gardenias
garmenting1445483garmenting
garnering11298083garnering
gartering112111573gartering
gladdening1442693gladdening
greening103112533_greening
hading113922943ha_d__ing
haeing104118923ha__e_ing
haltering132212003haltering
hamboning1745893hamboning
hammering1737633hammering
hampering1738863hampering
handing123518893hand__ing
handling132312713hand_ling
handseling1544323handseling
hankering17239383hankering
hanseling1338063hanseling
happenings1842623happenings
harassing1346983harassing
harboring1538263harboring
harden105718533harde__n_
hardened1338613harden_ed
hardener1238883harden_er
hardeners1338083hardeners
hardens113815023harde__ns
hardline12310273hard_line
hardwiring1842223hardwiring
haring104233003har___ing
harking154120943har__king
harming133717933har__ming
harnessing1443903harnessing
harping134118383har__ping
harpooning1644483harpooning
harrowing1646433harrowing
harrying15157643har_rying
harvesting1744413harvesting
havering152211053ha_vering
herding122915123herd__ing
hindering14310273hindering
hireling121210993hir_eling
hirseling1396273hirseling
hoarding13288643hoard__ing
hordein1138753horde_in_
hordeins1238323horde_ins
hording123517053hord__ing
horning113015003hor__ning
hurdling13288013hurd_ling
hyphening2144143hyphening
jargoning1845983jargoning
laddering1237593laddering
larding92917873lard__ing
latening9711493la_tening
leadening1176733leadening
loudening1144743loudening
margenting1446153margenting
margining1337603margining
marketing1636513marketing
marooning1238593marooning
marveling1537103marveling
mildening1345673mildening
murdering1357133murdering
ordering1039353_ordering
pandering133211963pandering
parceling1438443parceling
parenting12611583par_enting
pargeting1338283pargeting
parleying1536113parleying
preening113115843_preening
prehardening1952583prehardening
rattening10288763rattening
ravening122611293ra_vening
reddening1237433reddening
screening1247193screening
shortening1445303shortening
smartening1344993smartening
soddening1244543soddening
targeting1137303targeting
tautening1035843tautening
wakening1636323wa_kening
wandering143310983wandering
warding123918143ward__ing
warning113717093war__ning
widening13237833_widening
worsening1345553worsening
yarding123413143yard__ing
yarning113512953yar__ning

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411427.65619415.0
3Display Results1421420.0632254.0
 (SQL Overall)1786911428.15521911.8
 
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.