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

59 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
abstractionism2013295(None) 
abstractionisms21132661abstractionisms
abstractionist18133861abstractionist
abstractionists19143302abstractionists
abstractions1645782abstraction_s_
obstructionism20103232obstructionism
abstraction1545883abstraction___
abstractional1753253abstraction_al
obstructionisms2192803obstructionisms
obstructionist18113993obstructionist
restrictionism1863783restrictionism
abstractedness1962574abstractedness
abstracting1645184abstracti_n__g
abstractness1683014abstract__ness
abstractors1554414abstract_o_rs_
attractions1376404a_ttraction_s_
destructionist17104964destructionist
distractions1548754distraction_s_
obstructionists19103384obstructionists
obstructions16155524obstruction_s_
restrictionisms1963244restrictionisms
restrictionist1665044restrictionist
aberrations1346695aberra_tion_s_
abjurations2045145abjura_tion_s_
abolitionism16134145ab__olitionism
abortionist1356165ab_or__tionist
abreactions1544195ab_reaction_s_
absorptions1544595absor_ption_s_
abstentions1364365abst_ention_s_
abstracters1544105abstract__ers_
abstractest1553625abstract___est
abstractive1854895abstract___ive
abstractor1444385abstract_o___r
abstracts1346595abstract____s_
abstricting1654505abstricti_n__g
arbitrations1445765arbitra_tion_s_
associationism18172605associationism
attraction1276955a_ttraction___
castrations13410055castra_tion_s_
constructionist1984035constructionist
contractions16410405contraction_s_
destructionists1894225destructionists
destructions1547255destruction_s_
detractions14118275_detraction_s_
distraction1449115distraction___
extractions2077745_extraction_s_
instructions14137815instruction_s_
isolationism1453945_isola_tionism
lustrations1147625lustra_tion_s_
obstruction15135545obstruction___
operationism1655865_opera_tionism
protectionism1984945prot_ectionism
protractions1646645protraction_s_
restrictionists1764085restrictionists
restrictions1449285restriction_s_
retractions13910355_retraction_s_
strictions1249145__striction_s_
subtractions1645375subtraction_s_
tractions11511625___traction_s_

Search took 8 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.1101624463.6
2DLD Change Limit95024596.87613819.7
3Display Results59590.0461282.6
 (SQL Overall)178691597.03225411.1
 
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.