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

119 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
intersectional1614625(None) 
interjectional23195601interjectional
interactional1557002inter_actional
intersection14610182intersection__
intersections1598962intersection_s
insurrectional1662603insurrectional
intercessional1663643intercessional
interjection2198923interjection__
interjections2277993interjection_s
international1357673inter_national
interregional1453763interre_gional
intersecting1549713intersecti_n_g
introspectional1972633introspectional
inflectional1754384in__flectional
insertional1147464in___sertional
instructional1555094instr_uctional
intellection1466174intellection__
intellections1565394intellection_s
intensional11146574intens___ional
intentional11128854int___entional
interaction13411814inter_action__
interactions14410464inter_action_s
interception1649404interception__
interceptions1758184interception_s
interdiction1568144interdiction__
interdictions1667494interdiction_s
interjecting2248394interjecti_n_g
internationals1454244inter_nationals
interneuronal1362694interne_uronal
interpersonal1564024interpe_rsonal
interrogational1693904interrogational
intersession12175814intersession__
intersessions13195284intersession_s
intersocietal1562414intersoc_ietal
interstation12410414interstation__
interstitial1255634inters__titial
interterminal1554304intertermi_nal
intervention1568384intervention__
interventions1657514intervention_s
intestinal1047514inte_s__ti_nal
antirational1278495antir__ational
bidirectional18152495bidir_ectional
bisectional1554645___bisectional
contractional1756065cont_r_actional
conversational1954165convers_ational
correctional1675325__correctional
directional1445445__dir_ectional
imperfection2154045imperfection__
imperfections2254005imperfection_s
indirection1456385indir_ection__
indirections1556195indir_ection_s
inessential1154665in_essenti__al
inferential1457545infer_enti__al
informational1854345infor_mational
inquisitional2272835inquis_itional
inscriptional17173515inscr_iptional
insurrection14104385insurrection__
insurrectionary2071345insurrectionary
insurrections15104145insurrection_s
intellectual1463415intellect__ual
interacting14411715inter_acti_n_g
interbehavioral237955interbehavioral
intercepting1748885intercepti_n_g
intercession14226445intercession__
intercessions15225885intercession_s
intercolonial1563985inter__colonial
intercortical1764425intercorti_cal
interdental1258425interdent___al
interdicting1647455interdicti_n_g
interdivisional1971725interdivisional
interelectron1564135interelectron__
interelectronic19132015interelectronic
interesting12411125inter_esti_n_g
interestingly1753995inter_esti_ngly
interfacial1656295interfac_i__al
interjector2055435interject_o__r
interjectors2155045interject_o_rs
interjectory2454515interject_o_ry
intermarginal1672905intermargi_nal
internationally1873715inter_nationally
internecine1367875internec_i_n_e
interracial1357075interrac_i__al
interrelation1358735interrelation__
interrelations1457615interrelation_s
interrenal1049825interre____nal
interruption1466405interruption__
interruptions1565735interruption_s
interschool1652515inters_c_ho_ol
intersect11412115intersect_____
intersected1448285intersect___ed
intersects1249155intersect____s
intersegmental1762375intersegmental
intersexual1854725interse___xual
interspersion1564395interspersion__
interspersions1663875interspersion_s
interstadial1354085inters__tadial
intertextual1953725intertext__ual
intertidal1147715inter___ti_dal
interventionism2062375interventionism
interventionist1862905interventionist
intervertebral1961655intervertebral
interzonal1946815inter____zonal
intonational1256005int__onational
introjection2156205introjection__
introjections2255785introjection_s
introspection1764625introspection__
introspections1864065introspection_s
intuitional1155295int___uitional
nondirectional1763085nondir_ectional
perceptional1854905__perceptional
reflectional1753995__reflectional
resurrectional1661755resurrectional
sectional1149425_____sectional
tractional1248055__t_r_actional
unexceptional2462515un_exceptional
unidirectional1762125unidirectional
unsensational1353665unsens_ational
untraditional1463875unt_raditional
vivisectional2162105_vivisectional

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.406440125.6
2DLD Change Limit950241197.92311993.4
3Display Results1191190.0761565.8
 (SQL Overall)1786911198.40521260.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.