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

116 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
hydroid153971(None) 
hydrid14248971hydr_id
hydroids1647761hydroids
android9311512android
droid74218542__droid
hyaloid1439072hyaloid
hybrid15237812hybr_id
hydatid1546522hydatid
hydracid1844982hydracid
hydria13227902hydr_ia
hydric15227952hydr_ic
hydride15257502hydr_ide
hydrids15267232hydr_ids
hydro12259422hydro__
hydronic1748092hydronic
hydropic1947272hydropic
hydrops16197412hydrops
hydros13279362hydro_s
hydrous14197882hydrous
hydroxide2445392hydroxide
hydroxy2454262hydroxy
hyenoid1448612hyenoid
hyoid12612442hy__oid
hypnoid1647882hypnoid
thyroid1438252thy_roid
acaroid103512313acaroid
adroit7518793_adroit
ambroid1238883ambroid
androids1047753androids
aneroid8314003aneroid
aroid65428343__aroid
bedrid1039943bedr_id
byroad1236623by_road
choroid13311803choroid
chytrid1645733chytr_id
cycloid1539283cycloid
cymoid1459473cy_moid
cystoid13309213cystoid
dendroid1145923dendroid
droids84712583__droids
droit65127123__droit
druid74111323__druid
elytroid1244963elytroid
emeroid101511183emeroid
fibroid1337243fibroid
gadoid9310463gad_oid
hadron102913753hadro_n
hadronic1447953hadronic
hadrons113314303hadrons
haemoid1337203haemoid
haloid104317763h_aloid
haploid1339833haploid
hemoid12313513h_emoid
heroic113516923h_eroic
heroin94420593h_eroin
hidrosis1246303hidrosis
hidrotic1446903hidrotic
histoid1139823histoid
horrid10311563h_orrid
hotrod1048803hotro_d
hyaloids1545993hyaloids
hybrids16236023hybr_ids
hybris14247003hybr_is
hydatids1643833hydatids
hydra12249223hydr__a
hydracids1943843hydracids
hydrae13258573hydr_ae
hydrant1489053hydrant
hydras13239313hydr_as
hydrase14287663hydrase
hydrate14239813hydrate
hydrated16216953hydrated
hydrazide2653123hydrazide
hydriae14246903hydriae
hydrides16276943hydr_ides
hydrofoil1953783hydrofoil
hydrogel1644753hydrogel
hydrogen1646283hydrogen
hydromel1795353hydromel
hydronium1844953hydronium
hydropsy20184153hydropsy
hydroski1943523hydroski
hydroskis2044133hydroskis
hydrosol1544473hydrosol
hydroxides2544893hydroxides
hydroxyl2543883hydroxyl
hyoids1377673hy__oids
hypoed1547923hy_poed
hyracoid1745973hyracoid
hysteroid1645893hysteroid
labroid1038823labroid
myeloid13108123myeloid
myoid11512993my__oid
myxoid1936883my_xoid
negroid9108893negroid
neuroid81110303neuroid
ochroid1357903ochroid
oidioid946053oidioid
phylloid1746193phylloid
phytoid1678753phy_toid
pygmoid1644533pygmoid
pyoid11513763py__oid
sparoid102311543sparoid
spiroid10219823spiroid
sporoid102310733sporoid
steroid81314863steroid
theroid11313403theroid
thyreoid1544773thyreoid
thyroids1546003thy_roids
thyrsoid1544193thyrsoid
toroid7416013_toroid
typhoid1648133typhoid
viroid10411523_viroid
xyloid1738193xy_loid
zebroid1936463zebroid
zygoid2045943zy_goid

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 Limit1340271167.12618808.2
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.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.