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

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

41 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
hydroxylases296372(None) 
hydroxylase2853981hydroxylase_
hydroxylates2954161hydroxylates
hydrolases1746282hydro__lases
hydroxylate2854422hydroxylate_
hydroxylated3063572hydroxylated
hydrogenases20104613hydrogenases
hydrolase1645883hydro__lase_
hydrolysates2253383hydrolysates
hydrolyses2045593hydro__lyses
hydrolyzates3153293hydrolyzates
hydroplanes2055873hydro_planes
hydroxylamines3362903hydroxylamines
hydroxyls2664213hydroxyl___s
hydroxyzines3863083hydroxyzines
carboxylases2662384carboxylases
hydrases15227644hydr____ases
hydrocasts1954714hydro__casts
hydroceles1954604hydrocel__es
hydrogenase19104474hydrogenase_
hydrogenates20115074hydrogenates
hydrolysate2153634hydrolysate_
hydrolysis2045664hydro__lysis
hydrolytes2046084hydro__lytes
hydrolyzate3053504hydrolyzate_
hydrolyzes2944874hydro__lyzes
hydrophanes2356424hydro_phanes
hydroplane1955844hydro_plane_
hydroplaned2154164hydro_planed
hydropses1846034hydro___pses
hydrospaces22123874hydro_spaces
hydroxides2544904hydrox__ides
hydroxyl2543884hydroxyl____
hydroxylamine3263184hydroxylamine
hydroxylating3163244hydroxylating
hydroxylation3063364hydroxylation
hydroxylations3163124hydroxylations
hydroxylic2954224hydroxyl__ic
hydroxyurea2862234hydroxy_urea
hydroxyureas2961624hydroxyureas
hydroxyzine3753524hydroxyzine_

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 Filter1786911247900.390458182.1
2DLD Change Limit124790417.12617511.9
3Display Results41410.0162562.5
 (SQL Overall)178691417.53223724.2
 
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.