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

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

75 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
disenchanters196168(None) 
disenchanter1861941disenchanter_
disenchanted1952262disenchante_d
disenchants1753192disenchant__s
disenchant1664623disenchant___
disenchanting20102383disenchanting
disenchantment2292143disenchantment
disenchantments2391973disenchantments
enchanters1545223___enchanters
decanters12229224d__e_c_anters
descanters1345014d__esc_anters
desecraters1444814dese_cra_ters
dischargers1873064dis__chargers
discounters1445754dis__counters
disencumbers1961464disenc_umbers
enchanter1446194___enchanter_
mishanters1544984mis___hanters
chanters134016745_____chanters
covenanters1682965coven__anters
decanter112510795d__e_c_anter_
decenters122410375d__e_c_enters
descanter1246445d__esc_anter_
desecrater1346985dese_cra_ter_
desecrates1348845dese_cra_te_s
desecrators1445235dese_cra_tors
dilettantes1252205dile_ttante_s
disasters1039155dis____asters
discanted1339335dis__c_ante_d
discants112912025dis__c_ant__s
discarders1445045dis__c_arders
discerners1345705dis__cern_ers
dischargees1873225dis__chargees
discharger1763895dis__charger_
discharges1765445dis__charge_s
disclaimers1653135dis__claimers
discounter1347025dis__counter_
disenables1346235disen__able_s
disenchantingly2581155disenchantingly
disencumber1851875disenc_umber_
disendowers1652575disen__dowers
disengages1344355disen_ga_ge_s
disentangles1452705disen_tangles
dishwaters1744025dis___hwaters
disinclines1454705disinclin_e_s
disinters1039715dis____inters
dislocates13108325disloc_a_te_s
dissenters1197725dis___senters
dissipaters1453475dis_sipa_ters
dissociates1455785dissocia_te_s
disuniters11104735disun___iters
drenchers15296105d_rench___ers
enchanted1546555___enchante_d
enchantress1652025___enchantress
enchants1347835___enchant__s
enchasers1445095___encha_sers
encounters1244555___encounters
enhancers1445105___en_hancers
exchangers23103205___exchangers
incenters112510305_i__nc_enters
interchangers1972645interchangers
linecasters13102595line_c_asters
mischances1946375mis__chance_s
mischannels1852195mis__channels
misenters1139535mise____nters
mishanter1446455mis___hanter_
penchants1646205__penchant__s
recanters112310485__re_c_anters
recharters1555425__re_charters
reencounters1451725_reencounters
rencounters1343305__rencounters
subchapters2052045__subchapters
trochanters1653435__trochanters
unenchanted1752455_unenchante_d
wisecrackers2351855wise_crackers
wisenheimers2061035wisen_heimers

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 Filter1786911247900.390458182.1
2DLD Change Limit124790759.48613155.2
3Display Results75750.0302500.0
 (SQL Overall)178691759.90618038.7
 
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.