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

114 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
intersection1461018(None) 
interjection2198921interjection
intersections1598961intersections
intellection1466172intellection
interaction13411812inter_action
interception1649402interception
interdiction1568142interdiction
interjections2277992interjections
intersecting1549712intersecting
intersectional16146252intersectional
intersession12175812intersession
interstation12410412interstation
intervention1568382intervention
imperfection2154043imperfection
indirection1456383indir_ection
insurrection14104383insurrection
intellections1565393intellections
interactions14410463inter_actions
interceptions1758183interceptions
intercession14226443intercession
interdictions1667493interdictions
interelectron1564133interelectron
interjecting2248393interjecting
interjectional23195603interjectional
interjector2055433interject_or
interrelation1358733interrelation
interruption1466403interruption
intersect11412113intersect___
intersected1448283intersect_ed
intersects1249153intersect__s
intersessions13195283intersessions
interspersion1564393interspersion
interventions1657513interventions
introjection2156203introjection
introspection1764623introspection
antirejection2283214antirejection
erection102115514___er_ection
exsection1847494___exsection
imperfections2254004imperfections
incretion1149054in_cr_e_tion
indirections1556194indir_ections
infarction1545794infar__ction
infection14410474in___fection
infestation1447044infe_station
inflection1547634in__flection
infraction1557454in_fr_action
ingestion10137484inge_s__tion
injection1838654in___jection
innervation1447444inner_vation
insertion9410594in___sertion
inspection1446664in__spection
instruction13137944instr_uction
insurrections15104144insurrections
integration121310494inte_gration
intellective1754654intellective
inteneration1248634inteneration
intension948494intens___ion
intention9412014int___ention
interacting14411714inter_acting
interactional1557004inter_actional
interactive1659634inter_active
intercalation1557084intercalation
intercepting1748884intercepting
interceptor15156554intercept_or
intercessions15225884intercessions
interconnection1963124interconnection
interdicting1647454interdicting
interdictive1855314interdictive
interdictor1454744interdict_or
interesting12411124inter_esting
interferon1346854interfe__ron
interfertile1556424interfertile
interfusion1464984inter_fusion
interject1849604interject___
interjected2146844interject_ed
interjectors2155044interjectors
interjectory2454514interjectory
interjects1947534interject__s
interleukin1554454interleuki_n
interlineation1455404interlineation
intermediation17105214intermediation
intermedin1347444interme_di_n
intermission1464654intermission
internecine1367874internec_ine
interneuron1154074interne_uron
internucleon1451844internucleon
interpellation1665614interpellation
interpolation1558554interpolation
interposition1586054interposition
interpretation16115864interpretation
interrelations1457614interrelations
interrogation1457864interrogation
interruptions1565734interruptions
interschool1652514inters_chool
interservice1754074interservice
interspecies1655094interspec_ies
interspersions1663874interspersions
interstice1249604inters__tice
interstitial1255634interstitial
interstrain1155864interstrai_n
interunion1046254inter__union
intinction1247784int__inction
introduction1555784introduction
introjections2255784introjections
introspections1864064introspections
inversion1247214invers___ion
iteration9515034i_ter__ation
ivermectin1752794i_vermecti_n
perfection1748364__perfection
persecution1564784__persecution
resection111613274__re_section
trisection1245984__trisection
venesection1652944vene_section
winterization25137814winterization

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 Filter1786911247900.393454684.5
2DLD Change Limit1247901147.68616236.0
3Display Results1141140.0761500.0
 (SQL Overall)1786911148.15521911.8
 
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.