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

57 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
acrylates144668(None) 
acrylate1347691acrylate_
acylates1339741ac_ylates
acetylates1543852acetylates
acylate12310532ac_ylate_
acylated1437872ac_ylated
alkylates1644702alkylates
ablates92416903a__blates
abrogates12108973abrogates
accolades1445433accolades
acerbates1347263acerbates
acetates102013063ac_etates
acetylate1444213acetylate_
acetylated1643163acetylated
acidulates13215843acidulates
acierates11310813acierates
acolytes13168043ac_olytes
acreages1138373acr_eages
acrobats1258343acrobat_s
acroliths1445113acroliths
acrylamides1952043acrylamides
acrylics1584363acryl_ics
activates1449683activates
actuates10310313ac_tuates
adulates9311913a_dulates
aerates74627493aer__ates
aerolites9312583aerolites
airdates939723air_dates
airplanes1187233airplanes
alates64833973a___lates
alkylate1554663alkylate_
alkylated1753483alkylated
ambulates1348383ambulates
amylases1346663a_mylases
angulates10310863angulates
apholates1449683apholates
arrogates10129423arrogates
butylates1444713butylates
canulates11312873canulates
carates95630613car__ates
chelates132713843_chelates
cholates132414763_cholates
collates103019143_collates
corelates11314863corelates
crates85736063_cr__ates
creates95225203_cr_eates
cremates124216003_cremates
cryolites1446963_cryolites
ethylates1545943ethylates
faceplates1744613faceplates
jaculates182810363jac_ulates
maculates132013723mac_ulates
prelates10418573_prelates
relates73731433__relates
tachylites1843593tachylites
tachylytes2151693tachylytes
vacillates1555723vacillates

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.420425454.8
2DLD Change Limit148641576.12624264.0
3Display Results57570.0301900.0
 (SQL Overall)178691576.57627173.2
 
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.