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

68 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
abstractionist1813386(None) 
abstractionism20132951abstractionism
abstractionists19143301abstractionists
abstractionisms21132662abstractionisms
abstractions1645782abstraction_s_
obstructionist18113992obstructionist
abstraction1545883abstraction___
abstractional1753263abstraction_al
destructionist17104963destructionist
obstructionism20103233obstructionism
obstructionists19103383obstructionists
restrictionist1665043restrictionist
abortionist1356164ab_or__tionist
abstractedness1962574abstractedness
abstractest1553624abstract___est
abstracting1645184abstracti_n__g
abstractness1683014abstract__ness
abstractors1554414abstract_o_rs_
attractions1376404a_ttraction_s_
constructionist1984034constructionist
destructionists1894224destructionists
distractions1548754distraction_s_
obstructionisms2192804obstructionisms
obstructions16155524obstruction_s_
restrictionism1863784restrictionism
restrictionists1764084restrictionists
aberrations1346695aberra_tion_s_
abjurations2045145abjura_tion_s_
abolitionist14145135ab__olitionist
abortionists1454975ab_or__tionists
abreactions1544195ab_reaction_s_
absorptions1544595absor_ption_s_
abstentions1364365abst_ention_s_
abstracters1544105abstract__ers_
abstractive1854895abstract___ive
abstractor1444385abstract_o___r
abstracts1346595abstract____s_
abstricting1654505abstricti_n__g
annexationist20233035annexa_tionist
arbitrations1445765arbitra_tion_s_
associationist16173355associationist
attraction1276955a_ttraction___
castrations13410055castra_tion_s_
contractions16410405contraction_s_
destructions1547255destruction_s_
detractions14118275_detraction_s_
distraction1449115distraction___
extractions2077745_extraction_s_
instructions14137815instruction_s_
insurrectionist1772585insurrectionist
isolationist1255885_isola_tionist
liberationist15124735libera_tionist
lustrations1147625lustra_tion_s_
nutritionist12134515_nutr_itionist
obstruction15135545obstruction___
operationist1457945_opera_tionist
protectionist17116685prot_ectionist
protractions1646645protraction_s_
reservationist17114335reservationist
restrictionisms1963245restrictionisms
restrictions1449285restriction_s_
resurrectionist1762835resurrectionist
retractions13910355_retraction_s_
selectionist1458085__selectionist
separationist1555275separa_tionist
strictions1249145__striction_s_
subtractions1645375subtraction_s_
tractions11511625___traction_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 Filter178691950240.360496363.9
2DLD Change Limit95024685.80016383.4
3Display Results68680.0461478.3
 (SQL Overall)178691686.20628793.3
 
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.