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

145 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
hydrate1423981(None) 
hydrae13258571hydra_e
hydrase14287661hydrase
hydrated16216951hydrated
hydrates15229401hydrates
dehydrate1744862dehydrate
gyrate104912522gy_rate
hydra12249222hydra__
hydrant1489052hydrant
hydranth1873892hydranth
hydrants1585792hydrants
hydras13239312hydra_s
hydrases15227642hydrases
hydrator1545762hydrator
hydriae14246902hydriae
hydride15257502hydride
lyrate94112102ly_rate
rehydrate1644792rehydrate
acerate92818913acerate
adnate72913483_adnate
aerate64830553_aerate
airdate8311323airdate
amirate91115953amirate
anhydrite16153463anhydrite
aurate64426473_aurate
bedmate1239433bedmate
bedrape1277693bedrape
berate84729023_berate
borate85026153_borate
carate84734003_carate
cerate84829463_cerate
chlorate133112693chlorate
chordate1448033chordate
cirrate92413493cirrate
citrate92216803citrate
cordate10315223cordate
crate76537403__crate
curate85226243_curate
cyanate12259703cyanate
date56443323__d_ate
dehydrated1943493dehydrated
dehydrates1844243dehydrates
derate74531233_derate
disrate81418523disrate
drake104918303__drake
drape85319633__drape
drat56247833__drat_
drats66628373__drats
drave95219273__drave
emirate91015833emirate
federate12310883federate
ferrate103014043ferrate
grate64932883__grate
gyrase10508773gy_rase
gyrated12428413gy_rated
gyrates113610263gy_rates
hamate113319833h_amate
hastate10313913hastate
hate78450173h___ate
headgate1346483headgate
headrace1446663headrace
horste94817413h_orste
humate113214443h_umate
hyalite13229473hyalite
hydatid1546523hyd_atid
hydracid1844983hydracid
hydragog1743053hydragog
hydrangea1752523hydrangea
hydranths1983163hydranths
hydrastis1644493hydrastis
hydrating1746323hydrating
hydration1646073hydration
hydrators1645683hydrators
hydrazide2653123hydrazide
hydrazine2544243hydrazine
hydria13227903hydr_ia
hydric15227953hydr_ic
hydrid14248973hydr_id
hydrides16276943hydrides
hydrids15267233hydrids
hydro12259423hydr__o
hydrogel1644753hydrogel
hydrogen1646283hydrogen
hydroid1539713hydroid
hydrolase1645883hydrolase
hydrolyte1945723hydrolyte
hydromel1795353hydromel
hydropath2145713hydropath
hydrops16197413hydrops
hydros13279363hydr_os
hydrous14197883hydrous
hydroxy2454263hydroxy
hyphae1746433hypha_e
hyraces1537913hy_races
hyrax1838033hy_ra_x
hyraxes2045703hy_raxes
hyte109018943hy___te
ideate7313683_ideate
indurate9311873indurate
ingrate8715123ingrate
iodate7313503iod_ate
irate55627983__irate
iterate71119113iterate
karate105320923_karate
librate93214233librate
lyddite1243333lyddite
lyrated11388473ly_rated
lysate9388103ly_sate
mediate103415213mediate
migrate101314173migrate
misrate91319143misrate
moderate11710993moderate
narrate7313493narrate
nidate7313783nid_ate
nitrate72017013nitrate
obdurate1175123obdurate
operate9615733operate
orate55133303__orate
outrate72323183outrate
overate10620963overate
pedate93117763ped_ate
phorate12413363phorate
picrate112014143picrate
pirate82322883_pirate
prate75135983__prate
prorate9418733prorate
pyrite11913313py_rite
quadrate1888043quadrate
radiate83416313radiate
rate45458763___rate
recrate92621663recrate
redate74124683red_ate
regrate82618663regrate
rehydrated1853843rehydrated
rehydrates1744463rehydrates
sedate73019803sed_ate
serrate73017543serrate
titrate72215573titrate
uncrate9415953uncrate
underate9918603underate
undrape1049333undrape
update93810293upd_ate
uprate83916543_uprate
urate55432163__urate
vibrate122811523vibrate

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.1731032896.0
2DLD Change Limit1340271457.06318975.9
3Display Results1451450.0463152.2
 (SQL Overall)1786911457.28224538.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.