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

95 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
acerbates134726(None) 
acerbate1247531acerbate_
acerbated1465551acerbated
acerate92818912acer_ate_
acerated113113982acer_ated
acerbities1444972acerbities
acervate1336982acervate_
acetates102013062ace_tates
acierates11310812acier_ates
aerates74627492a_er_ates
ascorbates1444142ascorbates
cerates95428252_cer_ates
exacerbates22113062exacerbates
lacerates112413772lacer_ates
macerates132113572macer_ates
abates85825033a___bates
aberrated1245873aberrated
acarboses1345083acarboses
acariases1146613acariases
accretes1238113accr_etes
acerbating1546283acerbating
acerber1135243acerb__er
acerbest1245463acerb__est
acerbity1544273acerbit_y
acetate92514753ace_tate_
acetated112010683ace_tated
acetylates1543853acetylates
acierate10311813acier_ate_
acierated1238283acier_ated
acreages1138373ac_reages
acrobats1258343acrobat_s
acrylates1446683acrylates
activates1449683activates
actuates10310313ac_tuates
acylates1339743ac_ylates
adsorbates1342833adsorbates
aerate64830553a_er_ate_
aerated85322373a_er_ated
aerobats1049843a_erobat_s
agemates111110023age_mates
airdates939723a_irdates
altercates1247553altercates
alternates1047873alternates
ameerates1149063ameerates
amirates101114793amir_ates
approbates1645853approbates
arbutes939703a__rbutes
ascorbate1344463ascorbate_
asperates11312553asper_ates
averages1249183aver_ages
berates94126873_ber_ates
carates95630613_car_ates
celibates1358633_celibates
cerastes101111093_cerastes
cerate84829463_cer_ate_
cerated103922473_cer_ated
cerebrates1447913_cerebrates
cerites94823433_cer_ites
certes84623083_cer__tes
coacervates1883593coacervates
crates85736063_c_r_ates
creates95225203_c_reates
cremates124216003_cremates
curates95323833_cur_ates
debates103718533_de_bates
derates84028893_der_ates
enervates1248723enervates
ergates8314493__ergates
exacerbate21113373exacerbate_
exacerbated23122703exacerbated
faceplates1744613faceplates
ferrates113013423_ferrates
herbages1437093_herbages
iterates81317823iter_ates
lacerate102214703lacer_ate_
lacerated122210673lacer_ated
macerate122314073macer_ate_
macerated142010523macer_ated
macerater13259523macer_ater
maceraters14226633macer_aters
makebates1744973make_bates
operates10515413oper_ates
overbakes18129133overbakes
overbites14310983overbites
overhates15311943overhates
overrates12414623overrates
racemates1348853race_mates
rebates95123183_re_bates
recrates102420373recr_ates
recreates11313363recreates
seriates82620673_seriates
serrates82617023_serrates
sorbates10311103_sorbates
ulcerates1148853ulcer_ates
valerates12310543valer_ates

Search took 7 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.466383457.1
2DLD Change Limit148641956.39323250.6
3Display Results95950.0303166.7
 (SQL Overall)178691956.88925938.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.