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

68 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
butyrate134620(None) 
butylate1345211butylate
butyrates1446081butyrates
butylated1544182butylated
butylates1444712butylates
butyral1245712butyra_l
butyrals1344502butyrals
outrate72323182out_rate
aurate64426473au__rate
automate10411943automate
berate84729023b__erate
biforate1346903biforate
birthrate1445303birthrate
borate85026153b__orate
bullate93415073bu_llate
bunkmate1643963bunkmate
buoyage1344293buoy_age
burgrave1443113burgrave
bursate94111203bu_rsate
busticate1357753busticate
butane8313653but__ane
butte74924293but___te
butylene1344403butylene
butyric1445123butyr_ic
butyrin1245813butyr_in
butyrins1345423butyrins
butyrous1345443butyrous
butyryl1542473butyr_yl
butyryls1641873butyryls
citrate92216803cit_rate
cultrate10310873cultrate
curate85226243cu__rate
deuterate1049513deuterate
fumarate1345683fumarate
guttate8328903gut_tate
gyrate104912523__gyrate
iterate71119113_iterate
literate81216893literate
lustrate8310443lustrate
lyrate94112103__lyrate
maturate10312623maturate
mutate83017483mut__ate
mutilate10312273mutilate
nitrate72017013nit_rate
numerate101610393numerate
nutate63017373nut__ate
obturate1077773obturate
outate62923403out__ate
outbrave1357133outbrave
outdate83016423out_date
outrace92418553out_race
outrage82616893out_rage
outrated92219313out_rated
outrates82421373out_rates
outrave102614413out_rave
outskate12168013outskate
outstate81411993outstate
outtrade938343outtrade
outwrite1139453outwrite
outwrote1137723outwrote
quadrate1888043quadrate
saturate8312813saturate
stylate10179773_stylate
titrate72215573tit_rate
tutorage945743tutorage
uncrate9415953_uncrate
uprate83916543_u_prate
urate55432163_u__rate

Search took 8 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 Filter1786911461620.440406115.9
2DLD Change Limit146162686.93621073.0
3Display Results68680.0302266.7
 (SQL Overall)178691687.40624127.9
 
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.