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

63 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
sacramentalists197328(None) 
sacramentalisms2173321sacramentalisms
sacramentalist1873831sacramentalist_
sacramentalism2073692sacramentalis_m
incrementalists19163633incrementalists
sacramentals1653443sacramental___s
documentalists19153944doc_umentalists
fundamentalists21122614fundamentalists
incrementalisms21173674incrementalisms
incrementalist18164524incrementalist_
sacramental1553524sacramental____
sacramentally2062744sacramental__ly
sentimentalists17144624sentimentalists
documentalist18144895doc_umentalist_
documentarists19113125doc_umentarists
fundamentalisms23122645fundamentalisms
fundamentalist20132965fundamentalist_
incrementalism20154365incrementalis_m
mentalists12410475_____mentalists
orientalists12125755__or_ientalists
sacerdotalists1771805sac_erdotalists
sacraments1445855sacramen_____ts
sentimentalises17154345sentimentalises
sentimentalisms19134565sentimentalisms
sentimentalist16155455sentimentalist_
acromegalics1962036_acrome_gali_cs
acromegalies1762496_acrome_gali_es
bicameralisms2162456bic_ame_ralisms
capitalists1555526__c_a_pitalists
caramelises1554616ca_rame___lises
centralists1348126__c___entralists
ceremonialists1893166_ceremonialists
commensalisms1873746__commensalisms
communalists18134536__commun_alists
credentialisms1963166__credentialisms
documentarist18163976doc_umentarist_
experimentalist26113266experimentalist_
fundamentalism22112926fundamentalis_m
governmentalist21103166governmentalist_
instrumentalist17133576instrumentalist_
mentalisms1449306_____mentalisms
mentalist11515556_____mentalist_
mercantilists1762306merca__ntilists
metalists11412656_____me_talists
orientalisms14105896__or_ientalisms
orientalist1197816__or_ientalist_
phenomenalists2162866phenomen_alists
sacerdotalisms1961806sac_erdotalisms
sacerdotalist1662156sac_erdotalist_
sacrament1347946sacramen_____t_
scandalises1444806s_c_a__ndalises
scenarists1245116s_c___en_arists
scientists1244966s_c__ient__ists
secretariats1452566secr__e_tariats
sentimentalise16164796sentimentalis_e
sentimentalised18153436sentimentalised
sentimentalism18145106sentimentalis_m
sentimentality1963806sentimentali_ty
sentimentalizes26173766sentimentalizes
surrealists1153746s_ur_re__alists
tarantists1055336ta_ra__nt__ists
ultramontanisms19202436ultramontanisms
ultrarealists13133646ultrare__alists

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 Filter178691950240.1231452772.4
2DLD Change Limit95024638.83010761.5
3Display Results63630.0461369.6
 (SQL Overall)178691638.99919856.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.