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

138 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
hydrates1522940(None) 
hydrases15227641hydrases
hydrate14239811hydrate_
hydrated16216951hydrated
dehydrates1844232dehydrates
gyrates113610262gy_rates
hydrae13258572hydra_e_
hydranths1983162hydranths
hydrants1585792hydrants
hydras13239312hydra__s
hydrase14287662hydrase_
hydrastis1644492hydrastis
hydrator1545762hydrator
hydrators1645682hydrators
hydrides16276942hydrides
hyraces1537912hy_races
hyraxes2045702hy_raxes
rehydrates1744442rehydrates
aerates74627483_aerates
airdates939713airdates
amirates101114793amirates
anhydrites1792733anhydrites
bedmates1349183bedmates
bedrapes1386963bedrapes
berates94126853_berates
borates94823013_borates
carates95630603_carates
cerates95428233_cerates
chlorates142512263chlorates
chordates1547683chordates
citrates102315073citrates
crates85736053__crates
curates95323823_curates
cyanates13238423cyanates
dates65639153__d_ates
dehydrate1744863dehydrate_
dehydrated1943493dehydrated
derates84028883_derates
disrates91118143disrates
drakes114715863__drakes
drapes95419653__drapes
drats66628373__drat_s
emirates101214843emirates
federates13310143federates
ferrates113013403ferrates
grates75429883__grates
gyrases11368313gy_rases
gyrate104912523gy_rate_
gyrated12428413gy_rated
hamates122917673h_amates
hates86742573h___ates
headgates1446383headgates
headraces1546613headraces
hidroses1237903hidroses
horstes104516113h_orstes
humates122813193h_umates
hyalites14208833hyalites
hybrises1645423hybrises
hydatid1546513hyd_atid
hydatids1643823hyd_atids
hydra12249223hydra___
hydracid1844973hydracid
hydracids1943843hydracids
hydragog1743053hydragog
hydragogs1842983hydragogs
hydrangea1752523hydrangea
hydrangeas1852123hydrangeas
hydrant1489053hydra_nt
hydranth1873893hydranth
hydrastises1852483hydrastises
hydrating1746323hydrating
hydration1646073hydration
hydrations1745273hydrations
hydrazides2752813hydrazides
hydrazines2643683hydrazines
hydriae14246903hydriae_
hydride15257503hydride_
hydrids15267233hydr_ids
hydrogel1644753hydrogel
hydrogels1764333hydrogels
hydrogen1646283hydrogen
hydrogens1746063hydrogens
hydroids1647753hydroids
hydrolases1746273hydrolases
hydrolytes2046063hydrolytes
hydromel1795353hydromel
hydromels1844793hydromels
hydropaths2255653hydropaths
hydrops16197413hydr_ops
hydropses1846023hydropses
hydros13279363hydr__os
hydrous14197883hydr_ous
ideates8313723_ideates
indurates10310693indurates
ingrates9514153ingrates
iodates8312893iod_ates
iterates81317813iterates
karates115617473_karates
librates103412933librates
lyddites1342583lyddites
lyrate94112103ly_rate_
lyrated11388473ly_rated
lysates10317473ly_sates
madrases112610003madrases
mediates112814063mediates
migrates111112843migrates
misrates101318233misrates
moderates12710743moderates
mydriases1563083mydriases
narrates8312753narrates
nidates8311883nid_ates
nitrates82516203nitrates
operates10515403operates
orates64328613__orates
outrates82421363outrates
phorates13413043phorates
picrates122013203picrates
pirates93020323_pirates
prates84633163__prates
prorates10418063prorates
pyrites12812203py_rites
quadrates19117793quadrates
radiates92415293radiates
rates55352013___rates
recrates102420353recrates
redates83423863red_ates
regrates92618373regrates
rehydrate1644793rehydrate_
rehydrated1853843rehydrated
sedates83418033sed_ates
serrates82617003serrates
titrates82314643titrates
uncrates10314553uncrates
undrapes1138603undrapes
updates10329793upd_ates
uprates93814863_uprates
urates65027763__urates
vibrates132210593vibrates

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.1701051123.5
2DLD Change Limit1461621387.69019006.8
3Display Results1381380.0602300.0
 (SQL Overall)1786911387.92022562.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.