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

146 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
photobiological256445(None) 
photobiologic2365202photobiologic__
photogeological2463102photogeological
paleobiological2264733paleobiological
photobiologies2265153photobiologi_es
photobiologist2266223photobiologi_st
photobiologists2365173photobiologists
aerobiological1955134_aerobiological
cryobiological2463924_cryobiological
exobiological2554724__exobiological
hydrobiological2763584hydrobiological
microbiological2464374microbiological
neurobiological20123924neurobiological
nonbiological1855264_no_nbiological
phonological2058374ph__o_nological
photobiology2384014photobiolog___y
photogeologic2263734photogeologic__
physiological2455574ph__ysiological
prebiological2055974p__rebiological
radiobiological2163344radiobiological
sociobiological2273514sociobiological
soteriological1763894_soteriological
abiological1647835____abiological
bacteriological2282865bacteriological
biological15128885_____biological
chronobiologic2472015chronobiologic__
chronological2175955ch_ro_nological
cohomological2354085_coho_mological
entomological1855035_ento_mological
etiological1448415__et__iological
hagiological1955815_h__agiological
homological1948445_h__o_mological
horological1748285_h__o_rological
paleobiologic2064785paleobiologic__
paleoecological2263555paleoecological
paleontological2063845paleontological
paleozoological2963265paleozoological
pathological2047975p_at__hological
petrological1758595p_et__rological
pharmacological2793545pharmacological
phenological2068055ph___enological
philological2046375ph___ilological
photogeologies2163895photogeologi_es
photogeologist21134675photogeologi_st
photogeologists22173645photogeologists
phraseological2283695ph_raseological
phrenological2156335ph__renological
phycological2546945ph___ycological
pomological1848035p___o_mological
proctological2055825p__roctological
pteridological2053595p__teridological
sociological1747505___sociological
topological1647435___to_pological
toxicological2553985___toxicological
tribological1745985___tribological
anthological1847506_ant__hological
antilogical1447266_ant__i_logical
astrological1547026_ast__rological
audiological1665666___audiological
autecological1854436_aut_ecological
axiological2146876____axiological
biologicals16105026_____biologicals
cardiological1954976__cardiological
chronobiologies2362106chronobiologi_es
chronobiologist2392796chronobiologi_st
codicological1853896_co_dicological
cosmological1946086___cosmological
cytological1947456_cyt___ological
demonological1954966_demo_nological
deontological1755176__deontological
ecclesiological1992316ecclesiological
epidemiological23172606epidemiological
epistemological22101946epist_emological
ethnological1846816__et_hnological
ethological1748196__et__hological
etymological2045876__et_ymological
futurological1952986_fut_urological
gerontological1854176_gerontological
glaciological1963916__glaciological
hematological2155946_h_ematological
herpetological2253326_herpetological
histological1846086_h__istological
hydrological2246486_h__ydrological
ichthyological2882456icht_hyological
iconological1756026__ico_nological
lithological1845896_lit__hological
meteorological1953786_meteorological
methodological2353306_methodological
metrological1748376_met__rological
microbiologic2264526microbiologic__
morphological2353966_mo_rphological
mythological2346906_myt__hological
nomological1648076___no_mological
nonbiologically2383066_no_nbiologically
nonideological1862526_nonideological
nontheological2063216_nontheological
nosological1447376___no_sological
oncological1647256____oncological
ontological1448316____ontological
oological1248326____o__ological
orismological1853626__orismological
osteological1546376__o_steological
paleobiologies1954906paleobiologi_es
paleobiologist19156346paleobiologi_st
paleobiologists20115736paleobiologists
palynological2154676p__alynological
parasitological2062776parasitological
pathobiologies2274196pathobiologi_es
pedological1757616p____edological
penological1648876p____enological
phonologic1857946ph__o_nologic__
phonologically2555556ph__o_nologically
photochemical27124976photo__chemical
photogeology2263306photogeolog___y
photomechanical2971886photomechanical
photovoltaic2263086photo_voltaic__
photovoltaics2362626photo_voltaic_s
physiologic2254716ph__ysiologic__
physiologically2993606ph__ysiologically
planetological1953176p_lanetological
postbiblical2081266p_ostbibl__ical
praxeological2554436p__raxeological
prebiologic1884736p__rebiologic__
primatological2183216p_rimatological
protozoologies2663166protozoologi_es
protozoologist2663886protozoologi_st
protozoologists2763036protozoologists
psephological2354986p__sephological
psychobiologic2963726psychobiologic__
psychological2656596p__sychological
radiobiologic1963536radiobiologic__
radiological1646986___radiological
rheological17127476rh____eological
scatological1745546scat___ological
semasiological1983016_semasiological
semiological1747786___semiological
somatological1854886_so_matological
stereological1655676__stereological
tautological1555486___tautological
teleological1546576___teleological
thanatological2062506th_anatological
theological1798266___t_heological
tropological1746636___tropological
typological1946686___t_ypological
volcanological2262226_volcanological
zoological2246446___zo__ological

Search took 8 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.356501941.0
2DLD Change Limit950241467.03313511.2
3Display Results1461460.1101327.3
 (SQL Overall)1786911467.49923828.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.