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
acerbates134727(None) 
acerbate1247531acerbate_
acerbated1465561acerbated
acerate92818912acer_ate_
acerated113114002acer_ated
acerbities1444972acerbities
acervate1336992acervate_
acetates102013072ace_tates
acierates11310822acier_ates
aerates74627502a_er_ates
ascorbates1444142ascorbates
cerates95428252_cer_ates
exacerbates22113062exacerbates
lacerates112413782lacer_ates
macerates132113572macer_ates
abates85825043a___bates
aberrated1245893aberrated
acarboses1345083acarboses
acariases1146623acariases
accretes1238133accr_etes
acerbating1546293acerbating
acerber1135253acerb__er
acerbest1245463acerb__est
acerbity1544273acerbit_y
acetate92514753ace_tate_
acetated112010693ace_tated
acetylates1543853acetylates
acierate10311813acier_ate_
acierated1238303acier_ated
acreages1138383ac_reages
acrobats1258353acrobat_s
acrylates1446693acrylates
activates1449693activates
actuates10310313ac_tuates
acylates1339743ac_ylates
adsorbates1342833adsorbates
aerate64830553a_er_ate_
aerated85322383a_er_ated
aerobats1049853a_erobat_s
agemates111110033age_mates
airdates939733a_irdates
altercates1247573altercates
alternates1047893alternates
ameerates1149073ameerates
amirates101114803amir_ates
approbates1645863approbates
arbutes939703a__rbutes
ascorbate1344463ascorbate_
asperates11312563asper_ates
averages1249183aver_ages
berates94126883_ber_ates
carates95630613_car_ates
celibates1358633_celibates
cerastes101111093_cerastes
cerate84829463_cer_ate_
cerated103922473_cer_ated
cerebrates1447923_cerebrates
cerites94823433_cer_ites
certes84623083_cer__tes
coacervates1883593coacervates
crates85736063_c_r_ates
creates95225213_c_reates
cremates124216013_cremates
curates95323833_cur_ates
debates103718533_de_bates
derates84028893_der_ates
enervates1248733enervates
ergates8314493__ergates
exacerbate21113373exacerbate_
exacerbated23122713exacerbated
faceplates1744613faceplates
ferrates113013423_ferrates
herbages1437103_herbages
iterates81317823iter_ates
lacerate102214713lacer_ate_
lacerated122210693lacer_ated
macerate122314073macer_ate_
macerated142010533macer_ated
macerater13259523macer_ater
maceraters14226633macer_aters
makebates1744973make_bates
operates10515413oper_ates
overbakes18129133overbakes
overbites14310983overbites
overhates15311943overhates
overrates12414623overrates
racemates1348853race_mates
rebates95123193_re_bates
recrates102420383recr_ates
recreates11313373recreates
seriates82620683_seriates
serrates82617023_serrates
sorbates10311103_sorbates
ulcerates1148853ulcer_ates
valerates12310543valer_ates

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 Limit148641957.64019455.6
3Display Results95950.0332878.8
 (SQL Overall)178691958.09322079.7
 
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.