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

98 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
selector104861(None) 
elector93313251_elector
selectors1148961selectors
defector14277952defector
deflector1555062deflector
detector11278322detector
ejector16378602_ejector
electors103013842_electors
electro92810032_electro
erector93513812_erector
lector83514982__lector
neglector1253432neglector
prelector1348092prelector
reflector1445732reflector
rejector17237722rejector
sector83415932s__ector
select82621172select__
selected1159782selected
selectee10910492selectee
selection11311272selection
selectly1346562selectly
selects91912142select_s
bisector1245193bisector
collector1346393collector
defecator1546383defecator
defectors15237883defectors
deflectors1654773deflectors
delator83015023del_ator
delegator1146243delegator
depictor1355513depictor
detecter11298733detecter
detectors12278303detectors
director1147783director
eductor1035863_eductor
effector1644873effector
ejectors17328663_ejectors
elect74327033_elect__
elected102812613_elected
electee92513243_electee
election102015353_election
electoral1156723_electoral
electron102611413_electron
electros102811743_electros
elects83315003_elect_s
elevator1146713_elevator
elicitor1045773_elicitor
enactor938033_enactor
erecter93113393_erecter
erectors103514263_erectors
evertor1038723_evertor
evictor12346363_evictor
exactor1636623_exactor
executor1744833_executor
fellator1176713fellator
hector113312653__hector
infector13478853infector
inflector1465353inflector
injector17236933injector
lectors93415763__lectors
lictor83610853__lictor
neglecter1263633neglecter
neglectors1363543neglectors
objector1943803objector
prelectors1447873prelectors
reactor93011653re_actor
receptor1256693receptor
rector84019753__rector
redactor1147023redactor
reductor1156433reductor
refectory1746023refectory
reflectors1545503reflectors
rejecter17258943rejecter
rejectors18247613rejectors
relator74016363rel_ator
reletter81311023reletter
secretor1045683secretor
sectors93116453s__ectors
selectees1147013selectees
selecting12310533selecting
selections12310873selections
selective1449523selective
selectman1343553selectman
selectmen1344613selectmen
semester1038903semester
senator7313073se_nator
senecio947203senecio_
senecios1046303senecios
servitor1145063servitor
silenter838873silenter
skeleton1244473skele_ton
solicitor1144403solicitor
specter113111733s_pecter
splendor1143753splendor
stentor739383s_tentor
stertor7310093s_tertor
subsector1344403subsector
telecom1146813telec_om
vector113212063__vector

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.440406115.9
2DLD Change Limit146162988.09318060.3
3Display Results98980.0462130.4
 (SQL Overall)178691988.57920828.9
 
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.