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 “instructional” with Change Limit: [1] [2] [3] [4] [5]

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

154 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
instructional155508(None) 
constructional1854752constructional
instruction13137942instruction__
instructions14137812instruction_s
abstractional1753253abstractional
inscriptional17173503inscriptional
insertional1147453inser__tional
institutional1353493institutional
instructing1446293instructi_n_g
insurrectional1662593insurrectional
interactional1556993interactional
intuitional1155283in_t_uitional
construction1648084construction__
constructions1747714construction_s
contractional1756054contractional
destruction1446954destruction__
destructions1547254destruction_s
inflectional1754374in_flectional
informational1854334informational
inspirational1554404inspirational
instructive1656484instructi__ve
instructively2164424instructively
instructor1255164instruct_o__r
instructors1355384instruct_o_rs
intentional11128834in_t_entional
interjectional23195594interjectional
international1357664international
intersectional16146244intersectional
intonational1256004in_tonational
involutional1553574involu_tional
nutritional1154774_nutr_itional
obstruction15135544obstruction__
obstructions16155524obstruction_s
suctional1147684__s__uctional
tractional1248044___tractional
abstraction1545885abstraction__
abstractions1645785abstraction_s
antinational1297465an_tinational
antirational1278465an_tirational
attritional1154245_attr_itional
bidirectional18152485bidirectional
bisectional1554635bis__ectional
conservational1955335conservational
constitutional1663085constitutional
constriction1648265constriction__
constrictions1747785constriction_s
constructing1746755constructi_n_g
constructionist1984035constructionist
correctional1675315_correctional
destructing1546115destructi_n_g
destructionist17104965destructionist
directional1445435__directional
dissertational1562575dissertational
distortional1353485dist_ortional
distraction1449115distraction__
distractions1548755distraction_s
distributional1762965distributional
dysfunctional2261805dysfunctional
fractional1547125___fractional
frictional1546245___frictional
gestational1245115gest__ational
illustrational1461555illustr_ational
incantational1553565incantational
inclinational1553925inclinational
indicational1545745in_dicational
indirection1456375indirection__
indirections1556185indirection_s
induction1248985in__duction__
inductions1348805in__duction_s
infarction1545795infar_ction__
infarctions1645025infar_ction_s
infraction1557455in_fraction__
infractions1646965in_fraction_s
inhalational1553045in_halational
innovational1553835in_novational
inquisitional2272825inquisitional
inscription1544955inscription__
inscriptions1654505inscription_s
insertion9410595inser__tion__
insertions10410345inser__tion_s
insinuation11137265insinuation__
insinuations12136425insinuation_s
inspection1446665ins_pection__
inspections1546425ins_pection_s
instauration12114835instauration__
instaurations13114255instauration_s
instigation1249245instigation__
instigations1348245instigation_s
instinctual1351995instinct__ual
institution1145295institution__
institutionally1872135institutionally
institutions1244735institution_s
instruct1047545instruct_____
instructed1345635instruct___ed
instructiveness2064155instructiveness
instructress1452895instruct_ress
instructs1145795instruct____s
instrumental1473405instru_mental
insurrection14104375insurrection__
insurrectionary2071335insurrectionary
insurrections15104135insurrection_s
intensional11146565in_t_ensional
interaction13411815interaction__
interactions14410465interaction_s
internationals1454235internationals
interregional1453755interregional
intestinal1047515in_t_esti_nal
intinction1247785in_tinction__
intinctions1347005in_tinction_s
intrazonal1954005in_tr__azonal
introduction1555785in_troduction__
introductions1655135in_troduction_s
introspectional1972625in_trospectional
intrusion946815in_tru_sion__
intrusions1046335in_tru_sion_s
intrusting11128175in_trusti_n_g
intuition947625in_t_uition__
intuitions1047295in_t_uition_s
investigational1961935investigational
invitational1554895in_vitational
invocational1754415in_vocational
irrational1047205i___rrational
maturational1454175_maturational
menstruation1455225menstruation__
menstruations1585055menstruation_s
narrational1145435_n_arrational
nondirectional1763075nondirectional
nonfictional1754845_nonfictional
nonfunctional1853755_nonfunctional
nonrational11109115_nonr_ational
nonstructural1573675nonstruct_ural
notational1048125_not__ational
nutational1047045_nut__ational
observational1853175observational
obstructing1644575obstructi_n_g
obstructionism20103235obstructionism
obstructionist18113995obstructionist
postulational1553915postulational
productional1794705_productional
reductional1454585__reductional
restriction1349365restriction__
restrictions1449285restriction_s
resurrectional1661745resurrectional
sectional1149415__s__ectional
situational1144585__situational
stational948515__st__ational
striction1148985__striction__
strictions1249145__striction_s
structural1254395__struct_ural
transductional1782505trans_ductional
tuitional946055___t_uitional
unidirectional1762115unidirectional
unsensational1353665unsensational
untraditional1463875un_traditional

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901549.50013135.8
3Display Results1541540.0931655.9
 (SQL Overall)1786911549.73318359.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.