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

119 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
hydria1322790(None) 
hydra12249221hydr_a
hydriae14246901hydriae
hydric15227951hydric
hydrid14248971hydrid
hybrid15237812hybrid
hybris14247002hybris
hydrae13258572hydrae
hydras13239312hydras
hydride15257502hydride
hydrids15267232hydrids
hydrilla1543472hydrilla
hydro12259422hydr_o
hydroid1539712hydroid
hydros13279362hydros
pyuria1136952pyuria
agria65517143_agria
aldrin7311243aldrin
anuria6313123anuria
aporia8315863aporia
aria46245423__aria
atria56022343_atria
bedrid1039943bedrid
cardia9916373cardia
ceria75125353_ceria
chadri1238143chadri_
chytrid1645733chytrid
codeia94112193codeia
coria75828323_coria
curia74523773_curia
cyprian1445343cyprian
dihydric1842803dihydric
drib76823263__drib
drip76223953__drip
dysuria1144923dysuria
endrin7312403endrin
eyra76217553ey_r_a
eyrie88117833ey_rie
eyrir8359653ey_rir
feria85922713_feria
gloria71910543gloria
gyri85415153gy_ri_
hadarim13117453hadarim
hadji16839893hadji_
hadjis17439653hadjis
hadron102913753hadron
hegira1036523hegira
hejira1644803hejira
herdic123112303herdic
herma105318883h_erma
hernia9312293hernia
hijra1535643hijr_a
hoddin11369943hoddin
hora76136563h_or_a
horrid10311563horrid
houri85915253houri_
houris94514583houris
hryvnia1641643hryvnia
hubris11218973hubris
hyaena1235363hyaena
hyalin122210043hyalin
hybrids16236023hybrids
hydatid1546523hydatid
hydracid1844983hydracid
hydrant1489053hydrant
hydrase14287663hydrase
hydrate14239813hydrate
hydrides16276943hydrides
hydrillas1643443hydrillas
hydroids1647763hydroids
hydronic1748093hydronic
hydropic1947273hydropic
hydrops16197413hydrops
hydrous14197883hydrous
hydroxy2454263hydroxy
hyena11810253hy_ena
hyenic1438723hyenic
hyla106716513hy__la
hymenia1546393hymenia
hyoid12612443hy_oid
hypha1637383hy_pha
hypnic1637263hypnic
hypoxia2246373hypoxia
hyrax1838033hy_rax
hysteria1447393hysteria
indri6310793indri_
indris7311963indris
kerria10339913kerria
kyrie123712903ky_rie
latria62313593latria
lycra10317973lycr_a
lyric104512723ly_ric
maria75032883_maria
media84721713med_ia
midrib1138243midrib
mudra83912433mudr_a
myopia13318443myopia
myriad1235913my_riad
myrica1336833my_rica
noria55722183_noria
nutria639913nutria
oidia6314953oid_ia
padri85815173padri_
podia8415283pod_ia
pyemia1337553pyemia
pyric123815073py_ric
pyurias1236713pyurias
redia65524483red_ia
ria36745503___ria
scoria8513503scoria
sharia93116733sharia
stria55723213_stria
sudaria847973sudaria
thoria93012893thoria
varia85824203_varia
yerba101010763_yerba
yttria954803yttria
yurta86014253_yurta
zoaria1548383zoaria

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.1401276364.3
2DLD Change Limit1127161195.71619719.4
3Display Results1191190.0462587.0
 (SQL Overall)1786911195.90230276.3
 
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.