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

40 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
cocktails174493(None) 
cocktail1645361cocktail_
mocktails1743391mocktails
bucktails1743552bucktails
coattails1144852coattails
cockatiels1842912cockatiels
cocktailed1942742cocktailed
ducktails1652812ducktails
mocktail1643672mocktail_
blacktails1843683blacktails
bobtails1245193bo_btails
bucktail1653913bucktail_
cattails1038553c_attails
coattail1045313coattail_
cocains111313923coc__ains
cocaptains1643863cocaptains
cochairs1545903coc_hairs
cockades1738433cock_ades
cockateels1852343cockateels
cockatiel1744123cockatiel
cockatoos17124443cockatoos
cockbill1844943cock_bill
cockbills1944233cockbills
cockerels1784673cockerels
cockily1838493cock__ily
cockpits1845743cock_pits
cockshies2045173cockshies
cockswains2152603cockswains
cocktailing2052783cocktailing
coistrils1146423coistrils
contains10316533co_ntains
contrails11410543contrails
curtails10318243c_urtails
dovetails1343813dovetails
ducktail1542913ducktail_
foxtails1844583fo_xtails
horntails12124823horntails
oxtails1436383_o_xtails
ponytails1443653ponytails
rockfalls1843183rockfalls

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 Filter1786911486410.420425454.8
2DLD Change Limit148641407.42320024.4
3Display Results40400.0301333.3
 (SQL Overall)178691407.87322696.7
 
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.