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

152 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
hydric1522795(None) 
hydria13227901hydria
hydrid14248971hydrid
dihydric1842802dihydric
herdic123112302herdic
hybrid15237812hybrid
hybris14247002hybris
hydra12249222hydr_a
hydrae13258572hydrae
hydras13239312hydras
hydriae14246902hydriae
hydride15257502hydride
hydrids15267232hydrids
hydro12259422hydr_o
hydroid1539712hydroid
hydronic1748092hydronic
hydropic1947272hydropic
hydros13279362hydros
hyenic1438722hyenic
hypnic1637262hypnic
lyric104512722ly_ric
pyric123815072py_ric
agaric93513643agaric
aldrin7311243aldrin
anuric8812113anuric
asdic83814093asd_ic
auric74521743_auric
baldric12166403baldric
bardic11312923bardic
baric96125693_baric
bawdric15164583bawdric
bedrid1039943bedrid
boric98024223_boric
cadmic1338983cadmic
capric12411803capric
ceric94023093_ceric
chadri1238143chadri_
chloric143410613chloric
choric133515903choric
chymic18317883chy_mic
chytrid1645733chytrid
citric102812313citric
cleric10612133cleric
cupric1249123cupric
cyanic133110773cyanic
cyclic1238033cyclic
cynic124712423cy_nic
cystic132710653cystic
daric85623123_daric
drib76823263__drib
drip76223953__drip
dyadic1336093dyadic
dysuric1344533dysuric
eldrich1354583eldrich
endrin7312403endrin
eyrie88117833ey_rie
eyrir8359653ey_rir
fabric1337833fabric
ferric1139993ferric
gyri85415153gy_ri_
hadarim13117453hadarim
hadji16839893hadji_
hadjis17439653hadjis
hadron102913753hadron
hadronic1447953hadronic
haemic133210083haemic
haptic13511893haptic
hayrick1944183hayrick
hectic132311523hectic
hedonic1339043hedonic
hemic125718623h_emic
herdics13249523herdics
heroic113516923heroic
hic86540563h___ic
hidrotic1446903hidrotic
hoddin11369943hoddin
holmic1338783holmic
homeric14312213homeric
horrid10311563horrid
houri85915253houri_
houris94514583houris
hubris11218973hubris
huic94818053h__uic
humic124113243h_umic
hyaenic1545993hyaenic
hyalin122210043hyalin
hybrids16236023hybrids
hydatid1546523hydatid
hydracid1844983hydracid
hydrant1489053hydrant
hydrase14287663hydrase
hydrate14239813hydrate
hydraulic1852373hydraulic
hydrides16276943hydrides
hydrilla1543473hydrilla
hydroids1647763hydroids
hydrops16197413hydrops
hydrous14197883hydrous
hydroxy2454263hydroxy
hyoid12612443hy_oid
hypoxic2466283hypoxic
hyrax1838033hy_rax
hysteric1647533hysteric
iatric8312173iatric
indri6310793indri_
indris7311963indris
iodic84816753iod_ic
kyrie123712903ky_rie
lubric1097983lubric
ludic82912803lud_ic
lyrics11357943ly_rics
lytic104513033ly_tic
medic104619653med_ic
metric10314683metric
midrib1138243midrib
myopic15308463myopic
myotic133112313myotic
myrica1336833my_rica
myrrhic1743763myrrhic
mystic132711643mystic
mythic1637273mythic
naric76824173_naric
nitric82512063nitric
nordic939473nordic
odic74920573_od_ic
padri85815173padri_
phylic16279553phy_lic
physic16288473phy_sic
picric12309923picric
pudic104614563pud_ic
pyemic1537893pyemic
pyic116915823py__ic
pyknic1734893pyknic
pyloric1438063pyloric
pyrrhic1744073pyrrhic
pyuria1136953pyuria
quadric1946313quadric
rhodic12227233rhod_ic
rubric1097823rubric
sodic84917493sod_ic
steric8317063steric
syndic1237303syndic
thoric114314043thoric
thymic16307423thy_mic
toric76529313_toric
typic124511963ty_pic
uric63624943__uric
vitric112510113vitric
xeric144315663_xeric
yogic116114933_yogic
yonic105920843_yonic
yttric1145433yttric

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161524.59324540.8
3Display Results1521520.0632412.7
 (SQL Overall)1786911525.03235510.9
 
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.