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

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

127 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
interconnection196312(None) 
interconnecting2062342interconnecting
interconnect1654443interconnect___
interconnected1962273interconnect_ed
interconnects1762713interconnect__s
interconversion2072483interconversion
interception1649404interc___eption
interconverting21132594interconverting
interjection2198924inter___jection
interlineation1455404inter_lineation
intersection14610184inter___section
introjection2156204int_r_o_jection
introspection1764624int_r_ospection
nonconnection1784414_n_onconnection
reconnection1655994__re_connection
connection14410535_____connection
disconnection1854205__disconnection
hypercorrection27132195hypercorrection
intellection1466175inte___llection
interaction13411815inter____action
interanimation16136015inter_animation
intercalation1557085interc__alation
interceptions1758185interc___eptions
intercession14226445interc___ession
intercommunion2071885interco_mmunion
interconvert1754885interconvert___
interconverted2062475interconvert_ed
interconverts1853105interconvert__s
interdiction1568145inter___diction
interelectron1564135inter__electron
intergeneration1673405intergeneration
interiorization2464785interiorization
interjections2277995inter___jections
interlineations1554545inter_lineations
intermodulation1893065intermodulation
interpolation1558555interpo__lation
interpopulation1963595interpopulation
interposition1586055interpo__sition
interrogation1457865interro__gation
intersections1598965inter___sections
intervention1568385inter___vention
introduction1555785int_r_o_duction
introjections2255785int_r_o_jections
introspections1864065int_r_ospections
misconnection1954135__misconnection
nonconnections1894145_n_onconnections
reconnections1765755__re_connections
antireflection19102416antir_eflection
antirejection2283216antir__ejection
confection17411186_____confection
connections15410706_____connections
convection17411126_____convection
decongestion1653926__de_congestion
disconnections1954026__disconnections
imperfection2154046imper___fection
impersonation1764226imperso_n_ation
indirection1456386indir____ection
insurrection14104386insur___rection
intellections1565396inte___llections
inteneration1248636inte___neration
intention9412016inte____n__tion
interactions14410466inter____actions
interanimations17115196inter_animations
intercalations1655916interc__alations
intercepting1748886interc___epting
interceptor15156556interc___ept_or
intercessions15225886interc___essions
intercommunions2171636interco_mmunions
intercomparison2171226intercomparison
intercountry1753646intercoun__t_ry
intercounty1654696intercoun__t__y
interdictions1667496inter___dictions
interdigitation1763146interdigitation
interdominion1662636interdo__minion
intergradation16114096inter_gradation
interjecting2248396inter___jecting
interjectional23195606inter___jectional
interjector2055436inter___ject_or
intermediation17105216inter_mediation
intermountain1572166intermoun__tain
internalization2455766internalization
internecine1367876inter___nec_ine
interneuron1154076inter___ne_uron
internucleon1451846inter___nucleon
internuncio1352476inter__nunc_io_
internuncios1452706inter__nunc_ios
interoceptive2074466inter_o_ceptive
interoceptor16134536inter_o_cept_or
interpellation1665616inter_pellation
interpolations1657436interpo__lations
interpositions1685126interpo__sitions
interpretation16115866inter_pretation
interrelation1358736inter__relation
interrogations1556816interro__gations
interruption1466406inter___ruption
intersecting1549716inter___secting
intersectional16146256inter___sectional
intersession12175816inter___session
interspersion1564396inter__spersion
interstation12410416inter___station
intersubjective29151246intersubjective
interunion1046256inter__un___ion
interventions1657516inter___ventions
intervisitation1862856intervisitation
intinction1247786int____in_ction
intonation10410266int___o_n_ation
introductions1655136int_r_o_ductions
introgression1463056int_r_ogression
introjecting2254256int_r_o_jecting
introspecting18123576int_r_ospecting
introspectional1972636int_r_ospectional
introspective2073576int_r_ospective
introversion1554086int_r_o_version
misconnections2063816__misconnections
misrecollection2171356misre_collection
nonconduction1884476_n_onconduction
preconception2154286_pre_conception
preconvention2074006_pre_convention
preconviction2253706_pre_conviction
recollection1654856__re_collection
reconception1855656__re_conception
reconnecting1745356__re_connecting
reconviction1955086__re_conviction
retroflection1854046ret_r_oflection
retrospection1784316ret_r_ospection
superinfection2163656super_infection
transection1357376__t_r_ansection

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 Filter178691950240.360496363.9
2DLD Change Limit950241278.86010725.1
3Display Results1271270.1101154.5
 (SQL Overall)1786911279.33019152.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.