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

81 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
constructivists2222307(None) 
constructivisms24232811constructivisms
constructivist21214191constructivist_
constructivism23213682constructivis_m
constructionist1984033constructionist_
constructions1747714construct__ions
constructive1957444constructiv___e
constructively2463844constructiv_ely
obstructionists19103384_obstructionists
collectivists2063665co__llectivists
comparativists2361795compar_ativists
conductivity2353795con__ductivi_ty
constrictions1747785constrict__ions
constrictive1956625constrictiv___e
constructible19113765construct__ible
constructing1746755construct__i_ng
construction1648085construct__i_on
constructional1854765constructi_onal
constructors1676475construct___ors
constructs1457055construc_____ts
contractility2074075con_tractili_ty
destructionists1894225_destructionists
destructivity2262715_destructivi_ty
nonobjectivists2971825nonobjectivists
obstructionisms2192805_obstructionisms
obstructionist18113995_obstructionist_
obstructives1953915_obstructiv__es
abstractionists19143306_abstractionists
collectivises2063736co__llectivises
collectivisms2263246co__llectivisms
collectivist1964626co__llectivist_
comparativist2262556compar_ativist_
concretists1555466con_cr_et__ists
conductivities2283566con__ductivities
conjunctivitis2881736con_junctivitis
connectivity2254556con__nectivi_ty
conservationist2084026conservationist_
conservatisms2083536conservat__isms
conservatives2195196conservativ__es
constatives1646936const__ativ__es
constraints1346206constr____aints
constricting1747026constrict__i_ng
constriction1648266constrict__i_on
constrictors1676016constrict___ors
constricts1477736constr_____icts
construct1358716construc_____t_
constructed1646256construct____ed
constructor1576526construct____or
consumerists1672666cons__u_merists
contortionists16103366con_t_ortionists
contrabandists1971466con_trabandists
contrabassists18111316con_trabassists
contractibility2462586con_tractibility
contractilities1983196con_tractilities
contractions16410406con_tract__ions
contractive1849526con_tractiv___e
contrapuntists1871846con_trapuntists
corporativisms2371736corpor_ativisms
corruptionists1862456co__rruptionists
deconstructions20124366deconstruct__ions
deconstructive22124106deconstructiv___e
destructionist17104966_destructionist_
destructivities2162516_destructivities
instructions14137826_instruct__ions
instructive1656486_instructiv___e
instructively2164426_instructiv_ely
instructiveness2064156_instructiveness
instructress1452896_instruct_res_s
instructresses1691756_instructresses
nonobjectivisms3181636nonobjectivisms
nonobjectivist2872116nonobjectivist_
objectivists2663386_o__bjectivists
obstructionism20103236_obstructionis_m
obstructions16155526_obstruct__ions
obstructive1854616_obstructiv___e
obstructiveness2273396_obstructiveness
positivists1654196po_s___itivists
reconstructions19124746reconstruct__ions
reconstructive21124466reconstructiv___e
restrictionists1764086_restrictionists
unconstructive21104216unconstructiv___e

Search took 9 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.373479064.3
2DLD Change Limit95024817.61012486.7
3Display Results81810.0631285.7
 (SQL Overall)178691818.04622208.7
 
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.