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

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

89 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
electronics155721(None) 
electronic1477941electronic_
electronica1586431electronica
electronicas1675531electronicas
electrics1348002electr__ics
electrons112411752electron__s
elections112414973election__s
electric1249183electr__ic_
electrifies1645743electrifies
electrodes1347253electro_des
electrogenic1755673electrogenic_
electroing1346903electro_ing
electrojets2055253electrojets
electroless1356003electroless
electron102611413electron___
electros102811743electro___s
electrotonic1654903electrotonic_
plectrons13258073plectron__s
tectonics1345953_tect_onics
aleuronic1144694ale_uronic_
chronics1538684___chronics
dielectrics1653334dielectr__ics
eclectics1254814eclect___ics
ejections18249964ejection__s
election102015354election___
electioneer1353864electioneer
electioneers1453694electioneers
electorates1347454electorates
electors103013844elect_o__rs
electress1146114electr__ess
electresses1345964electresses
electrets1146544electr__ets
electrical1446144electr__ical
electrician1554484electrician
electricians1653884electricians
electricity1854954electricity
electrified1754604electrified
electrify1744674electr__ify
electro92810034electro____
electrocute1555084electrocute
electrocutes1655304electrocutes
electrode1247014electro__de
electrodynamics25112954electrodynamics
electroed1246974electro__ed
electroform18104034electroform
electroforms19104184electroforms
electrogram1654884electrogram
electrograms1755054electrograms
electrojet1956774electro_jet
electrokinetics23122964electrokinetics
electrologies1656254electrologies
electrology1755224electrology
electrolyses1755624electrolyses
electrolysis1755594electrolysis
electrolyte1655634electrolyte
electrolytes1755934electrolytes
electrolytic1955764electrolytic_
electrolyze2554684electrolyze
electrolyzes2655174electrolyzes
electronically2163834electronically
electrophile1955334electrophile
electrophiles2055114electrophiles
electroshock2383234electroshock
electroshocks2493214electroshocks
electrostatics1863434electrostatics
electrotonus1453884electrotonus
electrotype1854624electrotype
electrotypes1965184electrotypes
electroweak2063574electroweak
electrums1344484electr__ums
electuaries1354234electuaries
erections112515214erection__s
evections142510694evection__s
flections14239214flection__s
glyconics1743574glyc__onics
isoelectronic1762184isoelectronic_
lactonic1248044_lact_onic_
lections102413844_lection__s
leptonic1247704_lept_onic_
macaronics1643684_macaronics
neotropics1475174_neotropics
neutronic1145944_neutronic_
nonelectronic1762754nonelectronic_
optoelectronics2171514optoelectronics
plectron12228024plectron___
selectionist1458084selectionist
selectionists1556024selectionists
selections12310874selection__s
tectonic1248454_tect_onic_

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 Filter1786911488190.406440125.6
2DLD Change Limit148819899.43615771.4
3Display Results89890.0461934.8
 (SQL Overall)178691899.88818071.5
 
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.