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 “hydrase” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
hydrase1428766(None) 
hydrae13258571hydra_e
hydras13239311hydras_
hydrases15227641hydrases
hydrate14239811hydrate
gyrase10508772gy_rase
hydra12249222hydra__
hydrant1489052hydrant
hydrated16216952hydrated
hydrates15229402hydrates
hydriae14246902hydriae
hydride15257502hydride
hydrolase1645882hydrolase
hydros13279362hydros_
apyrase1236363apyrase
bedrape1277693bedrape
cyclase1436613cyclase
dehydrate1744863dehydrate
drake104918303__drake
drape85319633__drape
drave95219273__drave
druse64817663__druse
erase54925493__erase
eyras84715923ey_ras_
gyrases11368313gy_rases
gyrate104912523gy_rate
gyrose105310253gy_rose
harass9313943h_arass
hardass1139753hardass
hardcase1445623hardcase
headrace1446663headrace
hearse94114273hear_se
hidroses1237903hidroses
hijras1635773hijras_
hoarse94411323hoar_se
horas86333093h_oras_
horse86132653h_or_se
hybris14247003hybris_
hybrises1645423hybrises
hydracid1844983hydracid
hydragog1743053hydragog
hydrangea1752523hydrangea
hydranth1873893hydranth
hydrants1585793hydrants
hydrastis1644493hydrastis
hydrator1545763hydrator
hydrazide2653123hydrazide
hydrazine2544243hydrazine
hydria13227903hydr_ia
hydric15227953hydr_ic
hydrid14248973hydr_id
hydrides16276943hydrides
hydrids15267233hydrids
hydro12259423hydr__o
hydrocast1845803hydrocast
hydrogel1644753hydrogel
hydrogen1646283hydrogen
hydroid1539713hydroid
hydrolases1746273hydrolases
hydromel1795353hydromel
hydrops16197413hydrops
hydropses1846023hydropses
hydropsy20184153hydropsy
hydrosere1644823hydrosere
hydroski1943523hydroski
hydrosol1544473hydrosol
hydrous14197883hydrous
hydroxy2454263hydroxy
hyenas1288953hyenas_
hylas114815903hy_las_
hyphae1746433hypha_e
hyraces1537913hy_races
hyrax1838033hy_ra_x
hyraxes2045703hy_raxes
lyase85512413ly__ase
lycras11287253lycras_
lyrate94112103ly_rate
madras94316433madras_
madrasa10387883madrasa
madrases112610003madrases
midrash1335423midrash
mudras94212253mudras_
mydriases1563083mydriases
phrase11109903_phrase
prase76128753__prase
rase46149983___rase
rehydrate1644793rehydrate
sucrase9310343sucrase
thyrse1235133thy_r_se
undrape1049333undrape
urase54624683__urase
zymase201997483zy_mase

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027926.70319995.1
3Display Results92920.0303066.7
 (SQL Overall)178691926.88925938.6
 
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.