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

60 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
enchanting164594(None) 
chanting143413532__chanting
enchaining1644942enchaining
enchantingly2182032enchantingly
enchasing1567732encha_sing
enhancing1545822en_hancing
exchanging2443092exchanging
incanting1289902inc_anting
merchanting1944312merchanting
unchanging1745222unchanging
bechancing2044443bechancing
canting104725903__c_anting
chancing162810283__chancing
changing153211513__changing
charting142614193__charting
chatting142810143__chatting
chaunting1555413__chaunting
decanting132510633dec_anting
descanting1446923desc_anting
disenchanting20102383disenchanting
enacting11311363en__acting
encaging1258733enc_a_ging
encamping1645233enc_amping
encashing1536443enc_ashing
encasing11610823enc_a_sing
enchain1248853encha__in_
enchains1348523encha__ins
enchant12313113enchant___
enchanted1546553enchant_ed
enchanter1446193enchant_er
enchanters1545223enchanters
enchantment1854303enchantment
enchants1347823enchant__s
enclasping1544103enclasping
enclaving1546313encla_ving
encrusting13125293encrusting
encrypting1843053encrypting
encysting1544613enc_ysting
engrafting1544183engrafting
enhaloing1345363en_haloing
enplaning1246803enplan_ing
entrancing1346783entrancing
escheating1645883escheating
explanting2045223explanting
hanting114124483___hanting
incenting12912063inc_enting
recanting122414823rec_anting
rechanging1746043rechanging
recharting1637213recharting
scanting113914763_sc_anting
tenanting1036213ten__anting
unchaining1645693unchaining
unchairing1644603unchairing
uncharging1744393uncharging
uncharming1844523uncharming
uncoating12611923uncoa_ting
uncrating12813183uncra_ting
unhanding1437203un_handing
unhanging1436363un_hanging
unhatting1335873un_hatting

Search took 7 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 Filter1786911406030.1561145455.1
2DLD Change Limit140603606.59621316.4
3Display Results60600.0302000.0
 (SQL Overall)178691606.78226347.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.