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

109 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
interjectional2319558(None) 
intersectional16146231intersectional
interactional1556982inter_actional
interjection2198922interjection__
interjections2277982interjection_s
insurrectional1662583insurrectional
intercessional1663643intercessional
interjecting2248393interjecti_n_g
international1357663inter_national
interregional1453753interre_gional
intersection14610183intersection__
intersections1598953intersection_s
inflectional1754364in__flectional
insertional1147444inser___tional
instructional1555074instr_uctional
intellection1466164intellection__
intellections1565384intellection_s
intentional11128834int___entional
interaction13411814inter_action__
interactions14410454inter_action_s
interception1649384interception__
interceptions1758174interception_s
interdiction1568144interdiction__
interdictions1667494interdiction_s
interjector2055434interject_o__r
interjectors2155044interject_o_rs
interjectory2454504interject_o_ry
internationals1454234inter_nationals
interneuronal1362694interne_uronal
interpersonal1564024interpe_rsonal
interrogational1693904interrogational
intersecting1549714intersecti_n_g
interterminal1554294intertermi_nal
intervention1568384intervention__
interventions1657504intervention_s
introjection2156204introjection__
introjections2255774introjection_s
introspectional1972624introspectional
antirational1278445antir__ational
antirejection2283205antirejection__
bidirectional18152475bidir_ectional
contractional1756045cont_r_actional
correctional1675285__correctional
directional1445425__dir_ectional
imperfection2154045imperfection__
imperfections2254005imperfection_s
indirection1456355indir_ection__
indirections1556155indir_ection_s
inferential1457535infer_enti__al
informational1854335infor_mational
injection1838655in___jection__
injections1948665in___jection_s
inscriptional17173505inscr_iptional
insurrection14104375insurrection__
insurrectionary2071325insurrectionary
insurrections15104125insurrection_s
intellectual1463415intellect__ual
intensional11146565int___ensional
interacting14411715inter_acti_n_g
interbehavioral237955interbehavioral
intercepting1748865intercepti_n_g
intercession14226445intercession__
intercessions15225875intercession_s
intercolonial1563975inter__colonial
intercortical1764405intercorti_cal
interdental1258415interdent___al
interdicting1647455interdicti_n_g
interdivisional1971725interdivisional
interelectron1564135interelectron__
interelectronic19132015interelectronic
interesting12411125inter_esti_n_g
interestingly1753995inter_esti_ngly
interfacial1656295interfac_i__al
interject1849605interject_____
interjected2146845interject___ed
interjects1947535interject____s
intermarginal1672905intermargi_nal
internationally1873715inter_nationally
internecine1367875internec_i_n_e
interracial1357075interrac_i__al
interrelation1358735interrelation__
interrelations1457615interrelation_s
interrenal1049805interre____nal
interruption1466405interruption__
interruptions1565725interruption_s
intersession12175815intersession__
intersessions13195285intersession_s
intersocietal1562415intersoc_ietal
interstation12410415interstation__
interstitial1255635inter__stitial
intertextual1953725intertext__ual
intertidal1147705inter___ti_dal
interventionism2062375interventionism
interventionist1862905interventionist
intervertebral1961655intervertebral
interzonal1946805inter____zonal
intestinal1047505int___esti_nal
intonational1256005int__onational
introjecting2254255introjecti_n_g
intuitional1155285int___uitional
nondirectional1763065nondir_ectional
perceptional1854895__perceptional
projectional2355405__projectional
reflectional1753985__reflectional
resurrectional1661735resurrectional
tractional1248035__t_r_actional
unexceptional2462505un_exceptional
unidirectional1762105unidirectional
untraditional1463865unt_raditional

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.1261418182.5
2DLD Change Limit950241097.97011922.7
3Display Results1091090.0601816.7
 (SQL Overall)1786911098.15621909.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.