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

155 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
microbiological246437(None) 
microbiologic2264522microbiologic__
aerobiological1955133_aerobiological
cryobiological2463923__cryobiological
hydrobiological2763583hydrobiological
microbiologies2164983microbiologi_es
microbiologist21135493microbiologi_st
microbiologists22134813microbiologists
neurobiological20123923neurobiological
sociobiological2273513sociobiological
exobiological2554724__exobiological
iconological1756024_ic_o_nological
microbiology2263774microbiolog___y
paleobiological2264734paleobiological
photobiological2564454photobiological
prebiological2055974__prebiological
radiobiological2163344radiobiological
abiological1647835____abiological
bacteriological2282865bacteriological
biological15128885_____biological
cardiological1954975__cardiological
chronological2175955_chro_nological
codicological1853895__c_odicological
cosmological1946085__c_osmological
criminological21102775__criminological
cryptological2354795__cryptological
ecclesiological1992315ecclesiological
gerontological1854175_gerontological
ichthyological2882455_ichthyological
lichenological22112835lic_henological
meteorological1953785meteo_rological
methodological2353305metho_dological
metrological1748375metr___ological
microanalytical2481655microanalytical
microanatomical2371935microanatomical
microfilarial20142675microfi_lari_al
microscopical2063355micro__scopical
microsurgical2062465micro__surgical
morphological2353965m_or_phological
mycological2147115myc____ological
myrmecological2662645m_yrmecological
necrological1747285necr___ological
nonbiological1855265__nonbiological
proctological2055825__proctological
radiological1646985___radiological
sociological1747505___sociological
tribological1745985__trib_ological
tropological1746635__tro_pological
unchronological2362325unchro_nological
virological1746305vi_r___ological
aerobiologies1655056_aerobiologi_es
anthropological2373106anthro_pological
archaeological22152936arc_haeological
astrobiologies1763266astrobiologi_es
astrobiologist1784196astrobiologi_st
astrobiologists1873766astrobiologists
astrological1547026astr___ological
audiological1665666___audiological
axiological2146876____axiological
biologicals16105026_____biologicals
bryological1945376__br__yological
cohomological2354086__cohomological
cryobiologies2153616__cryobiologi_es
cryobiologist2154526__cryobiologi_st
cryobiologists2254106__cryobiologists
cytological1947456__c__ytological
demonological1954966_demo_nological
deontological1755176__deontological
dermatological2053856_dermatological
dialectological2162096dialectological
ecological1548706_ec____ological
embryological2353186embr__yological
entomological1855036_ento_mological
epidemiological23172606epidemiological
eschatological2262466esc_hatological
etiological1448416____etiological
glaciological1963916__glaciological
graphological2253526__graphological
hagiological1955816___hagiological
herpetological2253326_herpetological
histological1846086hi___stological
homological1948456___ho_mological
horological1748286___ho_rological
hydrobiologies2473806hydrobiologi_es
hydrobiologist24204506hydrobiologi_st
hydrobiologists25134046hydrobiologists
hydrological2246486hydr___ological
ideological15106646_i___deological
immunological2054016_i_mmunological
karyological2274736_kar__yological
limnological1745076li___mnological
lithological1845896li___thological
macrobiotic1953056macrobi__otic__
malacological2053976m__alacological
microbial1547156microb_____i_al
micrococcal1553876micr___oco_ccal
microeconomic2062596microeconomic__
microeconomics2172466microeconomic_s
microfilaria19143486microfi_lari_a_
microfilariae20142766microfi_lari_ae
microfloral1853846micro__flo__ral
microphysical2763186micro__physical
microspherical2582446micro_spherical
mineralogical1862286mi__neralogical
museological1754786m___useological
musicological2053546m__usicological
mythological2346906m___ythological
narratological1763096_narratological
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
petrological1758596petr___ological
pharmacological2793546pharmacological
phonological2058376__pho_nological
photobiologic2365206photobiologic__
photogeological2463106photogeological
phraseological2283696_phraseological
phrenological2156336_phr_enological
physiological2455576__physiological
pomological1848036___po_mological
praxeological2554436__praxeological
prebiologic1884736__prebiologic__
psychobiologic2963726psychobiologic__
pteridological2053596pter_idological
radiobiologic1963536radiobiologic__
rheological17127476___r_heological
scatological1745546_sc__atological
semasiological1983016_semasiological
semiological1747786___semiological
serological1468776_ser___ological
sinological1447136si____nological
sociobiologies19103346sociobiologi_es
sociobiologist1964046sociobiologi_st
sociobiologists2063626sociobiologists
soteriological1763896_soteriological
stereological1655676ster__eological
technological2155146tec__hnological
teratological1656116_ter_atological
terminological1953646_terminological
topological1647436___to_pological
toxicological2553986___toxicological
urological1347756__ur___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.343520965.0
2DLD Change Limit950241558.04611810.1
3Display Results1551550.1101409.1
 (SQL Overall)1786911558.49921024.9
 
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.