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

101 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
hydrides1627694(None) 
hydride15257501hydride_
hydrids15267231hydrid_s
anhydrides1872022anhydrides
hagrides1337622hagrides
hayrides1536882hayrides
hybrids16236022hybrid_s
hybrises1645422hybrises
hydrases15227642hydrases
hydrates15229412hydrates
hydrazides2752822hydrazides
hydriae14246902hydriae_
hydrid14248972hydrid__
hydroids1647762hydroid_s
hydroxides2544902hydroxides
anhydride1782573anhydride_
anhydrites1792733anhydrites
bedsides1246533bedsides
borides10515153_borides
brides94423513__brides
chlorides15289753chlorides
chytrids1744223chytrid_s
codrives1437663codrives
cyanides14258003cyanides
debrides1268723debrides
derides93420853_derides
dries64733673__dri_es
drives105117113__drives
eyries93816813ey_ri_es
grides84422363__grides
haeredes1246333haeredes
hagride1237553hagride_
hagrider1334483hagrider
hagriders1443553hagriders
halides113416663h_alides
hardies114923233hardi_es
harries103525493harri_es
hayride1437323hayride_
henries102718283henri_es
heredes11313133h_eredes
herries104025073herri_es
hides95129423h___ides
hidroses1237903hidroses
hordes104921633h_or_des
horrider1236533horrider
horridest1345643horridest
hubrises1337103hubrises
hurdies114015663hurdi_es
hurries103919653hurri_es
hyalines14169333hyalines
hyalites14208833hyalites
hybrid15237813hybrid__
hybridism2053013hybridism
hybridist1853873hybridist
hybridizes28133203hybridizes
hybris14247003hybri__s
hydatids1643833hydatid_s
hydracids1943843hydracid_s
hydrae13258573hydr_ae_
hydrants1585793hydrants
hydras13239313hydr__as
hydrase14287663hydrase_
hydrate14239813hydrate_
hydrated16216953hydrated
hydrazide2653123hydrazide_
hydrazines2643693hydrazines
hydria13227903hydri__a
hydric15227953hydri__c
hydrilla1543473hydrilla
hydrillas1643443hydrillas
hydrogel1644753hydrogel
hydrogels1764333hydrogels
hydrogen1646283hydrogen
hydrogens1746063hydrogens
hydroid1539713hydroid__
hydromel1795353hydromel
hydromels1844793hydromels
hydrops16197413hydr_ops
hydropses1846033hydropses
hydros13279363hydr__os
hydrous14197883hydr_ous
hydroxide2445403hydroxide_
hyoids1377673hy_oid_s
hyraces1537913hy_races
hyraxes2045703hy_raxes
iodides93811613iod_ides
irides74519123__irides
joyrides1943853joyrides
kyries133411373ky_ri_es
lyddites1342583lyddites
mydriases1563083mydriases
nitrides92910703nitrides
outrides92414993outrides
prides94324183__prides
pyrites12812203py_rites
pyxides2034423py_xides
redries83721713redri_es
redrives122610393redrives
rides66140813___rides
strides84520393_strides
updries10209083updri_es

Search took 7 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.423422437.4
2DLD Change Limit1461621016.06324107.2
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.53227356.2
 
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.