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 “benzocaines” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

30 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
benzocaines245208(None) 
benzocaine2352151benzocaine_
benzidines2242703benz_idines
benzines1938213benz___ines
benzoates2044093benzo_a_tes
benzoins1945573benzo__in_s
endocrines1365523_endocrines
bengalines1344804ben_galines
bentonites1245304bento_nites
benzenes1946854benz___enes
benzidine2143234benz_idine_
benzidins2142724benz_idin_s
benzine1839344benz___ine_
benzins1838694benz___in_s
benzoate1944884benzo_a_te_
benzoin1846264benzo__in__
benzoles1936994benzo___les
betaines10313294be___taines
cocaines121314444___cocaines
endocrine1246184_endocrine_
eucaines1038514_e__ucaines
exocrines1845484_e_xocrines
genocides1345004gen_oc_ides
lidocaines1352864_lidocaines
monoclines1446814mon_oclines
novocaines1552584_novocaines
pentazocines2551864pentazoc_ines
phenacaines1853524phen_acaines
procaines13311524__procaines
tetracaines1354094tetracaines

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 Filter1786911488190.420425454.8
2DLD Change Limit148819308.50017508.1
3Display Results30300.0161875.0
 (SQL Overall)178691308.93619996.8
 
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.