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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
interconnects176271(None) 
interconnect1654441interconnect_
interconnected1962272interconnected
interconverts1853102interconverts
interconnecting2062343interconnecting
interconnection1963123interconnection
interconvert1754883interconvert_
intercepts1448634interc___epts
interconverted2062474interconverted
intercoolers1454454intercoole_rs
intercounty1654694intercoun__ty
interjects1947534inter___jects
internments13510284inter__nments
intersects1249154inter___sects
introjects1953704int_r_o_jects
introspects15103034int_r_ospects
reconnects1445134__re_connects
connects123010565_____connects
disconnects1654115__disconnects
intellects1245215inte___llects
interactants1464505interactan__ts
interacts11312125inter____acts
interceders14136435interc_ede_rs
intercedes131610435interc___edes
intercept13410965interc___ept_
intercepters16126395intercepte_rs
interchangers1972645interchangers
interchanges1894265interchan_ges
interchannel1752535interchanne__l
intercompares19133205intercompares
intercoms1349335interco____ms
interconverting21132595interconverting
intercooler1345835intercoole__r
intercorrelate16142555intercorrelate
intercorrelates17162065intercorrelates
intercortical1764405intercortical
intercostals1454605interco_stals
intercountry1753645intercoun_try
intercourses1454595interco_urses
intercrosses1454125intercrosse__s
intercurrent1454355intercurrent_
intercuts1148785interc____uts
interdicts1347085inter___dicts
interests9312555inter____ests
interferences1855475interferences
interionic1248255interio_nic__
interject1849605inter___ject_
interjoined1944945interjoine__d
interjoins1747955interjoin___s
interknits1456205inter__kn_its
interknots1455025inter__kn_ots
interlinears12144585inter_linears
interliners11138695inter_line_rs
interlines101116455inter_line__s
interloans1048265interloan___s
interlocks1645975interlo___cks
interlopers1346195interlo_pe_rs
interlopes1249275interlo_pe__s
interments12716215inter___ments
intermont11513575intermo_n__t_
internees93014845inter___ne_es
internes82721235inter___ne__s
internists10410245inter___nists
internment12412255inter__nment_
internodes1148675interno_de__s
interplants13116755interplan__ts
interpoint12411885interpoin__t_
interposers1346265interpo_se_rs
interposes12410565interpo_se__s
interprets1249335inter__pre_ts
interrogees1245645interro_ge_es
intersect11412115inter___sect_
intersociety1753815intersocie_ty
intertwines1446645intertwine__s
interveners14107305inter_vene_rs
intervenes131012645inter_vene__s
interzone1849355interzo_ne___
inthrones1299675inthr_o_ne__s
intranets949265int_r__ane_ts
introject1844835int_r_o_ject_
introspect1474385int_r_ospect_
introverts1344585int_r_o_verts
misconnects1753265__misconnects
overcorrects19153005_overcorrects
reconnect1347045__re_connect_
superconducts2063145superconducts
undercounts1444095undercoun__ts

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 Filter1786911247900.406440125.6
2DLD Change Limit124790878.53014629.5
3Display Results87870.0461891.3
 (SQL Overall)178691878.98219894.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.