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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
methyls153545(None) 
ethyls1235901_ethyls
methyl1436401methyl_
bethels1238532bethels
bimethyls1951712bimethyls
dimethyls1851602dimethyls
ethyl1136512_ethyl_
lethals1038112lethals
menthols1347042menthols
metals84520892met_als
methods1338892methods
meths105320232meth__s
methylal1644272methylal
methylals1743682methylals
methylase1744242methylase
methylic1846012methylic
metols84115772met_ols
tetryls1034642tetryls
acetyls12285353acet_yls
aethers103614943aethers
alphyls15113953alphyls
amethyst1642303amethyst
amethysts1751623amethysts
anethols1145843anethols
benzyls2133673benzyls
beryls11107883be_ryls
betels84515063bet_els
bethel1169643bethel_
beths105519223beth__s
bimethyl1841853bimethyl_
butyls1176753but_yls
details84214043details
dimethyl1741913dimethyl_
ethers94518413_ethers
ethics11169283_ethics
ethinyls1442873_ethinyls
ethnos947053_ethnos
ethos85514193_eth_os
ethoxyls2142213_ethoxyls
eths76619523_eth__s
ethylic1546323_ethylic
ethyne12407153_ethyne
ethynes13377573_ethynes
ethynyls1741873_ethynyls
fetials103711743fetials
heths116317783heth__s
hexyls1933443he_xyls
ketols104210763ket_ols
lethal939803lethal_
lethes94818083leth_es
mateys115610943matey_s
maths105624023math__s
meals75933383me__als
medals94218063me_dals
medials103914743medials
mells75031333me__lls
mels65941533me___ls
menhirs1235913menhirs
menials94015693menials
menthol1236733menthol_
merls77423903me__rls
mescals112911573mescals
meshes115019443mesh_es
meshy135612783meshy__
mesophyls1954693mesophyls
metages102714973metages
metal75427383met_al_
metates92720013metates
meteors94610013meteors
metepas1136303metepas
meters85625833met_ers
metes74736213met__es
meth95827843meth___
methane123211793methane
methanes133812163methanes
methanols1444873methanols
methinks1775193methinks
method1239033meth_od
methoxy2243953methoxy
methoxyl2342743methoxyl_
methylases1844273methylases
methylate1745683methylate
methylates1845483methylates
methylene1754773methylene
methylenes1854603methylenes
meticals12310763meticals
metiers93312843metiers
metis75025903met__is
metol75917813met_ol_
metonyms1545323metonyms
metopes11311363metopes
metres85121563met_res
metrics11312363metrics
metros84217803met_ros
mettle83815723met_tle
mettles94115023mettles
metumps1334133metumps
mewls105813233me__wls
mezcals20246543mezcals
mithers123516733mithers
moghuls1343623moghuls
mohels115011333m_ohels
motels83616903mot_els
mothers123717623mothers
moths106021553moth__s
mothy136214553mothy__
mughals1355763mughals
mutuals937133mutuals
mutuels935943mutuels
mythos14398473myth_os
myths135911603myth__s
mythy16568673mythy__
octyls11135323oct_yls
pentyls1236523pentyls
petals84719813pet_als
petrels9279373petrels
petrols92913083petrols
retails74718973retails
retells73211523retells
retools73411023retools
tethers103815313tethers
teths85418513teth__s
tetryl935693tetryl_
wethers135214693wethers
zephyrs2441943zephyrs

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271257.15618729.3
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.62223444.1
 
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.