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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

178 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
hydrotropic225528(None) 
hydrotropism23103832hydrotropism
thyrotropic2154552thy_rotropic
heliotropic1854653heliotropic
hydrographic2756363hydrographic
hydrologic2046673hydro_logic
hydromorphic2864073hydromorphic
hydrophobic2784753hydrophobic
hydropic1947273hyd___ropic
hydroponic2155873hydro_ponic
hydrosolic1954613hydro_solic
hydrotropisms24102903hydrotropisms
hygroscopic2453643hygroscopic
neurotropic1555213neurotropic
thyrotrophic2573613thy_rotrophic
thyrotropin1964333thy_rotropin
allotropic1455554_allotropic
anisotropic1554794anisotropic
diatropic1445934__diatropic
endotrophic1954744end_otrophic
esotropic13126804__esotropic
exotropic20116264__exotropic
geotropic1467024__geotropic
gyroscopic2054014gy_roscopic
heterotopic18125304heterot_opic
heterotrophic2363754heterotrophic
hidrotic1446904hidrot___ic
hydrofoil1953784hydro_fo_il
hydrography2746194hydrography
hydrolytic2256204hydro_lytic
hydrometric2275904hydrometric
hydronic1748094hyd___ronic
hydropathic2564954hydropathic
hydrophilic2555194hydrophilic
hydrophobia2584364hydrophobia
hydrophytic2855484hydrophytic
hydroponics2254774hydro_ponics
hydrostatic2065234hydrostatic
hydrothorax2862454hydrothorax
hydroxylic2954224hydro_xylic
hypermetropic2762624hypermetropic
hyperopic2147414hy__peropic
hypertrophic2763684hypertrophic
hypotonic1948194hy_pot_onic
inotropic13106424__inotropic
isotropic1396644__isotropic
lipotropic1654634_lipotropic
luteotropic1553734luteotropic
neotropic1367734__neotropic
nootropic1356274__nootropic
phototropic2058204phototropic
pleiotropic1774154pleiotropic
psychotropic2664484psychotropic
thermotropic2154954thermotropic
thixotropic2553574thixotropic
thyrotrophin2363384thy_rotrophin
thyrotropins2063894thy_rotropins
xenotropic2154784_xenotropic
ametropic1545675__ametropic
apotropaic1654405__apotropaic
autotrophic1856355_autotrophic
auxotrophic2554465_auxotrophic
chymotryptic2961465chy_motryptic
cyclotomic1853645cyclot_omic
cystoscopic1962965cystoscopic
cytotoxic23154435cy_tot_oxic
diageotropic1861515diageotropic
dystrophic2154205__dystrophic
ectotrophic2054625_ectotrophic
endoscopic1754475end_oscopic
endotoxic1944645end_ot_oxic
entropic1249705___entropic
esotropia1185565__esotropia
eurytopic1653115_euryt_opic
exotropia18145255__exotropia
gonadotropic1862145gonadotropic
hadronic1447955had___ronic
hagioscopic2162615hagioscopic
heliotrope1553785heliotrop_e
heliotropes1654055heliotropes
heliotropism1973475heliotropism
hemotoxic2346325h_emot_oxic
heroicomic1953895h_eroicomic
heterotroph1964095heterotrop_h
heterotrophs2063995heterotrophs
heterotrophy2363395heterotrophy
heterotypic21124515heterot_ypic
hidrotics1544515hidrot___ics
holotypic1944015h_olot_ypic
homoerotic1755585h_omoerotic
horologic1548435h_oro_logic
hydration1646075hydratio__n
hydrations1745285hydratio_ns
hydrator1545765hydrat_o__r
hydrators1645685hydrat_o_rs
hydraulic1852375hydr__aulic
hydric15227955hyd___r__ic
hydrocrack2553075hydrocr_ack
hydrocracks2652755hydrocracks
hydrodynamic2763435hydrodynamic
hydrofoils2053515hydro_foils
hydrographer2555805hydrographer
hydrographies2675805hydrographies
hydroid1539715hyd___ro_id
hydrokinetic2563015hydrokinetic
hydrological2246485hydro_logical
hydrologies1948185hydro_logies
hydrologist1948335hydro_logist
hydrology2046215hydro_lo_gy
hydrolysis2045665hydro_lysis
hydroperoxide30121585hydroperoxide
hydrophobias2693835hydrophobias
hydrophone2256405hydropho_ne
hydrophones2356385hydrophones
hydropower2253435hydro_power
hydrops16197415hyd___rop_s
hydropsy20184155hyd___ropsy
hydroski1943525hydro__ski_
hydroskis2044135hydro__skis
hydrosol1544475hydro_so__l
hydrosols1644735hydro_so_ls
hydrospace21124015hydro__space
hydrospheric2663025hydrospheric
hydrostatics2174015hydrostatics
hydrotherapies2663525hydrotherapies
hydrotherapy2762685hydrotherap_y
hydrothoraces2562945hydrothoraces
hydrozoan2554135hydro_zo_an
hydrozoans2654115hydro_zoans
hygrograph2355445hygrograp_h
hygrographs2455505hygrographs
hygrometric2254705hygrometric
hygrophytic2854045hygrophytic
hylozoic2543665hy_lo_zo_ic
hypermetropia2562875hypermetropia
hyperopia1947145hy__peropia
hyperostotic2254485hyperostotic
hypertonic2087955hypert_onic
hypertrophy2762305hypertrophy
hypnogogic2252575hypno_gogic
hypnopompic2461385hypnopompic
hypnotic1846625hypnot___ic
hypomorphic2854825hy_pomorphic
hypotactic2275465hy_potactic
hypotonia1747455hy_pot_onia
idiotypic1752185_idiot_ypic
isentropic1453495_isentropic
isotopic12187305__isot_opic
lipotropin1454395_lipotropin
luteotrophic1963275luteotrophic
luteotropin1363665luteotropin
macroscopic1855035macroscopic
mesotrophic2054755_mesotrophic
microscopic1856385microscopic
myotonic1547755my__ot_onic
neotropics1475195__neotropics
neurotoxic1954895neurot_oxic
nootropics1454155__nootropics
oligotrophic2063265oligotrophic
pantropic1547765__pantropic
photopic17411105__phot_opic
phytotoxic2754625phy_tot_oxic
plagiotropic1962015plagiotropic
prodromic1644575__prodromic
proteomic1546755__proteomic
protonic12314605__prot_onic
prototrophic2154845prototrophic
protreptic1644725__protreptic
psychotropics2764005psychotropics
pyrophoric2256375py_rophoric
pyrrolic1544565py_r__rolic
scotopic1446515__scot_opic
semitropic1654275_semitropic
stenotopic1454405stenot_opic
subtropic1544575__subtropic
thyrotrophins2462955thy_rotrophins
tropic103014205_____tropic
uroscopic1555215__uroscopic

Search took 21 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 Filter1786911646070.453394461.4
2DLD Change Limit16460717819.6408381.2
3Display Results1781780.1431244.8
 (SQL Overall)17869117820.2368830.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.