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

101 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
hydrases1522764(None) 
hydrase14287661hydrase_
hydrates15229411hydrates
gyrases11368312gy_rases
hidroses1237902hidroses
hybrises1645422hybrises
hydrae13258572hydra_e_
hydrants1585792hydrants
hydras13239312hydra__s
hydrastis1644502hydrastis
hydrate14239812hydrate_
hydrated16216952hydrated
hydrides16276942hydrides
hydrolases1746282hydrolases
hydropses1846032hydropses
hyraces1537912hy_races
hyraxes2045702hy_raxes
madrases112610002madrases
mydriases1563082mydriases
apyrases1337243apyrases
arrases71214543_arrases
bedrapes1386963bedrapes
charases131312763charases
crases85532313__crases
cycases1437533cy_cases
cyclases1537133cyclases
cypreses1535143cypreses
cypruses1534313cypruses
dehydrates1844243dehydrates
drakes114715863__drakes
drapes95419653__drapes
druses75517253__druses
erases64425403__erases
eyases94513683ey__ases
gyrase10508773gy_rase_
gyrates113610263gy_rates
harass9313943h_aras_s
harasses11311033h_arasses
hardass1139753hardas_s
hardasses1346453hardasses
headraces1546613headraces
hearses104414533hear_ses
hidrosis1246303hidrosis
horses94729353h_or_ses
hubrises1337103hubrises
hydra12249223hydra___
hydracid1844983hydracid
hydracids1943843hydracids
hydragog1743053hydragog
hydragogs1842983hydragogs
hydrangea1752523hydrangea
hydrangeas1852123hydrangeas
hydrant1489053hydra_nt
hydranth1873893hydranth
hydranths1983163hydranths
hydrastises1852503hydrastises
hydrator1545763hydrator
hydrators1645683hydrators
hydrazides2752823hydrazides
hydrazines2643693hydrazines
hydriae14246903hydriae_
hydride15257503hydride_
hydrids15267233hydr_ids
hydrocasts1954713hydrocasts
hydrogel1644753hydrogel
hydrogels1764333hydrogels
hydrogen1646283hydrogen
hydrogens1746063hydrogens
hydroids1647763hydroids
hydrolase1645883hydrolase_
hydrolyses2045593hydrolyses
hydromel1795353hydromel
hydromels1844793hydromels
hydrops16197413hydr_ops
hydropsies1945943hydropsies
hydros13279363hydr__os
hydrosere1644823hydrosere
hydroseres1745053hydroseres
hydroski1943523hydroski
hydroskis2044133hydroskis
hydrosol1544473hydrosol
hydrosols1644733hydrosols
hydrous14197883hydr_ous
hypnoses1646633hypnoses
judases1534443jud_ases
lyases95211873ly__ases
madrasas11317763madrasas
myases113711553my__ases
mydriasis1552623mydriasis
myiases1235493my_iases
phrases12711463_phrases
prases84429023__prases
rases55447213___rases
rehydrates1744463rehydrates
sucrases10310253sucrases
syngases1245073syngases
terrases82111483terrases
thyrses1335023thy_r_ses
undrapes1138603undrapes
urases63723563__urases
zymases21938333zy_mases

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.436409841.7
2DLD Change Limit1461621016.93621073.0
3Display Results1011010.0333060.6
 (SQL Overall)1786911017.40524131.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.