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

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

44 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
hydroxylamine326318(None) 
hydroxylamines3362901hydroxylamines
hydroxylating3163242hydroxylating
hydroxylase2853983hydroxyla__se
hydroxylate2854423hydroxyla__te
hydroxylation3063363hydroxylation
hydroxylations3163123hydroxylations
hydroxyzine3753523hydroxy__zine
hydralazine2762264hydr__alazine
hydrodynamic2763434hydrodynami_c
hydrodynamics2863014hydrodynamics
hydroplane1955844hydro_pla__ne
hydroplaning2263464hydro_planing
hydroxyapatite3371654hydroxyapatite
hydroxylapatite3481224hydroxylapatite
hydroxylases2963724hydroxyla_ses
hydroxylated3063574hydroxyla_ted
hydroxylates2954164hydroxyla_tes
hydroxylic2954224hydroxyl__i_c
hydroxyproline3381524hydroxyproline
hydroxyzines3863084hydroxy__zines
cyclohexylamine3791355cyclohexylamine
hydralazines2862025hydr__alazines
hydrazine2544245hydr____azine
hydrochloride26132315hydrochloride
hydrodynamical2972345hydrodynamical
hydrogenating2262955hydrogenating
hydrolase1645885hydro__la__se
hydrolysate2153635hydrolysa__te
hydrolyzable3362075hydrolyza_ble
hydrolyzate3053505hydrolyza__te
hydrolyzing3153145hydro__lyzing
hydrophane2256335hydro_pha__ne
hydroplaned2154165hydro_pla__ned
hydroplanes2055875hydro_pla__nes
hydroxide2445405hydrox____ide
hydroxyapatites3471465hydroxyapatites
hydroxyl2543885hydroxyl_____
hydroxyls2664215hydroxyl____s
hydroxyprolines3491445hydroxyprolines
hyoscyamine2461455hy__oscyamine
prolamine131510565__pro__lamine
pyroxylin2454165py_roxyl__in_
pyroxylins2563455py_roxyl__ins

Search took 9 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.406440125.6
2DLD Change Limit124790447.79616006.9
3Display Results44440.0331333.3
 (SQL Overall)178691448.23521699.0
 
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.