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 “hydroids” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
hydroids164776(None) 
hydrids15267231hydr_ids
hydroid1539711hydroid_
androids1047752androids
droids84712582__droids
hyaloids1545992hyaloids
hybrids16236022hybr_ids
hydatids1643832hydatids
hydracids1943842hydracids
hydrid14248972hydr_id_
hydride15257502hydr_ide
hydrides16276942hydr_ides
hydrops16197412hydro_ps
hydros13279362hydro__s
hydrous14197882hydro_us
hydroxide2445402hydroxide
hydroxides2544902hydroxides
hyoids1377672hy__oids
thyroids1546002thy_roids
ambroids1346503ambroids
android9311513android_
aneroids9310203aneroids
aroids75118223__aroids
byroads1335293by_roads
choroids1438693choroids
chytrids1744223chytr_ids
cycloids1647043cycloids
cystoids14306733cystoids
droid74218543__droid_
droits74314313__droits
druids8368093__druids
emeroids11147723emeroids
fibroids1445843fibroids
gadoids1036873gad_oids
hadrons113314303hadro_ns
haloids113012553h_aloids
haploids1437363haploids
heroics122912003h_eroics
heroins103518013h_eroins
hidroses1237903hidroses
hidrosis1246303hidrosis
hidrotics1544513hidrotics
hotrods1148283hotro_ds
hyaloid1439073hyaloid_
hybrid15237813hybr_id_
hybris14247003hybr_i_s
hydatid1546523hydatid_
hydracid1844983hydracid_
hydrants1585793hydrants
hydras13239313hydr__as
hydrases15227643hydrases
hydrates15229413hydrates
hydrazide2653123hydrazide
hydrazides2752823hydrazides
hydria13227903hydr_i_a
hydriae14246903hydr_iae
hydric15227953hydr_i_c
hydro12259423hydro___
hydrocast1845803hydrocast
hydrofoils2053513hydrofoils
hydrogel1644753hydrogel
hydrogels1764333hydrogels
hydrogen1646283hydrogen
hydrogens1746063hydrogens
hydrolase1645883hydrolase
hydromel1795353hydromel
hydromels1844793hydromels
hydronic1748093hydronic
hydronium1844953hydronium
hydroniums1954013hydroniums
hydropic1947273hydropic
hydropses1846033hydropses
hydropsies1945943hydropsies
hydropsy20184153hydropsy
hydroski1943523hydroski
hydroskis2044133hydroskis
hydrosol1544473hydrosol
hydrosols1644733hydrosols
hydroxy2454263hydro_xy
hydroxyl2543883hydroxyl
hydroxyls2664213hydroxyls
hyenoid1448613hyenoid_
hyoid12612443hy__oid_
hypnoid1647883hypnoid_
hyracoids1844253hyracoids
labroids1155843labroids
negroids10116323negroids
phylloids1844523phylloids
sparoids11218713sparoids
steroids9911443steroids
thyroid1438253thy_roid_
toroids8310643_toroids
typhoids1745493typhoids
viroids1137923_viroids

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.453394461.4
2DLD Change Limit146162947.18620339.8
3Display Results94940.0462043.5
 (SQL Overall)178691947.68523251.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.