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

117 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
hydrids1526723(None) 
hybrids16236021hybrids
hydrid14248971hydrid_
hydride15257501hydride
hydrides16276941hydrides
hydroids1647761hydroids
chytrids1744222chytrids
hybrid15237812hybrid_
hybris14247002hybri_s
hydatids1643832hydatids
hydracids1943842hydracids
hydras13239312hydr_as
hydria13227902hydri_a
hydriae14246902hydriae
hydric15227952hydri_c
hydroid1539712hydroid_
hydrops16197412hydrops
hydros13279362hydr_os
hydrous14197882hydrous
hyoids1377672hy_oids
acarids105312243acarids
aldrins8310203aldrins
androids1047753androids
anhydride1782573anhydride
anhydrides1872023anhydrides
bedrid1039943bedrid_
chlorids14299673chlorids
chytrid1645733chytrid_
clerids1049093clerids
cyanids13297933cyanids
dihybrids1962043dihybrids
dribs85115063__dribs
dries64733673__dries
drips85417233__drips
droids84712583__droids
druids8368093__druids
endrins8312163endrins
eyelids1135943eyelids
eyries93816813ey_ries
gadids95611823gad_ids
gadoids1036873gadoids
grids75321393__grids
hadjis17439653hadji_s
hadrons113314303hadrons
hagride1237553hagride
hagrides1337623hagrides
halids104016133h_alids
haloids113012553haloids
hardies114923233hardies
hards96435653h_ar_ds
harries103525493harries
hatreds11307813hatreds
hayride1437323hayride
hayrides1536883hayrides
henries102718283henries
herdics13249523herdics
herds96424683h_er_ds
herries104025073herries
hoards104912623hoar_ds
hodads1147963hod_ads
hoddins12289373hoddins
horrid10311563horrid_
hotrods1148283hotrods
houris94514583houri_s
hubris11218973hubri_s
hundreds1344003hundreds
hurdies114015663hurdies
hurds95219073h_ur_ds
hurries103919653hurries
hyalins13229273hyalins
hyaloids1545993hyaloids
hybridism2053013hybridism
hybridist1853873hybridist
hybrises1645423hybrises
hydatid1546523hydatid_
hydra12249223hydr__a
hydracid1844983hydracid_
hydrae13258573hydr_ae
hydrant1489053hydrant
hydrants1585793hydrants
hydrase14287663hydrase
hydrases15227643hydrases
hydrate14239813hydrate
hydrates15229413hydrates
hydrazide2653123hydrazide
hydrazides2752823hydrazides
hydrilla1543473hydrilla
hydrillas1643443hydrillas
hydro12259423hydr__o
hydropsy20184153hydropsy
hydroxide2445403hydroxide
hydroxides2544903hydroxides
hydroxy2454263hydroxy
hyoid12612443hy_oid_
indris7311963indri_s
iodids83711153iod_ids
irids66417773__irids
jerids142810943_jerids
jerrids15277743jerrids
kidvids1643113kidvids
kyries133411373ky_ries
lyrics11357943ly_rics
midribs1235513midribs
murids93212193_murids
myriads1334353my_riads
mysids1246563my_sids
nitrids8269633nitrids
pyurias1236713pyurias
redries83721713redries
rids56539553___rids
sparids103512123sparids
thyroids1546003thyroids
updries10209083updries
yairds10448023_yairds
yards95324613_yar_ds
yids85224963_y__ids
yirds96612513_yir_ds

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.420425454.8
2DLD Change Limit1340271177.00019146.7
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.46623934.0
 
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.