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

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

102 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
intersections159896(None) 
interjections2277991interjections
intersection14610181intersection_
intellections1565382intellections
interactions14410462inter_actions
interceptions1758182interceptions
interdictions1667492interdictions
interjection2198922interjection_
intersecting1549712intersecti_ng
intersectional16146252intersectional
intersessions13195282intersessions
interventions1657512interventions
imperfections2254003imperfections
indirections1556193indir_ections
insurrections15104143insurrections
intellection1466163intellection_
interaction13411813inter_action_
interception1649393interception_
intercessions15225883intercessions
interdiction1568143interdiction_
interjecting2248393interjecti_ng
interjectional23195603interjectional
interjectors2155043interject_ors
interrelations1457613interrelations
interruptions1565733interruptions
intersects1249153intersect___s
intersession12175813intersession_
interspersions1663873interspersions
interstation12410413interstation_
intervention1568383intervention_
introjections2255783introjections
introspections1864063introspections
erections112515214___er_ections
exsections1947634___exsections
imperfection2154044imperfection_
incretions1248654in_cr_e_tions
indirection1456384indir_ection_
infarctions1645024infar__ctions
infections15510234in___fections
infestations1546624infe_stations
inflections1646984in__flections
infractions1646964in_fr_actions
ingestions1197594inge_s__tions
injections1948664in___jections
innervations1546924inner_vations
insertions10410344in___sertions
inspections1546424in__spections
instructions14137814instr_uctions
insurrection14104384insurrection_
integrations13129474inte_grations
intenerations1347464intenerations
intensions1048404intens___ions
intentions10411404int___entions
interacting14411714inter_acti_ng
interactional1557004inter_actional
intercalations1655914intercalations
intercepting1748874intercepti_ng
interceptors16115734intercept_ors
intercession14226444intercession_
interdicting1647454interdicti_ng
interdictors1554454interdict_ors
interelectron1564134interelectron_
interesting12411124inter_esti_ng
interferons1446744interfe__rons
interfusions1574394inter_fusions
interjector2055434interject_o_r
interjectory2454514interject_ory
interjects1947534interject___s
interleukins1654144interleuki_ns
interlineations1554544interlineations
intermediations1894424intermediations
intermedins1447384interme_di_ns
intermissions1594144intermissions
internecine1367874internec_i_ne
interneurons1253824interne_urons
interpellations1774704interpellations
interpolations1657434interpolations
interpositions1685124interpositions
interpretations17134804interpretations
interrelation1358734interrelation_
interrogations1556814interrogations
interruption1466404interruption_
intersect11412114intersect____
intersected1448284intersect__ed
interspecies1655094interspec_i_es
interspersion1564394interspersion_
interstices1348524inters__tices
interventionism2062374interventionism
interventionist1862904interventionist
intinctions1347004int__inctions
introductions1655134introductions
introjection2156204introjection_
introspection1764624introspection_
inversions1347004invers___ions
iterations10413824i_ter__ations
ivermectins1852864i_vermecti_ns
perfections1848144__perfections
persecutions1654794__persecutions
resections121513034__re_sections
trisections1345644__trisections
venesections1752934vene_sections
winterizations26157504winterizations

Search took 6 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.1401276364.3
2DLD Change Limit950241024.98319069.6
3Display Results1021020.0631619.0
 (SQL Overall)1786911025.18634456.4
 
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.