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

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

79 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
exacerbates2211306(None) 
exacerbate21113371exacerbate_
exacerbated23122711exacerbated
acerbates1347272__acerbates
acerbate1247533__acerbate_
acerbated1465563__acerbated
coacervates1883593coacervates
exacerbating2452353exacerbating
exacerbation2352953exacerbation
exacerbations2452503exacerbations
exaggerates2054133exagger_ates
exasperates2053783exasper_ates
excoriates1946323ex_coriates
execrates1839563exec_r_ates
exonerates17107343exoner_ates
exuberates1945283exuber_ates
lacerates112413783_lacer_ates
macerates132113573_macer_ates
acerate92818914__acer_ate_
acerated113114004__acer_ated
acerbities1444974__acerbities
acervate1336994__acervate_
acetates102013074__ace_tates
acierates11310824__acier_ates
aerates74627504__a_er_ates
ascorbates1444144_ascorbates
cerates95428254___cer_ates
coacervate1763724coacervate_
deaerates10313644dea_er_ates
ejaculates19166444ejac_ulates
elaborates1246324elabor_ates
elaterites1048284elater_ites
elucubrates1552224elucubrates
emaciates1347884emac__iates
emeerates1149374e_meer_ates
enervates1248734e__nervates
enumerates12126744enumer_ates
evacuates14256804evac__uates
evaporates1545464evapor_ates
eviscerates1652854eviscer_ates
exabytes2043614exa___bytes
exaggerate1954334exagger_ate_
exaggerated2153774exagger_ated
exahertzes2991814exaher_tzes
exarchates2243964exa_rchates
exasperate1954024exasper_ate_
exasperated2153324exasper_ated
excavates2144684ex_c_avates
excerpted2153884ex_cer_pted
excerpter2063904ex_cer_pter
excerpters2143184ex_cer_pters
excerpts1943744ex_cer_pt_s
excoriate1846884ex_coriate_
excoriated2045324ex_coriated
excretes1787574ex_c_r_etes
exculpates2144124ex_culpates
execrate1739654exec_r_ate_
execrated1938354exec_r_ated
exenterates1885384exenter_ates
exonerate16107734exoner_ate_
exonerated18106004exoner_ated
expatriates2053544expatriates
expurgates2043524ex_purgates
extenuates1744474ex_tenuates
extirpates1943684ex_tirpates
extubates1844844ex__tubates
exuberate1845624exuber_ate_
exuberated2044494exuber_ated
faceplates1744614_faceplates
lacerate102214714_lacer_ate_
lacerated122210694_lacer_ated
macerate122314074_macer_ate_
macerated142010534_macer_ated
macerater13259524_macer_ater
maceraters14226634_macer_aters
makebates1744974_make_bates
racemates1348854_race_mates
ulcerates1148854_ulcer_ates
valerates12310544_valer_ates

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit148819799.00316529.9
3Display Results79790.0461717.4
 (SQL Overall)178691799.48518839.3
 
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.