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

72 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
hydrospaces2212386(None) 
hydrospace21124001hydrospace_
aerospaces1443423_aerospaces
hydrocracks2652753hydrocracks
hydrolases1746273hydro_lases
hydropaths2255663hydro_paths
hydrophanes2356413hydrophanes
hydroplanes2055863hydroplanes
hydropses1846023hydro_p_ses
hydropsies1945933hydro_psies
hydroseres1745053hydros_eres
hydrospheres2453383hydrospheres
hydrostats1754913hydrosta_ts
hyperspaces2354313hyperspaces
aerospace1343744_aerospace_
airspaces1344504_air_spaces
cyberspaces2291234cyberspaces
hadrosaurs1452694hadros_aurs
haruspices1752224h_aruspices
headspaces1852804h_eadspaces
hidroses1237904hidros___es
hospices1587634h___ospices
hydrases15227644hydr___ases
hydrastises1852494hydrastises
hydrates15229404hydr___ates
hydrocasts1954704hydro_casts
hydroceles1954604hydro_celes
hydrocrack2553074hydrocrac_k
hydrocracked2862014hydrocracked
hydrocracker2762114hydrocracker
hydrocrackers2861574hydrocrackers
hydrogenases20104604hydrogenases
hydrogenates20115064hydrogenates
hydrolase1645884hydro_lase_
hydrologies1948174hydrologies
hydrolysates2253374hydrolysates
hydrolyses2045584hydro_lyses
hydrolytes2046074hydro_lytes
hydrolyzates3153284hydrolyzates
hydrolyzes2944864hydro_lyzes
hydromancies2353874hydromancies
hydropath2145714hydro_pa_th
hydropathies2454304hydro_pathies
hydropathy2554484hydro_pathy
hydrophane2256334hydrophane_
hydrophones2356374hydrophones
hydrophytes2655834hydrophytes
hydropic1947274hydro_pic__
hydroplane1955844hydroplane_
hydroplaned2154164hydroplaned
hydropower2253434hydro_power
hydropowers2352804hydro_powers
hydrops16197414hydro_p___s
hydrosere1644824hydros_ere_
hydroskis2044134hydros__kis
hydrosols1644734hydros__ols
hydrosphere2353404hydrosphere
hydrostat1646054hydrosta__t
hydrostatic2065224hydrostatic
hydrostatics2173994hydrostatics
hydrothoraces2562934hydrothoraces
hydroxides2544894hydro_xides
hydroxylases2963714hydroxylases
hydroxylates2954154hydroxylates
hydrozoans2654114hydrozoa_ns
hygrostats1752964hygrosta_ts
hyperspace2253704hyperspace_
hypostases1846104hy_postases
hyraces1537914hy_r___aces
midspaces1643994mid__spaces
respaces12311044___respaces
workspaces2152004_workspaces

Search took 10 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 Filter1786911488190.1701051123.5
2DLD Change Limit148819729.19016193.6
3Display Results72720.0302400.0
 (SQL Overall)178691729.39019029.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.