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

186 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
photobiologists2365171photobiologists_
photobiologist2266222photobiologist__
photobiologies2265153photobiologi_es_
photogeologists22173643photogeologists_
paleobiologists20115734paleobiologists_
photobiologic2365204photobiologi___c
photobiological2564454photobiologi_cal
photogeologist21134674photogeologist__
protozoologists2763034protozoologists_
astrobiologists1873765astrobiologists_
chronobiologist2392795chronobiologist__
cryobiologists2254105_cryobiologists_
exobiologists2355325__exobiologists_
hydrobiologists25134045hydrobiologists_
microbiologists22134815microbiologists_
neurobiologists18114315neurobiologists_
nonbiologists1664725_no_nbiologists_
paleobiologist19156345paleobiologist__
phonologists1848775ph__o_nologists_
photobiology2384015photobiolog____y
photogeologies2163895photogeologi_es_
physiologists22156015ph__ysiologists_
protozoologist2663885protozoologist__
radiobiologists19174265radiobiologists_
sociobiologists2063625sociobiologists_
astrobiologist1784196astrobiologist__
bacteriologists2063256bacteriologists_
biologists1349436_____biologists_
chronobiologies2362106chronobiologi_es_
chronologists1966116ch_ro_nologists_
cryobiologist2154526_cryobiologist__
entomologists1655666_ento_mologists_
exobiologist2256206__exobiologist__
horologists1548966_h__o_rologists_
hydrobiologist24204506hydrobiologist__
microbiologist21135496microbiologist__
neurobiologist17124926neurobiologist__
nonbiologist1555916_no_nbiologist__
otologists1149636__ot___ologists_
paleobiologies1954906paleobiologi_es_
paleoecologists20124176paleoecologists_
paleontologists1884526paleontologists_
paleozoologists2763856paleozoologists_
pathobiologies2274196pathobiologi_es_
pathologists1848376p_at__hologists_
petrologists1559146p_et__rologists_
pharmacologists2573646pharmacologists_
philologists1876686ph___ilologists_
phonologist17411566ph__o_nologist__
photogeologic2263736photogeologi___c
photogeological2463106photogeologi_cal
phraseologists2053576ph_raseologists_
phrenologists1956296ph__renologists_
phycologists2367136ph___ycologists_
physiologist21157326ph__ysiologist__
pomologists1648986p___o_mologists_
proctologists1856816p__roctologists_
protozoologies2663166protozoologi_es_
psychobiologist2874366psychobiologist__
pteridologists18133726p__teridologists_
radiobiologist18154676radiobiologist__
sociobiologist1964046sociobiologist__
sociologists1547946___sociologists_
topologists1447866___to_pologists_
toxicologists2353986___toxicologists_
tribologists1546166___tribologists_
aerobiologies1655057_aerobiologi_es_
anthologists1648037_ant__hologists_
astrobiologies1763267astrobiologi_es_
audiologists1445617___audiologists_
bacteriologist1963697bacteriologist__
biologisms1545347_____biologisms_
biologist12412347_____biologist__
biologistic1654107_____biologistic
cardiologists1765147__cardiologists_
cetologists1449167_cet___ologists_
chronobiologic2472017chronobiologi___c
chronologist1857627ch_ro_nologist__
conchologists2154567_co_nchologists_
cosmetologists1953147_cosmetologists_
cosmologists1746417___cosmologists_
cryobiologies2153617_cryobiologi_es_
cytologists1748017_cyt___ologists_
demonologists1755567_demo_nologists_
deontologists1555927__deontologists_
ecclesiologists2062357ecclesiologists_
entomologist1556977_ento_mologist__
epidemiologists2162497epidemiologists_
epistemologists2072127epist_emologists_
ethnologists1647047__et_hnologists_
ethologists1549027__et__hologists_
etymologists18156497__et_ymologists_
exobiologies2254407__exobiologi_es_
fetologists1547997_fet___ologists_
futurologists1773077_fut_urologists_
geohydrologists2461527geohydrologists_
gerontologists1654857_gerontologists_
glaciologists1753947__glaciologists_
hematologists19217057_h_ematologists_
herpetologists2083637_herpetologists_
histologists1646297_h__istologists_
horologist14412367_h__o_rologist__
hydrobiologies2473807hydrobiologi_es_
hydrologists2046097_h__ydrologists_
ichthyologists2662317icht_hyologists_
liturgiologists17141807liturgiologists_
malariologists1773357_malariologists_
martyrologists2062897mart_yrologists_
meteorologists1754187_meteorologists_
methodologists2153477_methodologists_
metrologists1588837_met__rologists_
microbiologies2164987microbiologi_es_
monologists14410077___mo_nologists_
morphologists2154267_mo_rphologists_
mythologists2146897_myt__hologists_
neonatologists1584197neo_natologists_
neurobiologies1763917neurobiologi_es_
oceanologists1654307__oceanologists_
oncologists1448077____oncologists_
onomatologists1753337ono_matologists_
ontologists1248907____ontologists_
oologists1039857____o__ologists_
orologists1149827____o_rologists_
osteologists1346767__o_steologists_
otologist10412817__ot___ologist__
paleobiologic2064787paleobiologi___c
paleobiological2264737paleobiologi_cal
paleoecologist19114727paleoecologist__
paleontologist1765147paleontologist__
paleozoologist2664197paleozoologist__
palynologists1954997p__alynologists_
papyrologists2154087p__apyrologists_
parasitologists1862807parasitologists_
pathologist17410667p_at__hologist__
pedologists1548277p____edologists_
penologists1449597p____enologists_
petrologist14711887p_et__rologist__
pharmacologist2464177pharmacologist__
phenomenologist2382687phenomenologist__
philologist1768437ph___ilologist__
phlebologies2054657ph_leb_ologi_es_
phlebotomists2261847ph_leb_otomists_
phonologies17410007ph__o_nologi_es_
photochemists2584817photo__chemists_
photochromisms2872927photo_chromisms_
photodissociate23121327photodissociat_e
photogeology2263307photogeolog____y
photoionizes2655307photo_i__onizes_
photoperiodisms2581937photoperiodisms_
photoresists1754457phot___oresists_
phototropisms2264687photo__tropisms_
photovoltaics2362627photo_voltai_cs_
phraseologist1954197ph_raseologist__
phrenologist1857917ph__renologist__
phycologist2259187ph___ycologist__
physiologies2155367ph__ysiologi_es_
phytologies2049047phyt___ologi_es_
pictorialists1774117pictorial__ists_
planetologists1763627p_lanetologists_
pomologist15412047p___o_mologist__
primatologists19184357p_rimatologists_
probabilists1872957probabi_l__ists_
proctologist1758967p__roctologist__
prohibitionists2272077prohibitionists_
prologists13311177p_____rologists_
psephologists2155297p__sephologists_
psychobiologies2873727psychobiologi_es_
psychologists24127477p__sychologists_
pteridologist17144607p__teridologist__
radiobiologies1863657radiobiologi_es_
radiologists1497367___radiologists_
rheologists1547317rh____eologists_
rheumatologists2162257rheumatologists_
semiologists1548227___semiologists_
sociobiologies19103347sociobiologi_es_
sociologist1449887___sociologist__
soteriologies1453877_soteriologi_es_
teleologists1347227___teleologists_
thanatologists1852867th_anatologists_
topologist13410647___to_pologist__
toxicologist2254837___toxicologist__
tribologist1447727___tribologist__
typologists1746817___t_ypologists_
victimologists2262257vict_imologists_
volcanologists20122767_volcanologists_
zoologists2047177___zo__ologists_

Search took 10 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.360496363.9
2DLD Change Limit950241868.62611016.0
3Display Results1861860.1401328.6
 (SQL Overall)1786911869.12619580.4
 
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.