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

109 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
execrates183956(None) 
execrate1739651execrate_
execrated1938351execrated
desecrates1348842desecrates
emeerates1149372emeerates
excretes1787572ex_cretes
execrator1846562execrator
execrators1946022execrators
executes1736532exec_utes
recrates102420372_recrates
aerates74627493_ae_rates
ameerates1149063ameerates
berates94126873_be_rates
celebrates1447673celebrates
cerates95428253_ce_rates
cerebrates1447913cerebrates
crates85736063___crates
deaerates10313643deae_rates
decorates12314743_decorates
defecates1538593defec_ates
delectates1348193delectates
derates84028893_de_rates
desecrate1249083desecrate_
desecrated1447953desecrated
desecrater1346983desecrater
desecraters1444813desecraters
ecartes94212563__ecartes
edentates1046953edentates
educates1139623educ_ates
electorates1347473electorates
elevates111110423ele_vates
emaciates1347883emaciates
emeerate10410103emeerate_
emendates1246083emendates
emigrates1248583emigrates
emirates101214853e_mirates
enervates1248723enervates
ephorates1459163ephorates
eructates1146953eructates
eucrites1049483e_ucrites
evacuates14256803evacuates
exacerbates22113063exacerbates
exarchates2243963exarchates
excavates2144683excavates
excerpted2153873excerpted
excerpter2063903excerpter
excerpters2143183excerpters
excerpts1943743excerpt_s
excites16310633ex_c_ites
exclaves2044923ex_claves
excoriates1946323excoriates
excrete1667163ex_crete_
excreted1846153ex_creted
excreter1766123ex_creter
excreters1874873ex_creters
execrable2046233execrable
execrably2344123execrably
execrating2047883execrating
execration1949833execration
execrations2048923execrations
execrative2246043execrative
execute1636783exec_ute_
executed1835503exec_uted
executer1745313exec_uter
executers1854183exec_uters
exedrae1544713exedra_e_
exegetes1655313exe_getes
exenterates1885373exenterates
exercises1846463exercises
exergues1644123exe_rgues
exerted152210053exe_r_ted
exerts133712293exe_r_t_s
exocrines1845483exocrines
exonerates17107343exonerates
expectorates2353003expectorates
expiates17810213ex_piates
expurgates2043523expurgates
exsiccates2142803exsiccates
extenuates1744473extenuates
extirpates1943683extirpates
extubates1844843extubates
exuberates1945283exuberates
exudates1636623ex_udates
exuviates1945373exuviates
federates13310153fede_rates
ferrates113013423_ferrates
generates10312713gene_rates
iterates81317823ite_rates
lacerates112413783lacerates
macerates132113573macerates
obsecrates1444583obsecrates
operates10515413ope_rates
overrates12414623overrates
pectates122213953_pectates
penetrates1248723penetrates
picrates122013213_picrates
recrate92621663_recrate_
recrated112918603_recrated
recreates11313363_recreates
redecorates1465683redecorates
regrates92618403_regrates
secretes10410473_secretes
serrates82617023_serrates
speciates13229233speciates
spectates13228813spectates
stearates939453stearates
ulcerates1148853ulcerates
uncrates10314563_uncrates
venerates12312263vene_rates

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411097.26620457.1
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.73223110.6
 
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.