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

49 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
constructivist2121419(None) 
constructivism23213681constructivism
constructivists22223071constructivists
constructionist1984032constructionist
constructivisms24232812constructivisms
constructions1747713constructions_
constructive1957443constructiv__e
constructively2463833constructively
constrictions1747784constrictions_
constrictive1956624constrictiv__e
constructible19113754constructi_ble
constructing1746754construct__ing
construction1648084construct__ion
constructional1854764constructional
constructors1676474construct_ors_
constructs1457054construct___s_
obstructionist18113994_obstructionist
obstructives1953914_obstructives_
collectivist1964625co__llectivist
comparativist2262555compar_ativist
conductivity2353785con__ductivity
conservationist2084025conservationist
conservatives2195195conservatives_
constatives1646935const__atives_
constricting1747025constrict__ing
constriction1648265constrict__ion
constrictors1676015constrict_ors_
constricts1477735constrict___s_
construct1358715construc_____t
constructed1646255construct___ed
constructor1576525construct___or
contractility2074075con_tractility
contractions16410405con_tractions_
contractive1849525con_tractiv__e
deconstructions20124365deconstructions_
deconstructive22124105deconstructiv__e
destructionist17104965_destructionist
destructivity2262705_destructivity
instructions14137815_instructions_
instructive1656485_instructiv__e
instructively2164425_instructively
nonobjectivist2872115nonobjectivist
obstructionism20103235_obstructionism
obstructionists19103385_obstructionists
obstructions16155525_obstructions_
obstructive1854615_obstructiv__e
reconstructions19124735reconstructions_
reconstructive21124465reconstructiv__e
unconstructive21104215unconstructiv__e

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.343520965.0
2DLD Change Limit95024496.00015837.3
3Display Results49490.0301633.3
 (SQL Overall)178691496.37328038.8
 
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.