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

40 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
executioners217219(None) 
executioner2072611executioner_
executions1946392execution__s
electioneers1453693elec_tioneers
executers1854183execut___ers
execution1846303execution___
executives2263163executi_ve_s
executors1844653execut_o__rs
extortioners1952063extortioners
actioners1147724__ac_tioners
cautioners1244714__cautioners
ejections18249964ejec_tion__s
electioneer1353864elec_tioneer
elections112414974elec_tion__s
elocutionary1762374elocutionary
elocutions1245964elocution__s
erections112515214erec_tion__s
evections142510694evec_tion__s
exactions1838924exac_tion__s
exceptions2146864exception__s
execrations2048924execration__s
executants1952694execut_an_ts
executer1745314execut___er_
executes1736534execut___e_s
executing1945584executi_n__g
executive2164744executi_ve__
executor1744834execut_o__r_
executory2143724execut_o__ry
executrices2251904executrice_s
executrixes1951284executrixe_s
exemptions2164834exemption__s
exertions1639764exe_rtion__s
exhibitioners2561594exhibitioners
exsections1947634exsec_tion__s
extortioner1852654extortioner_
mentioners1245344_me_ntioners
petitioners1353434_petitioners
questioners2052684que_stioners
redemptioners186894redemptioners
vacationers1652484_vacationers

Search took 7 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 Filter1786911247900.390458182.1
2DLD Change Limit124790406.15620271.3
3Display Results40400.0162500.0
 (SQL Overall)178691406.56227231.2
 
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.