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

128 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
enhanced143662(None) 
enhance1239691enhance_
enhancer1346681enhancer
enhances1339291enhances
bechanced1945642bechanced
chanced154113212_chanced
enchanted1546552enchanted
enfaced13218912enfa_ced
enhaloed12125932enhaloed
enhancers1445102enhancers
enlaced102410522enla_ced
enounced1135882enounced
entranced1247392entranced
nuanced1036202_nuanced
penanced1338162pen_anced
unhanded132910182unhanded
unhanged13258832unhanged
advanced1543313advanced
balanced1356513balanced
bechance1747733bechance_
bechances1847613bechances
bethanked1943283bethanked
chance134617093_chance_
chancel144011773_chancel
chancer144215633_chancer
chances145218093_chances
changed144214143_changed
chanted134015953_chanted
danced105315253__danced
denounced1344033denounced
effaced16225573effa_ced
embanked17253883embanked
enabled102510633en_abled
enacted10310643en_acted
encaged113211083enca_ged
encamped1535023encamped
encased103512313enca_sed
encashed14246473encashed
enchained1545493enchained
enchanter1446193enchanter
enchased1437383encha_sed
endanger1045853endanger
enface112510353enfa_ce_
enfaces122110913enfa_ces
enforced14216743enforced
engaged10379833enga_ged
engined9119893engin_ed
enhaloes1197343enhaloes
enhancing1545823enhancing
enhancive1752693enhancive
enjambed2042823enjambed
enlace82213233enla_ce_
enlaces92313393enla_ces
enlarged1035413enlarged
enounce937573enounce_
enounces1037603enounces
enplaned1137473enplan_ed
enraged93511783enra_ged
ensconced1443343ensconced
ensnared965293ensnared
entailed989523entailed
entangled1184503entangled
enticed101411193en_ticed
entrance10311323entrance_
entrances11310953entrances
ethane94613243ethan_e_
ethanes103713513ethan_es
evenhanded1851873evenhanded
evinced1335403e_vinced
exchanged23113673exchanged
exhaled1835283exha_led
expanded19145163expanded
financed1435113financed
glanced11439233_glanced
hance105424153__hance_
hances115621283__hances
handed114919983__handed
hanged114222393__hanged
hanked144220603__hanked
hanted104124313__hanted
incanted11259543incanted
inhaled1169333inha_led
inlaced10239873inla_ced
instanced1245693instanced
lanced93717723__lanced
menaced122710093men_a_ced
nance74721843_n_ance_
nances83618643_n_ances
nuance859043_nuance_
nuances938523_nuances
openhanded1752243openhanded
penance11313443pen_ance_
penances12312443pen_ances
pranced123714043_pranced
rechanged1646853rechanged
rehanged1357833rehanged
renounced1245923renounced
romanced1337253romanced
sentenced1256683sentenced
shanked153212123_shanked
tenanted937043ten_anted
tendance1147523tendance_
tendances1247573tendances
thanked15469153_thanked
tranced104414173_tranced
unbanded123010563unbanded
unbanned11279113unbanned
uncanned11289963uncanned
unchanged1636283unchanged
unfenced1437733unfenced
unhailed12219963unhailed
unhaired12238763unhaired
unhalved1556513unhalved
unhand10410383unhan__d
unhandled1445703unhandled
unharmed1438093unharmed
unhatched1844133unhatched
unhatted1238183unhatted
unhinged13257473unhinged
unlaced102913733unla_ced
unmanned11268603unmanned
unnuanced1243413unnuanced
unranked1338563unranked
untanned9279963untanned
unthanked1764663unthanked
unwanted12249603unwanted
valanced1475463valanced
whanged15447613_whanged

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.1731032896.0
2DLD Change Limit1461621287.25020160.3
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.46923924.4
 
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.