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

63 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
executor174483(None) 
executer1745311executer
executors1844651executors
executory2143721executory
coexecutor2151822coexecutor
ejector16378602ejec_tor
elector93313252elec_tor
erector93513812erec_tor
exactor1636622exac_tor
excitor1645992ex_citor
execrator1846562execrator
execute1636782execut_e
executed1835502executed
executers1854182executers
executes1736532executes
execution1846302execution
coexecutors2261693coexecutors
defecator1546383defecator
defector14277953defec_tor
detector11278323detec_tor
educator1147153educator
eductor1035863educ_tor
effector1644873effec_tor
ejectors17328663ejec_tors
electors103013843elec_tors
electro92810033elec_tro
elevator1146713elevator
elicitor1045773elicitor
enactor938033enac_tor
erecter93113393erec_ter
erectors103514263erec_tors
evacuator14114933evacuator
evertor1038723eve_rtor
evictor12346363evic_tor
evocator1346573evocator
exacter1637403exac_ter
exactors1737013exac_tors
excerptor2063653excerptor
exciter1637753ex_citer
exciton1646083ex_citon
excitors1746093ex_citors
excuser1635813ex_cuser
execrators1946023execrators
executant1844113executant
executing1945583executing
executioner2072613executioner
executions1946393executions
executive2164743executive
executorial2052153executorial
executrix1751473executrix
exequatur2551543exequatur
expecter1936513expec_ter
expeditor1943823expeditor
expiator1747043expiator
extenuator1753223extenuator
hector113312653_hec_tor
lector83514983_lec_tor
persecutor1453243persecutor
rector84019753_rec_tor
rejector17237723rejec_tor
sector83415933_sec_tor
selector1048613selec_tor
vector113212063_vec_tor

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 Filter1786911461620.420425454.8
2DLD Change Limit146162636.56322270.6
3Display Results63630.0163937.5
 (SQL Overall)178691636.99925530.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.