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

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

41 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
deviationism185402(None) 
deviationisms1953881deviationisms
deviationist1656151deviationist
deviationists17104742deviationists
deviations14311162deviation_s_
deviation13312393deviation___
divisionism1753203divi_sionism
revisionism16144813revi_sionism
aviations12311554_aviation_s_
creationism1576464_creationism
dealations11311374dealation_s_
decimations16410164decimation_s_
dedications15310874dedication_s_
deflations1439714deflation_s_
delations102616594de_lation_s_
dentations11413634dentation_s_
depictions1546894depiction_s_
depilations14310904depilation_s_
derivations15611494derivation_s_
deviating14311084deviati_n__g
deviators1358534deviat_o_rs_
devolutionist17135154devolutionist
devotions1356594dev_otion_s_
divinations15128414divination_s_
divisionisms1862774divi_sionisms
divisionist1554634divi_sionist
educationist1555264educationist
evictions14228624_eviction_s_
evolutionism17105124_evolutionism
inflationism1753474inflationism
isolationism1453944isolationism
levigations1546214levigation_s_
levitations1448294levitation_s_
mediations13310984mediation_s_
obviations1545464obviation_s_
operationism1655864operationism
reductionism1754324reductionism
revisionisms17143864revi_sionisms
revisionist14146524revi_sionist
salvationism1763114salvationism
seriations10316684seriation_s_

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 Filter1786911247900.203880251.2
2DLD Change Limit124790416.67018709.1
3Display Results41410.0162562.5
 (SQL Overall)178691416.88925938.6
 
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.