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

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

70 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
sacramentalisms217333(None) 
sacramentalism2073691sacramentalism_
sacramentalists1973281sacramentalists
sacramentalist1873832sacramentalis_t
incrementalisms21173683incrementalisms
sacramentals1653443sacramental___s
fundamentalisms23122654fundamentalisms
incrementalism20154364incrementalism_
incrementalists19163634incrementalists
sacramental1553524sacramental____
sacramentally2062744sacramental__ly
sentimentalisms19134574sentimentalisms
bicameralisms2162465bic_ame_ralisms
commensalisms1873755__commensalisms
credentialisms1963175__credentialisms
documentalists19153955doc_umentalists
fundamentalism22112925fundamentalism_
fundamentalists21122615fundamentalists
incrementalist18164525incrementalis_t
mentalisms1449315_____mentalisms
orientalisms14105905__or_ientalisms
sacerdotalisms1961805sac_erdotalisms
sacraments1445855sacrament_____s
sentimentalises17154355sentimentalises
sentimentalism18145115sentimentalism_
sentimentalists17144635sentimentalists
ultramontanisms19202435ultramontanisms
acromegalics1962056_acrome_gali_cs
acromegalies1762526_acrome_gali_es
armamentarium1671766_armamentarium_
bicameralism2062636bic_ame_ralism_
bidialectalisms22161396bidialectalisms
capitalisms1765506__c_a_pitalisms
caramelises1554616ca_rame___lises
centralisms1547406__c___entralisms
ceremonialisms20103206_ceremonialisms
commensalism1764956__commensalism_
communalisms17144186__commun_alisms
credentialism1863826__credentialism_
documentalist18144896doc_umentalis_t
documentarists19113126doc_umentarists
ecumenicalisms22101926_ec_umenicalisms
experimentalism2893266experimentalism_
factionalisms20106366fac_tion_alisms
fraternalisms1863796__fraternalisms
fundamentalist20132966fundamentalis_t
governmentalism2382996governmentalism_
instrumentalism19143396instrumentalism_
mentalism13511646_____mentalism_
mentalists12410486_____mentalists
mercantilisms1962536merca__ntilisms
orientalism13126496__or_ientalism_
orientalists12125776__or_ientalists
phenomenalisms2362946phenomen_alisms
sacerdotalism1861846sac_erdotalism_
sacerdotalists1771806sac_erdotalists
sacrament1347946sacrament______
scandalises1444806s_c_a__ndalises
scapegoatisms2061076s_c_apegoatisms
scientisms1444556s_c__ient__isms
sectionalisms1756526sec_tion_alisms
sentimentalise16164796sentimentalis_e
sentimentalised18153436sentimentalised
sentimentalist16155456sentimentalis_t
sentimentalizes26173776sentimentalizes
surrealisms1353566s_ur_re__alisms
symmetallisms1961556s__ymme_tallisms
tarantisms1245546ta_ra__nt__isms
ultramontanism18182916ultramontanism_
ultrarealisms15123886ultrare__alisms

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 Filter178691950240.360496363.9
2DLD Change Limit95024708.18611608.1
3Display Results70700.0501400.0
 (SQL Overall)178691708.59620787.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.