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

225 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
paleobiologists20115721paleobiologists_
paleobiologist19156332paleobiologist__
paleobiologies1954893paleobiologi_es_
paleoecologists20124173paleoecologists_
paleontologists1884523paleontologists_
paleozoologists2763853paleozoologists_
paleobiologic2064764paleobiologi___c
paleobiological2264684paleobiologi_cal
paleoecologist19114724paleoecologist__
paleontologist1765144paleontologist__
paleozoologist2664194paleozoologist__
photobiologists2365124photobiologists_
radiobiologists19174254radiobiologists_
astrobiologists1873765astrobiologists_
cryobiologists2254105_cryobiologists_
exobiologists2355325__exobiologists_
hydrobiologists25134045hydrobiologists_
malariologists1773355mal_ariologists_
microbiologists22134815microbiologists_
neurobiologists18114315neurobiologists_
paleobiology2053535paleobiolog____y
paleobotanists1871985paleob_otanists_
paleoecologies1963555paleoecologi_es_
paleontologies17103885paleontologi_es_
paleozoologies2663185paleozoologi_es_
palynologists1954995pal__ynologists_
pathobiologies2274185pathobiologi_es_
photobiologist2266175photobiologist__
radiobiologist18154675radiobiologist__
sociobiologists2063625sociobiologists_
aerobiologies1655056_aerobiologi_es_
algologists1346146_al___gologists_
astrobiologist1784196astrobiologist__
audiologists1445616_a__udiologists_
bacteriologists2063256bacteriologists_
biologists1349436_____biologists_
cardiologists1765146ca__rdiologists_
cryobiologist2154526_cryobiologist__
deontologists1555926__deontologists_
dialectologists1992396diale_ctologists_
ecclesiologists2062356eccle_siologists_
electrologists1765616_electrologists_
epidemiologists2162496epide_miologists_
exobiologist2256206__exobiologist__
glaciologists1753946_gl_aciologists_
hydrobiologist24204506hydrobiologist__
lexicologists2374156__lexicologists_
malacologists1854406mal__acologists_
malariologist1693926mal_ariologist__
meteorologists1754186meteo_rologists_
microbiologist21135496microbiologist__
neurobiologist17124926neurobiologist__
nonbiologists1664716__nonbiologists_
paleobotanist1772326paleob_otanist__
paleoecologic2063326paleoecologi___c
paleoecological2263516paleoecologi_cal
paleologies1448576pale___ologi_es_
paleontologic1863696paleontologi___c
paleontological2063806paleontologi_cal
paleozoological2963226paleozoologi_cal
palynologist1856306pal__ynologist__
papyrologists2154086pa__pyrologists_
parasitologists1862806parasitologists_
pathologists1848366pa___thologists_
pedologists1548276p__e__dologists_
penologists1449596p__e__nologists_
petrologists1559136p__e_trologists_
phlebologies2054656phle_b_ologi_es_
phlebotomists2261846phle_b_otomists_
phonologists1848776p__ho_nologists_
photobiologies2265106photobiologi_es_
photogeologists22173596photogeologists_
phrenologists1956296phre__nologists_
physiologists22156016p__hysiologists_
planetologists1763626p_lanetologists_
pomologists1648986p___o_mologists_
proctologists1856806p__roctologists_
protozoologists2763016protozoologists_
psephologists2155296p_se_phologists_
psychobiologist2874366psychobiologist__
pteridologists18133726p_teridologists_
radiobiologies1863656radiobiologi_es_
radiologists1497356ra___diologists_
selenologists1455336sele__nologists_
semiologists1548226__se_miologists_
sociobiologist1964046sociobiologist__
sociologists1547946___sociologists_
speleologists1654326spele___ologists_
teleologists1347226tele___ologists_
aerobiological1955097_aerobiologi_cal
aetiologies1248977_a_e_tiologi_es_
algologist1248247_al___gologist__
angelologists1553377_a_ngelologists_
anthologists1648027_a__nthologists_
apologists1348887_a____pologists_
archaeologists20122807_archaeologists_
astrobiologies1763267astrobiologi_es_
audiologist1347247_a__udiologist__
bacteriologist1963697bacteriologist__
biologisms1545347_____biologisms_
biologist12412347_____biologist__
biologistic1654107_____biologistic
campanologists2152627ca_mpanologists_
cardiologist1656617ca__rdiologist__
cetologists1449167__ce__tologists_
chronobiologist2392787chronobiologist__
chronologists1966117_chro_nologists_
climatologists1983277_climatologists_
cosmologists1746417___cosmologists_
cryobiologies2153617_cryobiologi_es_
demonologists1755567__demonologists_
dendrologists1654087__dendrologists_
deontologist1457417__deontologist__
diabetologists18122817diabe__tologists_
dialectologist1882677diale_ctologist__
ecclesiologist1962607eccle_siologist__
ecologists13310927___e__cologists_
electrologist1657017_electrologist__
embryologists2153127___embryologists_
enologists11310627___e__nologists_
entomologists1655667_ento_mologists_
epidemiologist2062767epide_miologist__
ethnologists1647047___ethnologists_
ethologists1549027___e_thologists_
etymologists18156497___etymologists_
exobiologies2254407__exobiologi_es_
fetologists1547997__fe__tologists_
gemmologists1845237__ge_mmologists_
gemologists1577887__ge__mologists_
geologists1279167__ge___ologists_
gerontologists1654857_gerontologists_
glaciologist1654897_gl_aciologist__
gynecologists2053697gyne__cologists_
hematologists19217047__hematologists_
horologists1548967___ho_rologists_
hydrobiologies2473797hydrobiologi_es_
ideologists1346657_ide___ologists_
kremlinologists22141397_kremlinologists_
lexicologist2294917__lexicologist__
limnologists1545327__l_imnologists_
liturgiologists17141807liturgiologists_
malacologist1755637mal__acologist__
malariologies1652747mal_ariologi_es_
martyrologists2062897ma_rtyrologists_
meteorologist1654877meteo_rologist__
methodologists2153477metho_dologists_
metrologists1588827__me_trologists_
microbiologies2164987microbiologi_es_
monologists14410077___mo_nologists_
museologists1544747muse___ologists_
narratologists1553207na_rratologists_
necrologists1547877__ne_crologists_
nematologists16166597__nematologists_
neologists1139777__ne___ologists_
neonatologists1584187__neonatologists_
nephrologists1954987__nephrologists_
neurobiologies1763917neurobiologi_es_
neurologists1347647__ne_urologists_
nonbiologist1555917__nonbiologist__
numerologists1664017nume__rologists_
oceanologists1654307_oce_anologists_
oncologists1448077____oncologists_
ontologists1248907____ontologists_
oologists1039857____o__ologists_
orologists1149827____o_rologists_
osteologists1346767oste___ologists_
otologists1149637____o_tologists_
paleobotanies1761907paleob_otani_es_
paleoecology2062997paleoecolog____y
paleomagnetists2071837paleomagnetists_
paleontology1853297paleontolog____y
paleozoology2762627paleozoolog____y
palynologies1844877pal__ynologi_es_
papyrologist2055097pa__pyrologist__
parasitologist1763257parasitologist__
pathobiology2362967pathobiolog____y
pathologist17410667pa___thologist__
pedologist14410867p__e__dologist__
penologist13412847p__e__nologist__
petrologist14711887p__e_trologist__
pharmacologists2573647pharmacologists_
philologists1876687p___hilologists_
phlebotomist2162557phle_b_otomist__
phonologist17411567p__ho_nologist__
photobiologic2365157photobiologi___c
photobiological2564407photobiologi_cal
photogeologist21134627photogeologist__
phraseologists2053577p_hraseologists_
phrenologist1857917phre__nologist__
phycologists2367137p___hycologists_
physiologist21157327p__hysiologist__
planetologist1664507p_lanetologist__
pomologist15412047p___o_mologist__
prebiologic1884727p_re_biologi___c
prebiological2055937p_re_biologi_cal
primatologists19184347p_rimatologists_
proctologist1758967p__roctologist__
prologists13311177p_____rologists_
protozoologist2663867protozoologist__
psephologist2056607p_se_phologist__
psychobiologies2873727psychobiologi_es_
psychologists24127477p__sychologists_
pteridologist17144607p_teridologist__
radiobiologic1963527radiobiologi___c
radiobiological2163307radiobiologi_cal
radiologist1399497ra___diologist__
rheologists1547317_rhe___ologists_
seismologists16124197__seismologists_
selenologist1357007sele__nologist__
semiologist14410717__se_miologist__
serologists12410127__se__rologists_
sexologists1947257__se__xologists_
sociobiologies19103347sociobiologi_es_
sociologist1449887___sociologist__
speleologist1555747spele___ologist__
technologists19125707__technologists_
teleologist1249387tele___ologist__
teratologists1496587__teratologists_
topologists1447867___to_pologists_
toxicologists2353987___toxicologists_
tribologists1546167__trib_ologists_
volcanologists20122767vol_canologists_
vulcanologists2092307vul_canologists_
watercolorists19152037wate_rcolorists_
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.1231452772.4
2DLD Change Limit950242259.33010184.8
3Display Results2252250.1701323.5
 (SQL Overall)1786912259.62318569.2
 
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.