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

52 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
electronica158645(None) 
electronic1477951electronic_
electronicas1675541electronicas
electronics1557221electronics
electric1249183electr__ic_
electrical1446143electr__ical
electrics1348003electr__ics
electrogenic1755683electrogenic_
electroing1346913electro_ing
electron102611413electron___
electronically2163833electronically
electrons112411763electron__s
electrotonic1654913electrotonic_
aleuronic1144694ale_uronic_
election102015354election___
electioneer1353864electioneer
elections112414974election__s
electrician1554484electrician
electricity1854954electricity
electrified1754604electrified
electrifies1645754electrifies
electrify1744674electr__ify
electro92810034electro____
electrocute1555094electrocute
electrode1247034electro__de
electrodes1347274electro_des
electroed1246994electro__ed
electroform18104044electroform
electrogram1654894electrogram
electrojet1956794electro_jet
electrojets2055264electrojets
electroless1356014electroless
electrology1755234electrology
electrolyte1655644electrolyte
electrolytic1955774electrolytic_
electrolyze2554694electrolyze
electrophile1955344electrophile
electros102811754electro___s
electroshock2383244electroshock
electrotype1854634electrotype
electroweak2063594electroweak
isoelectronic1762184isoelectronic_
lactonic1248054_lact_onic_
leptonic1247704_lept_onic_
neutronic1145944_neutronic_
nonelectronic1762754nonelectronic_
plectron12228024plectron___
plectrons13258074plectron__s
selectionist1458084selectionist
tectonic1248454_tect_onic_
tectonics1345954_tect_onics
veronica1346734_ve__ronica

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 Filter1786911488190.406440125.6
2DLD Change Limit148819528.37317773.7
3Display Results52520.0163250.0
 (SQL Overall)178691528.79520317.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.