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

41 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
benzoyls224244(None) 
benzols1836671benzo_ls
benzoyl2143361benzoyl_
benzyls2133671benz_yls
benomyls1542982benomyls
benzoins1945572benzoins
benzol1756992benzo_l_
benzole1837132benzo_le
benzoles1936992benzoles
benzyl2034162benz_yl_
bedrolls1144673bedrolls
befools1236433be_fools
befouls1236053be_fouls
behowls1534443be_howls
benadryls1561443benadryls
bendays13327513benday_s
bendys12518383ben_dy_s
benomyl1443453benomyl_
bentos86218303bento__s
benzal1739643benz_al_
benzenes1946853benzenes
benzines1938213benzines
benzins1838693benz_ins
benzoate1944883benzoate
benzoates2044093benzoates
benzoic2045033benzo_ic
benzoin1846263benzo_in
benzylic2442283benz_ylic
beryls11107883be__ryls
bezels173712283be_z_els
bezils1711310603be_z_ils
bezoars1836793be_zoars
enjoys1644603_enjoy_s
enols54718403_en_o_ls
enrolls7108093_enrolls
enrols61213383_enro_ls
ensouls736033_ensouls
entoils7810733_entoils
envoys1255143_envoy_s
enzyms2063433_enz_yms
pentyls1236523pen_tyls

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.406440125.6
2DLD Change Limit146162417.37319824.0
3Display Results41410.0162562.5
 (SQL Overall)178691417.79522923.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.