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

80 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
executions194639(None) 
execution1846301execution_
ejections18249962ejec_tions
elections112414972elec_tions
elocutions1245962elocutions
erections112515212erec_tions
evections142510692evec_tions
exactions1838922exac_tions
exceptions2146862exceptions
execrations2048922execrations
executing1945582executi_ng
executioner2072612executioner
executioners2172192executioners
executives2263162executives
executors1844652execut_ors
exemptions2164832exemptions
exertions1639762exe_rtions
exsections1947632exsec_tions
decurions1246023_decurions
defecations1779003defecations
defections161510203defec_tions
dejections20168353dejec_tions
detections131410043detec_tions
educations1339233educations
eductions1268773educ_tions
egestions1046703ege_stions
ejection172510043ejec_tion_
election102015353elec_tion_
electrons112411763elec_trons
elevations1338633elevations
elocution1145673elocution_
elutions82513053__elutions
erection102115513erec_tion_
evacuations1646303evacuations
evection131910833evec_tion_
evictions14228623evic_tions
evocations15259873evocations
evolutions13107043evolutions
exaction1738953exac_tion_
exception2046853exception_
excerptions2244983excerptions
excisions1846383ex_cisions
excitons1746043ex_cit_ons
exclusions1945013exclusions
excretions1946623excretions
excursions1944323ex_cursions
execration1949833execration_
executant1844113execut_ant
executants1952693executants
executers1854183execut_ers
executes1736533execut__es
executive2164743executi_ve
executor1744833execut_o_r
executory2143723execut_ory
executrices2251903executrices
executrixes1951283executrixes
exemption2064943exemption_
exertion15310083exe_rtion_
exhaustions2153123exhaustions
expectations2365843expectations
expeditions2144633expeditions
expiations1959663expiations
exsection1847493exsec_tion_
exsertions1746743exsertions
exsolutions1844013exsolutions
extenuations1945083extenuations
extortions1746473extortions
extrusions1745163extrusions
exudations18107073exudations
flections14239213flec_tions
lections102413843_lec_tions
locutions11207063_locutions
persecutions1654793persecutions
precautions1546553precautions
recautions1247813_recautions
refections151811643refec_tions
rejections191510103rejec_tions
resections121513033resec_tions
sections102714703_sec_tions
selections12310873selec_tions

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 Filter1786911406030.406440125.6
2DLD Change Limit140603806.59621316.4
3Display Results80800.0431860.5
 (SQL Overall)178691807.04525364.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.