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

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

152 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
hydrobiological2763541hydrobiological_
aerobiological1955094_aerobiological_
hydrobiologies2473794hydrobiologi__es
hydrobiologist24204504hydrobiologi__st
hydrobiologists25134044hydrobiologi_sts
hydrological2246464hydr___ological_
microbiological2464334microbiological_
neurobiological20123884neurobiological_
radiobiological2163304radiobiological_
cryobiological2463885_cryobiological_
exobiological2554685__exobiological_
hydrobiology2562775hydrobiolog____y
hydrologically27104495hydr___ologically
paleobiological2264695paleobiological_
photobiological2564415photobiological_
prebiological2055935__prebiological_
sociobiological2273475sociobiological_
abiological1647816____abiological_
audiological1665656aud___iological_
biological15128866_____biological_
biologicals16105006_____biologicals
cardiological1954966_car_diological_
chronological2175926_chro_nological_
deontological1755156__deontological_
gerontological1854156_gerontological_
hagiological1955786h___agiological_
herpetological2253306h_erpetological_
homological1948416h___o_mological_
horological1748256h___o_rological_
hydrocolloidal247916hydro_colloidal_
hydrologic2046676hydr___ologic___
microbiologic2264516microbiologic___
myrmecological2662646my_rmecological_
nonbiological1855216__nonbiological_
physiological2455536phy___siological_
proctological2055796__proctological_
radiobiologic1963526radiobiologic___
radiological1646976___radiological_
sociological1747476___sociological_
tribological1745956__trib_ological_
tropological1746616__tro_pological_
aerobiologies1655057_aerobiologi__es
anthropological2373107anthro_pological_
astrobiologies1763267astrobiologi__es
astrobiologist1784197astrobiologi__st
astrobiologists1873767astrobiologi_sts
astrological1546987astr___ological_
axiological2146867____axiological_
bacteriological2282837bacteriological_
biologically2067047_____biologically
bryological1945377__br__yological_
chronobiologic2471997chronobiologic___
chronologically2663527_chro_nologically
codicological1853877cod__icological_
cohomological2354057_coho_mological_
cosmological1946067___cosmological_
criminological21102777__criminological_
cryptological2354797__cryptological_
cytological1947437cy____tological_
demonological1954947__demonological_
dendrological1853837__dendrological_
dermatological2053857_dermatological_
dialogical1445517__d___ialogical_
ecclesiological1992307ecclesiological_
embryological2353187embr__yological_
entomological1855007_ento_mological_
epidemiological23172597epidemiological_
etiological1448387____etiological_
glaciological1963907__glaciological_
graphological2253527__graphological_
gynecological22113787gy__necological_
hematological2155927h__ematological_
heroicomical2162617h_ero_i_comical_
histological1846067h___istological_
homologically2456117h___o_mologically
hydrodynamical2972337hydro_dynamical_
hydrologies1948177hydr___ologi__es
hydrologist1948337hydr___ologi__st
hydrologists2046097hydr___ologi_sts
hydrolytically2563327hydr___olytically
hydromechanical3181617hydromechanical_
hydroponically2863197hydr___oponically
hydrosolic1954617hydro_sol__ic___
hyperbolical2463857hyperb_ol__ical_
hyperboloidal24132437hyperb_olo_idal_
iconological1756007__ico_nological_
ideological15106637_id___eological_
karyological2274737_kar__yological_
meteorological1953767meteo_rological_
methodological2353287metho_dological_
metrological1748357metr___ological_
microbiologies2164987microbiologi__es
microbiologist21135497microbiologi__st
microbiologists22134817microbiologi_sts
morphological2353947_mor_phological_
mycological2147117my____cological_
mythological2346887my___thological_
narratological1763097_narratological_
necrological1747287necr___ological_
neurobiologies1763917neurobiologi__es
neurobiologist17124927neurobiologi__st
neurobiologists18114317neurobiologi_sts
neurological1547337neur___ological_
nomological1648057___no_mological_
nonbiologically2383047__nonbiologically
nosological1447347___no_sological_
oncological1647237____oncological_
ontological1448287____ontological_
oological1248307____o__ological_
orismological1853607__orismological_
paleobiologic2064767paleobiologic___
paleoecological2263527paleoecological_
paleontological2063817paleontological_
paleozoological2963237paleozoological_
parasitological2062757_parasitological_
pedological1757597ped____ological_
petrological1758567petr___ological_
pharmacological2793517pharmacological_
phonological2058337__pho_nological_
photobiologic2365167photobiologic___
photogeological2463067photogeological_
phraseological2283667_phraseological_
phrenological2156307_phr_enological_
phycological2546917phy____cological_
physiologically2993577phy___siologically
pomological1848007___po_mological_
praxeological2554417__praxeological_
prebiologic1884727__prebiologic___
psychobiologic2963717psychobiologic___
pteridological2053567pter_idological_
radiobiologies1863657radiobiologi__es
radiobiologist18154677radiobiologi__st
radiobiologists19174257radiobiologi_sts
radiologically2174537___radiologically
rheological17127457___r_heological_
semasiological1983007_semasiological_
semiological1747777___semiological_
serological1468777_ser___ological_
sociologically2254747___sociologically
soteriological1763857_soteriological_
stereological1655657ster__eological_
synecological21104117sy__necological_
teratological1656117_ter_atological_
terminological1953647_terminological_
topological1647407___to_pological_
toxicological2553957___toxicological_
tropologically2264187__tro_pologically
typological1946667ty____pological_
unchronological2362327unchro_nological_
urological1347757__ur___ological_
virological1746307_vir___ological_
zoological2246427___zo__ological_

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 Filter178691950240.1231452772.4
2DLD Change Limit950241528.61011036.5
3Display Results1521520.1261206.3
 (SQL Overall)1786911528.85920170.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.