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

34 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
acetylate144421(None) 
acetylated1643161acetylated
acetylates1543851acetylates
acetate92514752acet__ate
acetylative1952522acetylative
acetylene1452692acetylene
acrylate1347692ac_rylate
acylate12310532ac__ylate
acerate92818913ace__rate
acerbate1247533ace_rbate
acervate1336983ace_rvate
acetated112010683acet__ated
acetates102013063acet__ates
acetyl11396553acetyl___
acetylating1753283acetylating
acetylation1643783acetylation
acetylenes1552853acetylenes
acetylic1543573acetyl_ic
acetyls12285353acetyl__s
aciculate132510803aciculate
acidulate12256893acidulate
acrylates1446683ac_rylates
activate13510373ac_tivate
actuate9311443ac_t_uate
acylated1437873ac__ylated
acylates1339743ac__ylates
alkylate1554663a_lkylate
areolate81014453are_olate
butylate1345213_butylate
ethylate1446223__ethylate
faceplate1645223face_plate
methylate1745683_methylate
ocellate1037873oce_llate
stylate10179773__stylate

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.406440125.6
2DLD Change Limit148641346.25023782.6
3Display Results34340.000 
 (SQL Overall)178691346.65626846.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.