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

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

100 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
electros10281174(None) 
electors103013851electors
electro92810031electro_
electron102611411electron
electrons112411751electrons
ejectors17328662ejectors
electees10238722electees
election102015352election
elections112414972elections
elector93313262elect_or
electress1146112electress
electret10412002electret
electrets1146542electrets
electric1249182electric
electrics1348002electrics
electrode1247022electrode
electrodes1347262electrodes
electroed1246982electroed
electrum1245212electrum
electrums1344482electrums
elects83315002elect__s
erectors103514262erectors
lectors93415772_lectors
plectron12228022plectron
plectrons13258072plectrons
selectors1148972selectors
defectors15237883defectors
deflectors1654773deflectors
detectors12278303detectors
eclectics1254813eclectics
eductors1135983eductors
effectors1755033effectors
ejection172510043ejection
ejections18249963ejections
ejector16378603eject_or
ejects15409953eject__s
elect74327033elect___
elected102812613elect_ed
electee92513243elect_ee
electing112113783electing
elective13311003elective
electives1448933electives
electoral1156733electoral
electrify1744673electrify
electroing1346903electroing
electrojet1956783electrojet
electrojets2055253electrojets
electroless1356003electroless
electronic1477943electronic
electronics1557213electronics
elevators1246303elevators
elicitors1145803elicitors
elytron1045463el_ytron
elytrous1145513el_ytrous
enactors1038463enactors
erecters102611613erecters
erection102115513erection
erections112515213erections
erector93513813erect_or
erects84116183erect__s
evection131910833evection
evections142510693evections
evertors1138953evertors
evictors13276853evictors
exactors1737023exactors
executors1844653executors
flection13239563flection
flections14239213flections
hectors123513263_hectors
kleptos1344363klept_os
lecterns1035943_lecterns
lectins92515003_lectins
lection92614863_lection
lections102413843_lections
lector83514993_lect_or
lectures101310163_lectures
lentos65317403_lent_os
lictors93212603_lictors
maestros1046163maestros
metros84217803_me_tros
neglectors1363543neglectors
olestras846583olestras
plectra1145793plectr_a
plectrum1453953plectrum
plectrums1553033plectrums
prelectors1447873prelectors
rectors93520523_rectors
rectos85718783_rect_os
reflectors1545503reflectors
rejectors18247613rejectors
retros63820193_re_tros
sectors93116453_sectors
selectees1147013selectees
selection11311273selection
selections12310873selections
selector1048623select_or
selects91912143select__s
spectres12268683spectres
vectors123212593_vectors
velcros1244033vel_c_ros

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 Filter1786911461620.906197230.7
2DLD Change Limit1461621007.40619735.6
3Display Results1001000.0462173.9
 (SQL Overall)1786911008.35821379.6
 
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.