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

138 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
macerates13211357(None) 
lacerates112413771lacerates
macerate122314071macerate_
macerated142010521macerated
macerater13259521macerater
maceraters14226631maceraters
acerate92818912_acerate_
acerated113113982_acerated
acerbates1347262_acerbates
acetates102013062_acetates
acierates11310812_acierates
aerates74627492_a_erates
ameerates1149062ameerates
cerates95428252__cerates
lacerate102214702lacerate_
lacerated122210672lacerated
macerator13217632macerator
macerators14167482macerators
macrames1438952mac_rames
maculates132013722maculates
makebates1744972makebates
maleates103316342male_ates
maturates11311762maturates
moderates12710752moderates
racemates1348852racemates
ulcerates1148852ulcerates
valerates12310542valerates
accretes1238113_accretes
acerbate1247533_acerbate_
acerbated1465553_acerbated
acervate1336983_acervate_
acetate92514753_acetate_
acetated112010683_acetated
acierate10311813_acierate_
acierated1238283_acierated
acreages1138373_acreages
actuates10310313_actuates
acylates1339743_acylates
aerate64830553_a_erate_
aerated85322373_a_erated
agemates111110023_agemates
ameerate1039633ameerate_
amirates101114793_amirates
amperages1447683amperages
asperates11312553asperates
averages1249183_averages
backdates1848153backdates
berates94126873__berates
carates95630613__carates
caseates10313713case_ates
casemates1349523casemates
castrates11312673castrates
catenates11311813catenates
cerastes101111093__cerastes
cerate84829463__cerate_
cerated103922473__cerated
cerites94823433__cerites
certes84623083__cer_tes
coacervates1883593coacervates
cocreates132611883cocreates
crates85736063__c_rates
creates95225203__creates
curates95323833__curates
deaerates10313643deaerates
decorates12314743decorates
derates84028893__derates
emaciates1347883emac_iates
emeerates1149373emeerates
exacerbates22113063exacerbates
execrates1839563execrates
faceplates1744613faceplates
federates13310153federates
generates10312713generates
iterates81317823_iterates
jaculates182810363jaculates
karates115617473ka__rates
lactates10311223lac_tates
laterites9715053laterites
laureates987683laureates
layerages1345303layerages
liberates111012943liberates
literates91415653literates
macerating1549533macerating
maceration1449613maceration
macerations1548473macerations
macers105321273macer___s
machetes1539633mac_hetes
machinates1747323machinates
machrees1545503machr_ees
macrame1338713mac_rame_
maculate122815623maculate_
maculated142411503maculated
maderizes2148953maderizes
madrases112610003ma_drases
maenades1137473ma_enades
magnates11511613ma_gnates
makebate1645063makebate_
malates93522603ma__lates
maleate94117543male_ate_
malemutes1344453malemutes
mandates11314093ma_ndates
mandrakes1646353mandrakes
margraves1544833margraves
marinates112516383marinates
matelotes1146333matelotes
maturate10312613maturate_
maturated1249163maturated
mercurates1446853mercurates
metates92720013m__etates
meterages1248183meterages
micturates1456093micturates
migrates111112853m_igrates
miscreates1448103miscreates
misrates101318243m_isrates
moderate11710993moderate_
moderated1388143moderated
moderatos1286523moderatos
muckrakes1642743muckrakes
narrates8312763na_rrates
numerates11199573numerates
operates10515413_operates
picrates122013213pic_rates
racemate1239063racemate_
recrates102420373rec_rates
recreates11313363recreates
saleratus944813saleratus
saturates9811603saturates
tartrates979563tartrates
tolerates9312123tolerates
ulcerate1039733ulcerate_
ulcerated1247743ulcerated
uncrates10314563unc_rates
uncreates11310433uncreates
vacates12312833vac__ates
valerate11311473valerate_
venerates12312263venerates
vicarates1487623vicarates
waterages1349383waterages

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411387.59319576.1
3Display Results1381380.0463000.0
 (SQL Overall)1786911388.05922172.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.