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

84 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
enchantresses1810132(None) 
enchantress1652022enchantre_s_s
ancestresses1493274anc_estresses
anchoresses1653804anch__oresses
ancientnesses1553284ancientnesses
benefactresses216824benefactresses
chanteuses1543804__chant_euses
chartreuses1652214__chartreuses
enchanters1545224enchant_e__rs
enchantments1953404enchantme_nts
huntresses1345284___huntresses
instantnesses1354064instantnesses
inventresses1553024in_ventresses
scantnesses1376534_sc_antnesses
unchastenesses1962924unchastenesses
vacantnesses1742974vac_antnesses
achinesses1539305_achin__esses
actresses1137935____actresses
ancresses1138415____ancresses
archnesses1547175arch_n__esses
aviatresses1483005_avia_tresses
canonesses1238425__c_anonesses
caresses10314065__c_a__resses
cateresses1248355__c_ateresses
chancinesses1945035__chancinesses
chanterelles1751905__chanterelles
chanteuse1443475__chant_euse_
chantries14310295__chantr__ies
charinesses1639565__charinesses
chartreuse1551945__chartreuse_
chastenesses1746315__chastenesses
chattinesses1755155__chattinesses
coatdresses1443945__coatdresses
congresses1348025__c_ongresses
countesses1248845__count_esses
distantnesses1453835distantnesses
editresses1165075e___ditresses
electresses1345975e__lectresses
enchanted1546555enchant____ed
enchanter1446195enchant____er
enchantment1854305enchantme__nt
enchants1347835enchant_____s
enchases13310275encha_____ses
eucharises1545445eucha__r_ises
exactnesses2044345e__xactnesses
giantesses1143515__giant_esses
handpresses1753655___handpresses
ignorantnesses1562215ignorantnesses
inanenesses1149525in__anenesses
inaptnesses1385635in__aptnesses
incandesces1652575inc_an_desces
inchoatenesses1953595inchoatenesses
inexactnesses2252915inexactnesses
inheritresses16102105inheritresses
insanenesses1246875in_sanenesses
intactnesses1444575in_tactnesses
intentnesses1277125in_tentnesses
itchinesses1644615itchin__esses
jointresses1843475__jointresses
mattresses1245435___mattresses
muchnesses1744715much_n__esses
neatnesses10310015_n_ea_tnesses
oratresses1045495__ora_tresses
pantdresses1443755___pantdresses
piquantnesses2452035piquantnesses
pliantnesses1444455_pliantnesses
recentnesses1465375rec_entnesses
richnesses1537805rich_n__esses
scantinesses1437315_sc_antinesses
sculptresses1661405_sculptresses
suchnesses1536675such_n__esses
tetchinesses1753555tetchin__esses
traitresses1144605__traitresses
unaptnesses1395525un__aptnesses
uncanninesses1553135uncanninesses
unchasteness1773285unchast_eness
uncleannesses1553045unclean_nesses
unhandinesses1753715un_handinesses
unharnesses1445435un_ha_rnesses
unstresses1046035un___stresses
valiantnesses1652725valiantnesses
victresses1544975vic___tresses
waitresses1345065___waitresses
whatnesses1635735__wha_tnesses

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 Filter1786911247900.393454684.5
2DLD Change Limit124790847.85615884.7
3Display Results84840.0461826.1
 (SQL Overall)178691848.29521542.0
 
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.