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

147 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
hydrae1325857(None) 
hydra12249221hydra_
hydras13239311hydras
hydrase14287661hydrase
hydrate14239811hydrate
hydriae14246901hydriae
hydrant1489052hydrant
hydrases15227642hydrases
hydrated16216952hydrated
hydrates15229402hydrates
hydria13227902hydria
hydric15227952hydric
hydrid14248972hydrid
hydride15257502hydride
hydro12259422hydr_o
hydros13279362hydros
hyphae1746432hyphae
hyrax1838032hy_rax
agorae7511203agorae
aurae54128113_aurae
bedrape1277693bedrape
brae65639113__brae
byre95023853by_r_e
cadre85419023cadr_e
cymae126713013cy_mae
dare55848863__dare
dehydrate1744863dehydrate
drab76226453__drab
drag64825053__drag
drake104918303__drake
dram75832003__dram
drape85319633__drape
drat56247833__drat
drave95219273__drave
draw85623013__draw
dray85428093__dray
dree56638323__dree
exedrae1544713exedrae
exhedrae1943343exhedrae
eyra76217553ey_ra_
eyras84715923ey_ras
eyre75525253ey_r_e
eyrie88117833ey_rie
florae94713883florae
frae75330473__frae
gyral94412783gy_ral
gyrase10508773gy_rase
gyrate104912523gy_rate
gyre84722763gy_r_e
hadal95518123had_al
hade85440193had__e
hadjee174111823hadjee
hadron102913753hadron
hae67364003h___ae
hare76255733h_ar_e
headrace1446663headrace
hearse94114273hearse
heddle114211163heddle
hedge105317333hed_ge
here76447103h_er_e
hermae115314473hermae
heyday1635143heyd_ay
hide85134633hid__e
hijra1535643hijra_
hijrah1934283hijrah
hijras1635773hijras
hire75538963h_ir_e
hiree85427803h_iree
hoarse94411323hoarse
hodad10311353hod_ad
hoorah124411113hoorah
hooray123011373hooray
hora76136563h_ora_
horah117922053h_orah
horal86328683h_oral
horas86333103h_oras
horde94623053h_orde
horse86132653h_orse
huddle113712993huddle
hurdle103712793hurdle
hurrah12369183hurrah
hurray12459913hurray
hybrid15237813hybrid
hybris14247003hybris
hydracid1844983hydracid
hydragog1743053hydragog
hydrangea1752523hydrangea
hydranth1873893hydranth
hydrants1585793hydrants
hydrator1545763hydrator
hydrazide2653123hydrazide
hydrazine2544243hydrazine
hydrides16276943hydrides
hydrids15267233hydrids
hydrogel1644753hydrogel
hydrogen1646283hydrogen
hydroid1539713hydroid
hydrolase1645883hydrolase
hydromel1795353hydromel
hydrops16197413hydrops
hydrous14197883hydrous
hydroxy2454263hydroxy
hyena11810253hyena_
hyenas1288953hyenas
hyetal1236543hyetal
hyla106716513hy_la_
hylas114815903hy_las
hymnal1434913hymnal
hype125519813hy__pe
hypha1637383hypha_
hyphal1736413hyphal
hyraces1537913hy_races
hyraxes2045703hy_raxes
hyte109018943hy__te
kyrie123712903ky_rie
laurae64011663laurae
librae84310173librae
lycra10317973lycra_
lycras11287253lycras
lyrate94112103ly_rate
lyre75623793ly_r_e
lyttae994713lyttae
madras94316433madras
madre85720173madr_e
mediae94217413mediae
morae75831193_morae
mudra83912433mudra_
mudras94212253mudras
padre86018163padr_e
parae76335703_parae
phylae14458733phy_lae
pyran10514473py_ran
pyre94925553py_r_e
rediae74221993rediae
redraw10269853redraw
rehydrate1644793rehydrate
sylvae12236863sylvae
synurae1044253synurae
terrae62915213terrae
thyrse1235133thy_rse
tyre75428253ty_r_e
umbrae1038683umbrae
undrape1049333undrape
undraw1037813undraw
whydah1942953whyd_ah
yare75636943_yar_e
yore76335943_yor_e

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127161475.42020796.3
3Display Results1471470.0463195.7
 (SQL Overall)1786911475.60931857.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.