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 “execute” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
execute163678(None) 
executed1835501executed
executer1745311executer
executes1736531executes
emeute838532eme_ute
excite15310882ex_cite
excuse1537422ex_cuse
execrate1739652execrate
executers1854182executers
executive2164742executive
executor1744832executor
exegete1545772exegete
reexecute1862722reexecute
acute74720363__acute
cute66440453___cute
defecate1438793defecate
depute94512303_depute
educate10310213educate
eject145016043ejec_t_
ejecta15337393ejec_ta
ejected17297653ejec_ted
ejects15409953ejec_ts
elect74327033elec_t_
elected102812613elec_ted
electee92513243electee
elects83315003elec_ts
elevate101110373elevate
elute54822573__elute
embrute1145703embrute
emeutes938013eme_utes
epicure1136823epicure
erect74129333erec_t_
erected103213993erec_ted
erecter93113393erec_ter
erects84116183erec_ts
eremite9312833eremite
euxenite1545443euxenite
evacuate13217303evacuate
evacuee12105073evacuee
evolute1045683evolute
exabyte1943523exabyte
exact143516933exac_t_
exacta15337393exac_ta
exacted1737303exac_ted
exacter1637403exac_ter
exacts15359613exac_ts
except1797653except_
excepted2055233excepted
excepts1885203excepts
excide1638423ex_cide
excise1538553ex_cise
excited1737853ex_cited
exciter1637753ex_citer
excites16310633ex_cites
exclude1744453exclude
excrete1667163excrete
excused1736293ex_cused
excuser1635813ex_cuser
excuses1638903ex_cuses
exec135313943exec___
execrated1938353execrated
execrates1839563execrates
execs14539723exec__s
executable2144033executable
executant1844113executant
executing1945583executing
execution1846303execution
executives2263163executives
executors1844653executors
executory2143723executory
executrix1751473executrix
exedrae1544713exedrae
exegetes1655313exegetes
exempt1737453exempt_
exempted2044143exempted
exempts1844023exempts
exequies2444153exequies
exequy2542523exequ_y
exercise1747063exercise
exergue1544193exergue
exert124624143exe_rt_
exerted152210053exe_rted
exerts133712293exe_rts
exeunt1338703exe_unt
exhume1833803ex_hume
expect1758903expec_t_
expected2036743expec_ted
expecter1936513expec_ter
expects1866883expec_ts
expedite1847263expedite
expiate16910593expiate
exsect1558503exsec_t_
exsected1835673exsec_ted
exsects1655573exsec_ts
extenuate1645003extenuate
extrude1545013extrude
exudate1537093exudate
exude134010293ex__ude
eyecup1344493eyecu_p
eyecups1442823eyecups
persecute1344883persecute
precure11312553precure
precut102016533precut_
precuts111710473precuts
recite83625113_recite
recuse85519163_recuse
recut74729243_recut_
recuts83817373_recuts
reexecuted2062693reexecuted
reexecutes1962623reexecutes
refute95515703_refute
repute84716093_repute
resecure1047183resecure
scute75520943__scute
secure8513533_secure
thecate123210023thecate
uncute82912133_uncute

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271175.94022563.5
3Display Results1171170.0462543.5
 (SQL Overall)1786911176.14229093.3
 
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.