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

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

142 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
hydrobiological276358(None) 
aerobiological1955133_aerobiological
hydrobiologies2473803hydrobiologi_es
hydrobiologist24204503hydrobiologi_st
hydrobiologists25134043hydrobiologists
hydrological2246483hydr___ological
microbiological2464373microbiological
neurobiological20123923neurobiological
radiobiological2163343radiobiological
cryobiological2463924_cryobiological
exobiological2554724__exobiological
hydrobiology2562784hydrobiolog___y
paleobiological2264734paleobiological
photobiological2564454photobiological
prebiological2055974__prebiological
sociobiological2273514sociobiological
abiological1647835____abiological
audiological1665665aud___iological
biological15128885_____biological
cardiological1954975_car_diological
chronological2175955_chro_nological
deontological1755175__deontological
gerontological1854175_gerontological
hagiological1955815h___agiological
herpetological2253325h_erpetological
homological1948455h___o_mological
horological1748285h___o_rological
hydrocolloidal247915hydro_colloidal
hydrologic2046675hydr___ologic__
hydrologically27104505hydr___ologically
microbiologic2264525microbiologic__
myrmecological2662645my_rmecological
nonbiological1855265__nonbiological
physiological2455575phy___siological
proctological2055825__proctological
radiobiologic1963535radiobiologic__
radiological1646995___radiological
sociological1747505___sociological
tribological1745985__trib_ological
tropological1746635__tro_pological
aerobiologies1655056_aerobiologi_es
anthropological2373106anthro_pological
astrobiologies1763266astrobiologi_es
astrobiologist1784206astrobiologi_st
astrobiologists1873766astrobiologists
astrological1547026astr___ological
axiological2146876____axiological
bacteriological2282876bacteriological
biologicals16105026_____biologicals
bryological1945376__br__yological
chronobiologic2472016chronobiologic__
codicological1853896cod__icological
cohomological2354086_coho_mological
cosmological1946086___cosmological
criminological21102776__criminological
cryptological2354796__cryptological
cytological1947456cy____tological
demonological1954966__demonological
dendrological1853836__dendrological
dermatological2053856_dermatological
dialogical1445516__d___ialogical
ecclesiological1992316ecclesiological
embryological2353186embr__yological
entomological1855036_ento_mological
epidemiological23172606epidemiological
etiological1448416____etiological
glaciological1963916__glaciological
graphological2253526__graphological
gynecological22113786gy__necological
hematological2155946h__ematological
heroicomical2162616h_ero_i_comical
histological1846086h___istological
hydrodynamical2972346hydro_dynamical
hydrologies1948186hydr___ologi_es
hydrologist1948336hydr___ologi_st
hydrologists2046096hydr___ologists
hydromechanical3181616hydromechanical
hydrosolic1954616hydro_sol__ic__
hyperbolical2463866hyperb_ol__ical
hyperboloidal24132436hyperb_olo_idal
iconological1756026__ico_nological
ideological15106646_id___eological
karyological2274736_kar__yological
meteorological1953786meteo_rological
methodological2353306metho_dological
metrological1748376metr___ological
microbiologies2164986microbiologi_es
microbiologist21135496microbiologi_st
microbiologists22134816microbiologists
morphological2353966_mor_phological
mycological2147116my____cological
mythological2346906my___thological
narratological1763096_narratological
necrological1747286necr___ological
neurobiologies1763916neurobiologi_es
neurobiologist17124926neurobiologi_st
neurobiologists18114316neurobiologists
neurological1547336neur___ological
nomological1648076___no_mological
nosological1447376___no_sological
oncological1647256____oncological
ontological1448316____ontological
oological1248326____o__ological
orismological1853626__orismological
paleobiologic2064786paleobiologic__
paleoecological2263556paleoecological
paleontological2063846paleontological
paleozoological2963266paleozoological
parasitological2062776_parasitological
pedological1757616ped____ological
petrological1758596petr___ological
pharmacological2793546pharmacological
phonological2058376__pho_nological
photobiologic2365206photobiologic__
photogeological2463106photogeological
phraseological2283696_phraseological
phrenological2156336_phr_enological
phycological2546946phy____cological
pomological1848036___po_mological
praxeological2554436__praxeological
prebiologic1884736__prebiologic__
psychobiologic2963726psychobiologic__
pteridological2053596pter_idological
radiobiologies1863666radiobiologi_es
radiobiologist18154686radiobiologi_st
radiobiologists19174276radiobiologists
rheological17127476___r_heological
semasiological1983016_semasiological
semiological1747786___semiological
serological1468776_ser___ological
soteriological1763896_soteriological
stereological1655676ster__eological
synecological21104116sy__necological
teratological1656116_ter_atological
terminological1953646_terminological
topological1647436___to_pological
toxicological2553986___toxicological
typological1946686ty____pological
unchronological2362326unchro_nological
urological1347756__ur___ological
virological1746306_vir___ological
zoological2246446___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.420425454.8
2DLD Change Limit950241428.12611693.8
3Display Results1421420.1101290.9
 (SQL Overall)1786911428.65620643.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.