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

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

65 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
interelectronic1913201(None) 
interelectron1564132interelectron__
interelectrode1761963interelectro_de
isoelectronic1762184i__soelectronic
nonelectronic1762754_n_onelectronic
optoelectronic2071874opt_oelectronic
antielectron1463455ant_ielectron__
antielectrons1562985ant_ielectron_s
electronic1477945_____electronic
intellection1466175inte_llection__
intellections1565395inte_llection_s
interethnic1663255inter__e_t_hnic
interjection2198925inter_jection__
interjectional23195605inter_jectional
interjections2277995inter_jection_s
internucleonic1871245inter_nucleonic
intersection14610185inter_section__
intersectional16146255inter_sectional
intersections1598965inter_section_s
microelectronic20112535microelectronic
optoelectronics2171515opt_oelectronics
photoelectronic2472545photoelectronic
antireflection19102416antireflection__
antirejection2283216antirejection__
electronica1586436_____electronica
electronics1557216_____electronics
interaction13411816inter__action__
interactional1557006inter__actional
interactions14410466inter__action_s
interatomic1553846inter___at_omic
interception1649396inter_ception__
interceptions1758186inter_ception_s
interdiction1568146inter_diction__
interdictions1667496inter_diction_s
interferon1346856inter_fe__ron__
interferons1446746inter_fe__ron_s
intergalactic1862346intergalact___ic
intergeneric1563916inter_gener__ic
interionic1248256inter_____ionic
interjecting2248396inter_ject_in_g
interjector2055436inter_ject_o__r
interjectors2155046inter_ject_o_rs
interjectory2454516inter_ject_o_ry
intermetallic1762846inter_me_tallic
intermitotic1653116inter__mit_otic
interneuron1154076inter_ne_uron__
interneuronal1362696inter_ne_uronal
interneurons1253826inter_ne_uron_s
interoceanic1653876inter__oc_eanic
interpellation1665616interpellation__
interpellations1774706interpellation_s
interrelation1358736interrel_ation__
interrelations1457616interrel_ation_s
intersecting1549716inter_sect_in_g
interspecific2261946interspec__ific
intervention1568386inter_vention__
interventionism2062376inter_ventionism
interventionist1862906inter_ventionist
interventions1657516inter_vention_s
introjection2156206int_rojection__
introjections2255786int_rojection_s
isoelectric1553016i__soelectr__ic
nonelectric1555186_n_onelectr__ic
preelectric1753516_pre_electr__ic
technetronic1961306__techne_tronic

Search took 8 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 Limit95024656.90613759.6
3Display Results65650.0431511.6
 (SQL Overall)178691657.30924448.1
 
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.