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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
acerbated146555(None) 
acerated113113981acer_ated
acerbate1247531acerbate_
acerbates1347261acerbates
aberrated1245872aberrated
acerate92818912acer_ate_
acervate1336982acervate_
acetated112010682ace_tated
acierated1238282acier_ated
aerated85322372a_er_ated
cerated103922472_cer_ated
exacerbated23122702exacerbated
lacerated122210672lacer_ated
macerated142010522macer_ated
abated95918453a___bated
accreted1336333accr_eted
acerbating1546283acerbating
acerber1135243acerb__er
acerbities1444973acerbities
acerbity1544273acerbit_y
acetate92514753ace_tate_
acetates102013063ace_tates
acetylated1643163acetylated
acierate10311813acier_ate_
acierates11310813acier_ates
activated1567883activated
actuated1138743ac_tuated
aculeated1247723aculeated
acylated1437873ac_ylated
aerate64830553a_er_ate_
aerates74627493a_er_ates
alerted82512223aler__ted
altercated1345453altercated
alternated1145723alternated
approbated1744763approbated
areolated1089713areolated
ascorbate1344463ascorbate_
ascorbates1444143ascorbates
asperated1239313asper_ated
asteriated1177993asteriated
aurated83817793a_ur_ated
averaged1356213aver_aged
averted112211613aver__ted
berated104422133_ber_ated
cerate84829463_cer_ate_
cerates95428253_cer_ates
cerebrated1546343_cerebrated
combated1539823_combated
crated94827773_c_r_ated
created104323453_c_reated
cremated133412963_cremated
crenated113013913_crenated
curated104717583_cur_ated
debated113916083_de_bated
derated93623503_der_ated
enervated1347313enervated
exacerbate21113373exacerbate_
exacerbates22113063exacerbates
herbaged1554523_herbaged
iterated91213823iter_ated
lacerate102214703lacer_ate_
lacerates112413773lacer_ates
macerate122314073macer_ate_
macerater13259523macer_ater
macerates132113573macer_ates
ocellated1245453ocellated
operated11512223oper_ated
overbaked19127833overbaked
overhated16610443overhated
overrated13313083overrated
rebated103619703_re_bated
recrated112918603recr_ated
recreated12412533recreated
seriated92717023_seriated
serrated92513433_serrated
ulcerated1247743ulcer_ated

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.423422437.4
2DLD Change Limit148641766.79621871.8
3Display Results76760.0302533.3
 (SQL Overall)178691767.24924650.4
 
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.