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

55 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
anethol104538(None) 
anethole1146251anethole
anethols1145841anethols
anetholes1246672anetholes
menthol1236732menthol
abettal946073abettal
abettor956203abettor
acetal84314903acet_al
acetyl11396553acet_yl
aether94213673a_ether
alcohol1244373alcohol
altho86312603a_ltho_
amatol838693amat_ol
anaphor1245653anaphor
anatto6139913anatto_
anattos7138453anattos
ancho104515303an_cho_
anchor113911973an_chor
anchos114214893an_chos
anechoic1545373anechoic
another10289153another
anthem113410343an_them
anther93715063an_ther
anthill1048203an_thill
anthoid11313313an_thoid
antral65719413an_tral
anyhow1544103an_yhow
author939763a_uthor
benthal1247963benthal
benthon1237693benthon
benthos1238373benthos
bethel1169643_bethel
canephor1543873canephor
canthal12410053can_thal
catechol1544613catechol
ethos85514193__ethos
ethyl1136513__ethyl
gnathal1144353gnathal
ketol95414003_ket_ol
kneehole15103353kneehole
knothole1544073knothole
lethal939803_lethal
menthols1347043menthols
method1239033_method
methyl1436403_methyl
metol75917813_met_ol
naphthol1662403naphthol
naphtol12124023naphtol
nerol51017813_ne_rol
nether94014163_nether
netop7312343_net_op
petrol82714063_petrol
retool63914483_retool
santol64515243san_t_ol
unlethal1143633unlethal

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 Filter1786911340270.406440125.6
2DLD Change Limit134027556.15621771.8
3Display Results55550.0301833.3
 (SQL Overall)178691556.59227107.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.