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

121 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
hydrous1419788(None) 
hydrops16197411hydrops
hydros13279361hydro_s
anhydrous1652712anhydrous
hadrons113314302hadrons
hideous1168432hideous
hydras13239312hydr_as
hydrids15267232hydrids
hydro12259422hydro__
hydroid1539712hydroid
hydroids1647762hydroids
hydropsy20184152hydropsy
hydroxy2454262hydroxy
acerous9513333acerous
amorous9311133amorous
andros7313303andro_s
anurous7311553anurous
arduous837613arduous
aurous64119263_aurous
cerous85821203_cerous
chlorous1339223chlorous
chylous15107273chy_lous
chymous1775703chy_mous
cirrous93111063cirrous
citrous93112993citrous
cuprous1149743cuprous
cymous1388403cy_mous
cyprus1335363cypr_us
drops85719503__drops
dross65418093__dross
drouk1039433__drouk
drouks1137123__drouks
elytrous1145503elytrous
estrous7712533estrous
eyedrops1443163eyedrops
ferrous1049793ferrous
fibrous1237593fibrous
gyrons105511223gy_rons
gyros95616483gy_ro_s
gyrus95310803gy_r_us
hadron102913753hadro_n
harrows132611033harrows
heinous1038853heinous
heroes94923823h_eroes
herons94820543h_erons
heros84930863h_ero_s
hideout1179793hideout
hideouts1285573hideouts
hidroses1237903hidroses
hidrosis1246303hidrosis
horrors1078693horrors
hotrods1148283hotrods
hugeous1137133hugeous
humorous1346443humorous
hybrids16236023hybrids
hybris14247003hybr_is
hydra12249223hydr__a
hydrae13258573hydr_ae
hydragogs1842983hydragogs
hydrant1489053hydrant
hydrants1585793hydrants
hydrase14287663hydrase
hydrases15227643hydrases
hydrate14239813hydrate
hydrates15229403hydrates
hydrators1645683hydrators
hydria13227903hydr_ia
hydriae14246903hydriae
hydric15227953hydr_ic
hydrid14248973hydr_id
hydride15257503hydride
hydrides16276943hydrides
hydrocast1845803hydrocast
hydrogel1644753hydrogel
hydrogels1764333hydrogels
hydrogen1646283hydrogen
hydrogens1746063hydrogens
hydrolase1645883hydrolase
hydromel1795353hydromel
hydromels1844793hydromels
hydronic1748093hydronic
hydronium1844953hydronium
hydroniums1954013hydroniums
hydropic1947273hydropic
hydropses1846023hydropses
hydroski1943523hydroski
hydroskis2044133hydroskis
hydrosol1544473hydrosol
hydrosols1644733hydrosols
hydroxyl2543883hydroxyl
hydroxyls2664203hydroxyls
hyperons1649203hyperons
hypos1312014743hy_po_s
hysons1237633hy_sons
hyssops1543123hyssops
iodous7311503iod_ous
ladrons83813193ladrons
leprous938843leprous
nitrous73512483nitrous
nodous7711333nod_ous
ochrous1237943ochrous
odious749933_odious
odorous837663odorous
onerous7312973onerous
ordurous944753ordurous
parous84024163_parous
pedros9312183pedro_s
petrous92714423petrous
porous84419483_porous
pylorus1235333pylorus
pyros105718293py_ro_s
pyrrols1235403pyrrols
serous65023563_serous
tedious838443tedious
thyrsus1342693thy_rsus
torous64319033_torous
typhous1566323typhous
tyros85118593ty_ro_s
vodous1038603vod_ous
wondrous1246823wondrous
yous76230653_y__ous

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.1561145455.1
2DLD Change Limit1340271217.12618808.2
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.32824384.7
 
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.