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

59 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
hydroponics225477(None) 
hydroponic2155871hydroponic_
hydrofoils2053513hydrofo_ils
hydrologic2046673hydrologic_
hydrologies1948183hydrologies
hydronic1748093hydr__onic_
hydrophobias2693833hydrophobias
hydrophobic2784753hydrophobic_
hydrophones2356383hydrophon_es
hydropic1947273hydrop__ic_
hydropowers2352803hydropowers
hydropsies1945943hydrop_sies
hydrosolic1954613hydrosolic_
geoponics1444384__geoponics
hadronic1447954hadr__onic_
harmonics16107404h_ar_monics
hedonics1445904hed___onics
hidrotics1544514hidr__otics
hydraulics1951764hydr_aulics
hydrodynamics2863014hydrodynamics
hydrofoil1953784hydrofo_i_l
hydrogenous1953954hydrogenous
hydrogens1746064hydrogen__s
hydroids1647764hydr__o_ids
hydrological2246484hydrological
hydrologist1948334hydrologist
hydrologists2046094hydrologists
hydrolysis2045664hydrolysi_s
hydrolytic2256204hydrolytic_
hydromancies2353884hydromancies
hydromancy2483444hydroman_cy
hydronium1844954hydr__onium
hydroniums1954014hydr__oniums
hydropathic2564954hydropathic_
hydropathies2454314hydropathies
hydropaths2255674hydrop_aths
hydrophanes2356424hydrophanes
hydrophilic2555194hydrophilic_
hydrophobia2584364hydrophobi_a
hydrophone2256404hydrophon__e
hydrophytes2655844hydrophytes
hydrophytic2855474hydrophytic_
hydroplanes2055874hydroplanes
hydroplaning2263464hydroplaning
hydroponically2863204hydroponically
hydropower2253434hydropo_wer
hydrops16197414hydrop____s
hydropses1846034hydrop__ses
hydroskis2044134hydro_ski_s
hydrosols1644734hydroso__ls
hydrostatics2174004hydrostatics
hydrotropic2255284hydrotropic_
hydroxylic2954224hydroxylic_
hydrozoans2654114hydrozo_ans
hypomanics2255074hy_pomanics
hypotonias1847164hy_potonias
hypotonic1948194hy_potonic_
microphonics2355374microphonics
troponins1147204__troponins

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.423422437.4
2DLD Change Limit148819598.15318253.3
3Display Results59590.0331787.9
 (SQL Overall)178691598.60920756.3
 
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.