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 “enchanted” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
enchanted154655(None) 
enchanter1446191enchanter
chanted134015952__chanted
enchained1545492enchained
enchant12313122enchant__
enchanters1545222enchanters
enchants1347832enchant_s
enchased1437382encha_sed
enhanced1436622en_hanced
exchanged23113672exchanged
incanted11259542inc_anted
merchanted1844482merchanted
unchanged1636282unchanged
uncharted1538082uncharted
unenchanted1752452unenchanted
bechanced1945643bechanced
canted94825783__c_anted
chanced154113213__chanced
changed144214143__changed
chanter123919733__chanter
chantey154112543__chantey
charted135116853__charted
chatted133411893__chatted
chaunted1485603__chaunted
decanted122310493dec_anted
descanted1336673desc_anted
disenchanted1952263disenchanted
echinated1546483e_chinated
enacted10310643en__acted
encaged113211083enc_a_ged
encamped1535023enc_amped
encased103512313enc_a_sed
encashed14246473enc_ashed
enceinte1046263enceinte_
enceintes1145673enceintes
enchanting1645943enchanting
enchantment1854303enchantment
enchantress1652023enchantress
enchase1239463encha_se_
enchaser1346693encha_ser
enchases13310273encha_ses
enclasped1454213enclasped
enclaved1456343encla_ved
encounter1145183encounter
encrusted12125003encrusted
encrypted1743183encrypted
encysted1444293enc_ysted
engrafted1443733engrafted
enhaloed12125933en_haloed
enhance1239693en_hance_
enhancer1346683en_hancer
enhances1339293en_hances
enplaned1137483enplan_ed
entranced1247393entranced
escheated1546273escheated
etchant1249823etchant__
etchants1346023etchant_s
exchange21124323exchange_
exchanger22123973exchanger
exchanges22124613exchanges
explanted1944973explanted
hanted104124313___hanted
incented112412543inc_ented
penchant1549583penchant__
penchants1646203penchant_s
recanted112513513rec_anted
rechanged1646853rechanged
recharted1557563recharted
scanted104114393_sc_anted
tenanted937043ten__anted
uncanned11289963unc_anned
uncarted11312053unc_arted
unchained1537273unchained
unchaired1536203unchaired
uncharged1636613uncharged
uncharred1536103uncharred
unchaste1346923unchaste_
unchaster1445393unchaster
uncoated11314963uncoa_ted
uncounted1238523uncounted
uncrated11416313uncra_ted
unhanded132910183un_handed
unhanged13258833un_hanged
unhatted1238183un_hatted
unplanted1236853unplanted
unthanked1764663unthanked
unwanted12249603un_wanted

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 Filter1786911486410.420425454.8
2DLD Change Limit148641876.95621368.7
3Display Results87870.0302900.0
 (SQL Overall)178691877.40624127.9
 
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.