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

112 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
execrate173965(None) 
execrated1938351execrated
execrates1839561execrates
desecrate1249082desecrate
emeerate10410102emeerate
excrete1667162ex_crete
execrable2046232execrable
execrative2246042execrative
execrator1846562execrator
execute1636782exec_ute
exedrae1544712exedra_e
recrate92621662_recrate
acerate92818913ace_rate
aerate64830553_ae_rate
ameerate1039633ameerate
berate84729023_be_rate
celebrate1348083celebrate
cerate84829463_ce_rate
cerebrate1348653cerebrate
crate76537403___crate
deaerate9314173deae_rate
decorate11315193_decorate
defecate1438793defec_ate
delectate1248743delectate
derate74531233_de_rate
desecrated1447953desecrated
desecrater1346983desecrater
desecrates1348843desecrates
ecarte84313503__ecarte
edentate947703edentate
educate10310213educ_ate
electorate1247583electorate
elevate101110373ele_vate
emaciate1248753emaciate
emeerates1149373emeerates
emendate1146763emendate
emigrate1149603emigrate
emirate91015833e_mirate
enervate1148453enervate
ephorate1359503ephorate
eructate1047333eructate
eucrite939903e_ucrite
evacuate13217303evacuate
exacerbate21113373exacerbate
exarchate2144453exarchate
excavate2045053excavate
excerpt1845943excerpt_
excerpted2153873excerpted
excerpter2063903excerpter
excerpts1943743excerpts
excite15310883ex_c_ite
exclave1945193ex_clave
excoriate1846883excoriate
excreta1674623ex_creta
excreted1846153ex_creted
excreter1766123ex_creter
excretes1787573ex_cretes
execrably2344123execrably
execrating2047883execrating
execration1949833execration
execrators1946023execrators
executed1835503exec_uted
executer1745313exec_uter
executes1736533exec_utes
exedra1434503exedra__
exegete1545773exe_gete
exenterate1795683exenterate
exercise1747063exercise
exergue1544193exe_rgue
exert124624143exe_r_t_
exerted152210053exe_r_ted
exerts133712293exe_r_ts
exhedrae1943343exhedra_e
exocrine1745993exocrine
exonerate16107733exonerate
expectorate2253303expectorate
expiate16910593ex_piate
expurgate1943823expurgate
exsiccate2043143exsiccate
extenuate1645003extenuate
extirpate1844023extirpate
extubate1745103extubate
exuberate1845623exuberate
exudate1537093ex_udate
exuviate1846063exuviate
federate12310883fede_rate
ferrate103014043_ferrate
generate9312903gene_rate
iterate71119113ite_rate
lacerate102214703lacerate
macerate122314073macerate
obsecrate1344633obsecrate
operate9615733ope_rate
overate10620963ove_rate
overrate11615693overrate
pectate112214693_pectate
penetrate1149233penetrate
picrate112014143_picrate
recrated112918603_recrated
recrates102420373_recrates
recreate10313603_recreate
redecorate1346133redecorate
regrate82618663_regrate
secrete9311073_secrete
serrate73017543_serrate
speciate12209583speciate
spectate12248833spectate
stearate839723stearate
thecate123210023thec_ate
ulcerate1039733ulcerate
uncrate9415953_uncrate
venerate11312903vene_rate

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621127.00020880.3
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.45223978.9
 
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.