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

58 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
executioner207261(None) 
executioners2172191executioners
execution1846302execution__
executions1946392execution_s
electioneer1353863elec_tioneer
executer1745313execut___er
executing1945583executi_n_g
executive2164743executi_ve_
executives2263163executi_ves
executor1744833execut_o__r
extortioner1852653extortioner
actioner1048664__ac_tioner
cautioner1145394__cautioner
ejection172510044ejec_tion__
ejections18249964ejec_tion_s
election102015354elec_tion__
electioneers1453694elec_tioneers
elections112414974elec_tion_s
elocution1145674elocution__
elocutionary1762374elocutionary
elocutions1245964elocution_s
erection102115514erec_tion__
erections112515214erec_tion_s
evection131910834evec_tion__
evections142510694evec_tion_s
exaction1738954exac_tion__
exactions1838924exac_tion_s
exception2046854exception__
exceptional2254444exceptional
exceptions2146864exception_s
execration1949834execration__
execrations2048924execration_s
executable2144034executable_
executant1844114execut_an_t
executants1952694execut_ants
execute1636784execut___e_
executed1835504execut___ed
executers1854184execut___ers
executes1736534execut___es
executors1844654execut_o_rs
executory2143724execut_o_ry
executrices2251904executrices
executrixes1951284executrixes
exemption2064944exemption__
exemptions2164834exemption_s
exertion15310084exe_rtion__
exertions1639764exe_rtion_s
exhibitioner2461874exhibitioner
exsection1847494exsec_tion__
exsections1947634exsec_tion_s
extortioners1952064extortioners
mentioner1146694_me_ntioner
petitioner1244154_petitioner
questioner1943044que_stioner
recautioned1483184_recautioned
redemptioner1761174redemptioner
sectioned1246524_sec_tioned
vacationer1543304_vacationer

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 Filter1786911488190.423422437.4
2DLD Change Limit148819588.03018532.9
3Display Results58580.0331757.6
 (SQL Overall)178691588.48621057.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.