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

62 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
hydrostatic206523(None) 
hydrostatics2174001hydrostatics
hydrostat1646052hydrostat__
hydrostats1754922hydrostat_s
hypostatic2056222hy_postatic
cytostatic1754463cy_tostatic
hemostatic1756663h_emostatic
homeostatic1853303homeostatic
hydrolytic2256203hydro_lytic
hydropathic2564953hydropathic
hydrophytic2855473hydrophytic
hydrosolic1954613hydros_olic
hygrostat1653893hygrostat__
hygrostats1752963hygrostat_s
hyperostotic2254483hyperostotic
hyperstatic2156033hyperstatic
prostatic13410853__prostatic
aerostatics1354384_aerostatics
cryostatic1753804_cryostatic
cytostatics1853054cy_tostatics
diastatic1245934__diastatic
gyrostat1244564gy_rostat__
gyrostats1343274gy_rostat_s
hemostatics1854724h_emostatics
hidrotic1446904hidro___tic
hybristic1944584hybris__tic
hydrastis1644504hydras__tis
hydrodynamic2763434hydrodynamic
hydrographic2756364hydrographic
hydrokinetic2563014hydrokinetic
hydrologic2046674hydro_logic
hydrometric2275894hydrometric
hydronic1748094hydro___nic
hydropath2145724hydro_pat_h
hydropaths2255674hydro_paths
hydropathy2554494hydro_pathy
hydrophilic2555194hydrophilic
hydrophobic2784754hydrophobic
hydropic1947274hydro___pic
hydroponic2155874hydro_ponic
hydroski1943524hydros__ki_
hydroskis2044134hydros__kis
hydrospace21124014hydrospa_ce
hydrospaces22123874hydrospaces
hydrospheric2663024hydrospheric
hydrostatically2762474hydrostatically
hydrotropic2255284hydrotropic
hydroxylic2954224hydro_xylic
hygrophytic2854034hygrophytic
hygroscopic2453644hygroscopic
hypostasis1855794hy_postasis
hypostatize2863704hy_postatize
hypotactic2275454hy_po_tactic
isostatic1145354__isostatic
mydriatic1753364mydr__iatic
orthostatic1654004orthostatic
photostatic1857114photostatic
protatic12314744__pro_tatic
pyrostat1347164py_rostat__
pyrostats1444914py_rostat_s
rheostatic1553994_rheostatic
thermostatic1954344thermostatic

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 Filter1786911488190.420425454.8
2DLD Change Limit148819628.47017570.1
3Display Results62620.0302066.7
 (SQL Overall)178691628.92020032.6
 
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.