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

105 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
executed183550(None) 
execute1636781execute_
executer1745311executer
executes1736531executes
ejected17297652ejec_ted
elected102812612elec_ted
erected103213992erec_ted
exacted1737302exac_ted
excepted2055242excepted
excited1737852ex_cited
excused1736292ex_cused
execrated1938352execrated
executers1854182executers
executor1744832executor
exempted2044142exempted
exerted152210052exe_rted
expected2036742expec_ted
exsected1835672exsec_ted
reexecuted2062692reexecuted
debuted11379333_debuted
defecated1637493defecated
defected15289973defec_ted
dejected19307593dejec_ted
deputed114610173_deputed
detected12289733detec_ted
educated1237943educated
effected1744993effec_ted
egested938123ege_sted
electee92513243elec_tee
elevated12118293elevated
elicited1139093elicited
eluted74915263__eluted
embruted1344353embruted
emeute838533eme_ute_
emeutes938013eme_utes
enacted10310643enac_ted
erecter93113393erec_ter
eructed10228653eruc_ted
escoted1038183e_scoted
evacuated15196263evacuated
everted112711853eve_rted
evicted1337243evic_ted
exacter1637403exac_ter
exalted1537393ex_alted
exapted1736073ex_apted
exceed1636173ex_c_eed
exceeded1943493exceeded
excelled18125703excelled
excerpted2153873excerpted
excessed1844943excessed
excided1836203ex_cided
excised1736673ex_cised
excite15310883ex_cite_
exciter1637753ex_citer
excites16310633ex_cites
excluded1943433excluded
excreted1846153excreted
excuse1537423ex_cuse_
excuser1635813ex_cuser
excuses1638903ex_cuses
execrate1739653execrate_
execrates1839563execrates
executant1844113executant
executing1945583executing
execution1846303execution
executive2164743executive
executives2263163executives
executors1844653executors
executory2143723executory
executrix1751473executrix
exegete1545773exegete_
exegetes1655313exegetes
exequies2444153exequies
exercised1944633exercised
exhausted2042643exhausted
exhorted1935013exhorted
exhumed2043413ex_humed
existed1538473ex_isted
exited144712523ex__ited
expecter1936513expec_ter
expedited2044933expedited
experted1838053experted
expiated18168523expiated
exported1837133exported
exserted1636213exserted
extenuated1843753extenuated
extorted1636233extorted
extruded1743843extruded
exuded15317683ex__uded
exulted1536303ex_ulted
persecuted1543503persecuted
precited133013813precited
precured1339993precured
recited104319103_recited
recused104714433_recused
reexecute1862723reexecute_
reexecutes1962623reexecutes
refected142311663refec_ted
refuted114313803_refuted
rejected182710113rejec_ted
reputed104613483_reputed
resected112514743resec_ted
resecured1245533resecured
secured1059723_secured
selected1159783selec_ted

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621057.98618302.3
3Display Results1051050.0303500.0
 (SQL Overall)1786911058.43621182.0
 
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.