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

71 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
constructionist1984031constructionist_
constructions1747713construction_s__
constructivist21214193constructi_vist_
constructivists22223073constructi_vists
obstructionist18113993_obstructionist_
obstructionists19103383_obstructionists
conservationist2084024conservationist_
constrictions1747784constriction_s__
construction1648084construction____
constructional1854764construction__al
constructivism23213684constructi_vis_m
constructivisms24232814constructi_visms
destructionist17104964_destructionist_
destructionists1894224_destructionists
obstructionism20103234_obstructionis_m
obstructionisms2192804_obstructionisms
abstractionist18133865_abstractionist_
abstractionists19143305_abstractionists
constriction1648265constriction____
constructing1746755constructi_n___g
constructors1676475construct_o_rs__
contortionist15104425con_t_ortionist_
contortionists16103365con_t_ortionists
contractions16410405con_traction_s__
corruptionist1763035co__rruptionist_
corruptionists1862455co__rruptionists
deconstructions20124365deconstruction_s__
instructions14137815_instruction_s__
obstructions16155525_obstruction_s__
reconstructions19124735reconstruction_s__
restrictionist1665045_restrictionist_
restrictionists1764085_restrictionists
abstractionism20132956_abstractionis_m
abstractionisms21132666_abstractionisms
conductions1649666con__duction_s__
conscriptions1955006conscription_s__
consecutions1647056consecu_tion_s__
conservations1849096conservation_s__
consternations16116046consternation_s__
constipations1747686constipation_s__
constitutions1554866constitution_s__
constricting1747026constricti_n___g
constrictors1676016constrict_o_rs__
constructible19113766construct___ible
constructive1957446construct___i_ve
constructively2463846constructi__vely
constructor1576526construct_o____r
constructs1457056construct____s__
contortionistic1971726con_t_ortionistic
contractility2074076con_tracti_li_ty
contraction15411246con_traction____
contractional1756066con_traction__al
contractionary2162716con_traction_ary
contraptions1647646con_traption_s__
contritions13410916con_tr_ition_s__
cooperationist1864226cooper_ationist_
cooperationists1963196cooper_ationists
deconstruction19134436deconstruction____
destructions1547256_destruction_s__
instruction13137946_instruction____
instructional1555096_instruction__al
insurrectionist1772586_insurrectionist_
intuitionist1264996_in_t_uitionist_
intuitionists1363896_in_t_uitionists
menstruations1585056menstruation_s__
nutritionist12134516__nutr_itionist_
nutritionists1393706__nutr_itionists
obstruction15135546_obstruction____
reconstruction1894776reconstruction____
restrictionism1863786_restrictionis_m
restrictionisms1963246_restrictionisms

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 Filter178691658740.313570897.8
2DLD Change Limit65874715.89011184.0
3Display Results71710.0631127.0
 (SQL Overall)178691716.26628517.6
 
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.