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]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

173 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
abstractions1645787_abstraction_s__
castrations13410057c_astr_ation_s__
coalitionist1485507co___alitionist_
coalitionists1583947co___alitionists
codirections1744707co_direction_s__
colonizationist26102187colonizationist_
concoctions1448257con__coction_s__
concretions1549297con_cr_etion_s__
conduction1549967con__duction____
conductivity2353787con__ducti_vi_ty
confections18411397con__fection_s__
confirmations2055677confirmation_s__
conflictions1945227con_fliction_s__
conformations2046727conformation_s__
conjunctions2345387con_junction_s__
conjurations2148497conjur_ation_s__
connections15410707con__nection_s__
conscription1855337conscription____
consecrations1749217consecration_s__
consecution1547317consecu_tion____
conservation1749407conservation____
conservational1955347conservation__al
consignations16105937consignation_s__
consociations1747517consociation_s__
consolations1449747cons_olation_s__
conspirations1747727conspiration_s__
constellations1654407constellation_s__
consternation15106367consternation____
constipation1648567constipation____
constitution1455267constitution____
constitutional1663097constitution__al
constitutionals1761877constitution_als
constraining1554547constr__ai_ni_ng
constrains1249727constr__ai_n_s__
constraint12411137constr__ai_n__t_
constraints1346207constr__ai_n__ts
constrictive1956627constrict___i_ve
constrictor1596127constrict_o____r
constricts1477737constrict____s__
construct1358717construc______t_
constructed1646257construct_____ed
construing1347447constru__i_n___g
consultations1546937consultation_s__
consummations1955157consummation_s__
consumptions1845147cons_umption_s__
contentions13412097con_t_ention_s__
continuations1547147continuation_s__
contortions1348687con_t_ortion_s__
contraceptions2053387con_traception_s__
contractibility2462587con_tractibility
contracting16610477con_tracti_n___g
contractors1549167con_tract_o_rs__
contradictions1954147con_tradiction_s__
contraption1548107con_traption____
contributions1754747con_tribution_s__
contrition12411417con_tr_ition____
contusions1246997con_t_u_sion_s__
conurbations1646667con_urbation_s__
convections18411497con__vection_s__
conversations1847457conversation_s__
convictions1848047con__viction_s__
convolutions1745197convolu_tion_s__
coproductions2054497coproduction_s__
corrections1548867co__rrection_s__
corruptions1555177co__rruption_s__
counteractions1855027counteraction_s__
creationist1379237c____reationist_
creationists1476627c____reationists
deconstructing20113907deconstructi_n___g
deconstructors1963627deconstruct_o_rs__
destruction1446957_destruction____
destructivity2262707_destructi_vi_ty
distractions1548757_distraction_s__
instructing1446297_instructi_n___g
instructiveness2064157_instructivenes_s
instructors1355387_instruct_o_rs__
intuitionism1453597_in_t_uitionis_m
intuitionisms1563317_in_t_uitionisms
menstruation1455227menstruation____
misconstruction2162707misconstruction____
nonconstruction1983277nonconstruction____
nonsolutions1254177nonsolu_tion_s__
obstructing1644577_obstructi_n___g
obstructiveness2273397_obstructivenes_s
obstructives1953917_obstructi_ves__
obstructors1564007_obstruct_o_rs__
operationist1457947_o_per_ationist_
operationists1556057_o_per_ationists
preservationist2062807preservationist_
protectionist17116687_prot_ectionist_
protectionists18105147_prot_ectionists
reconstructing1974437reconstructi_n___g
reconstructors1863937reconstruct_o_rs__
reductionist1555997___reductionist_
reductionists1654657___reductionists
reservationist17114337_reservationist_
reservationists1873697_reservationists
restrictions1449287_restriction_s__
resurrectionist1762837resurrectionist_
selectionist1458087___selectionist_
selectionists1556027___selectionists
strictions1249147___striction_s__

Search took 10 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.356501941.0
2DLD Change Limit950241738.94010629.1
3Display Results1731730.1401235.7
 (SQL Overall)1786911739.43618937.2
 
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.