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

54 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
destructionists1894221destructionists_
destructionist17104962destructionist__
obstructionists19103383obstructionists_
restrictionists1764083restrictionists_
abstractionists19143304abstractionists_
destructions1547254destruction___s_
obstructionisms2192804obstructionisms_
obstructionist18113994obstructionist__
restrictionisms1963244restrictionisms_
restrictionist1665044restrictionist__
abstractionisms21132665abstractionisms_
abstractionist18133865abstractionist__
constructionist1984035constructionist__
destruction1446955destruction_____
destructiveness2173805destructivenes_s_
destructivity2262705destructi_vi_t_y
devolutionists18144415devolu_tionists_
obstructionism20103235obstructioni__sm
reductionists1654655re__ductionists_
reservationists1873695reservationists_
restrictionism1863785restrictioni__sm
abstractionism20132956abstractioni__sm
constructivists22223076constructi_vists_
corruptionists1862456_corruptionists_
demolitionists1763476de_molitionists_
destructibility2372326destructi_bility
destructing1546116destructi_n____g
destructivities2162506destructi_vities
detractions14118276de_traction___s_
deviationists17104746de__viationists_
devolutionist17135156devolu_tionist__
distractions1548756distraction___s_
disunionists1352876dis__u_nionists_
educationists1654346_e__ducationists_
elocutionists1554316_elocu_tionists_
evolutionists16145716_evolu_tionists_
extortionists2074386_ext_ortionists_
instructions14137816instruction___s_
intuitionists1363896_int_uitionists_
metafictionists2291816metafictionists_
nutritionists1393706_nutr_itionists_
obstructions16155526obstruction___s_
perfectionists2164016pe_rfectionists_
protectionists18105146prot_ectionists_
recreationists1664376re_creationists_
reductionisms1853796re__ductionisms_
reductionist1555996re__ductionist__
reductionistic1962126re__ductionistic
reservationist17114336reservationist__
restrictions1449286restriction___s_
resurrectionist1762836resurrectionist__
revolutionists17145126revolu_tionists_
selectionists1556026__selectionists_
separationists1664086separ_ationists_

Search took 6 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 Filter178691658740.376475242.0
2DLD Change Limit65874545.20312660.8
3Display Results54540.0461173.9
 (SQL Overall)178691545.62531767.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.