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

202 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
paleoecologists2012417(None) 
paleoecologist19114721paleoecologist_
paleobiologists20115732paleobiologists
paleoecologies1963552paleoecologi_es
paleontologists1884522paleontologists
paleozoologists2763852paleozoologists
paleobiologist19156343paleobiologist_
paleoecologic2063323paleoecologi__c
paleoecological2263553paleoecological
paleontologist1765143paleontologist_
paleozoologist2664193paleozoologist_
lexicologists2374154__lexicologists
malacologists1854404mal__acologists
paleobiologies1954904paleobiologi_es
paleoecology2062994paleoecolog___y
paleontologies17103884paleontologi_es
paleozoologies2663184paleozoologi_es
palynologists1954994pal__ynologists
planetologists1763624p_lanetologists
algologists1346145_al___gologists
angelologists1553375_a_ngelologists
deontologists1555925__deontologists
dialectologists1992395diale_ctologists
ecologists13310925_____ecologists
electrologists1765645_electrologists
gynecologists2053695__gynecologists
lexicologist2294915__lexicologist_
malacologist1755635mal__acologist_
malariologists1773355mal_ariologists
meteorologists1754185meteo_rologists
myrmecologists2452785_myrmecologists
oncologists1448075____oncologists
paleobiologic2064785paleobiologi__c
paleobiological2264735paleobiological
paleobotanists1871985paleo_botanists
paleologies1448575pal__e_ologi_es
paleontologic1863695paleontologi__c
paleontological2063845paleontological
paleozoological2963265paleozoological
palynologist1856305pal__ynologist_
papyrologists2154085pa__pyrologists
parasitologists1862805parasitologists
pathologists1848375pa___thologists
pedologists1548275p____edologists
penologists1449595p____enologists
petrologists1559145p__e_trologists
pharmacologists2573645pharmacologists
phonologists1848775p__ho_nologists
photobiologists2365175photobiologists
photogeologists22173645photogeologists
phraseologists2053575phrase_ologists
phrenologists1956295p__hrenologists
phycologists2367135p___hycologists
planetologist1664505p_lanetologist_
pomologists1648985p___o_mologists
proctologists1856815p__roctologists
protozoologists2763035protozoologists
psephologists2155295p_se_phologists
pteridologists18133725p_teridologists
radiobiologists19174265radiobiologists
radioecologies1882705radioecologi_es
selenologists1455335__selenologists
speleologists1654325_spele_ologists
teleologists1347225__tele_ologists
watercolorists19152035wate_rcolorists
algologist1248246_al___gologist_
angelologist1454166_a_ngelologist_
anthologists1648036_a__nthologists
apologists1348886_a____pologists
archaeologists20122816_archaeologists
astrobiologists1873766astrobiologists
audiologists1445616_a__udiologists
autecologies1554576_a_utecologi_es
bacteriologists2063256bacteriologists
balneologies1553316bal_ne_ologi_es
campanologists2152626ca_mpanologists
cardiologists1765146ca__rdiologists
cetologists1449166____cetologists
chronologists1966116_chro_nologists
climatologists1983286_climatologists
conchologists2154566___conchologists
cosmetologists1953146_cosmetologists
cosmologists1746416___cosmologists
cryobiologists2254106_cryobiologists
demonologists1755566__demonologists
dendrologists1654086__dendrologists
deontologist1457416__deontologist_
diabetologists18122816_diabetologists
dialectologist1882676diale_ctologist_
ecclesiologists2062356eccle_siologists
ecologist12314146_____ecologist_
electrologist1657046_electrologist_
enologists11310626_____enologists
entomologists1655666_ento_mologists
epidemiologists2162496epide_miologists
epistemologists2072126epistemologists
ethnologists1647046___ethnologists
ethologists1549026___e_thologists
etymologists18156496___etymologists
exobiologists2355326__exobiologists
fetologists1547996____fetologists
gemmologists1845236__ge_mmologists
gemologists1577886____gemologists
genealogists1452786__gene_alogists
geologists1279166____ge_ologists
gerontologists1654856_gerontologists
glaciologists1753946_gl_aciologists
gynecologist1954576__gynecologist_
hematologists19217056__hematologists
herpetologists2083636_herpetologists
horologists1548966___ho_rologists
hydrobiologists25134046hydrobiologists
ideologists1346656___ide_ologists
lexicologies2253636__lexicologi_es
lichenologists2063036_lichenologists
limnologists1545326__l_imnologists
malacologies1754376mal__acologi_es
malariologist1693926mal_ariologist_
martyrologists2062896ma_rtyrologists
meteorologist1654876meteo_rologist_
methodologists2153476metho_dologists
metrologists1588836__me_trologists
microbiologists22134816microbiologists
monologists14410076___mo_nologists
museologists1544746__muse_ologists
musicologists1853546__musicologists
mycologists1947736____mycologists
myrmecologist2353316_myrmecologist_
narratologists1553216na_rratologists
necrologists1547876__ne_crologists
nematologists16166606__nematologists
neologists1139776____ne_ologists
neonatologists1584196__neonatologists
nephrologists1954986__nephrologists
neurobiologists18114316neurobiologists
neurologists1347646__ne_urologists
numerologists1664016__numerologists
oceanologists1654306_oce_anologists
oecologies1339466____oecologi_es
oncologist13410416____oncologist_
ontologists1248906____ontologists
oologists1039856____o__ologists
orologists1149826____o_rologists
osteologists1346766__oste_ologists
otologists1149636____o_tologists
paleobiology2053536paleobiolog___y
paleobotanist1772326paleo_botanist_
paleomagnetists2071846paleomagnetists
paleontology1853306paleontolog___y
paleozoology2762626paleozoolog___y
palynologies1844876pal__ynologi_es
papyrologist2055096pa__pyrologist_
parasitologist1763256parasitologist_
pathobiologies2274196pathobiologi_es
pathologist17410666pa___thologist_
pedologist14410866p____edologist_
penologist13412846p____enologist_
petrologist14711886p__e_trologist_
pharmacologist2464176pharmacologist_
phenomenologist2382686phenomenologist_
philologists1876686p___hilologists
phlebologies2054656phl__ebologi_es
phlebotomists2261846phl__ebotomists
phonologist17411566p__ho_nologist_
photobiologist2266226photobiologist_
photogeologist21134676photogeologist_
phraseologist1954196phrase_ologist_
phrenologist1857916p__hrenologist_
phycologist2259186p___hycologist_
physiologists22156016p__hysiologists
piccoloists1752776p___iccolo_ists
planetologies1653256p_lanetologi_es
pleochroisms2162026p_leo_chro_isms
poenologies1448326p___oenologi_es
pomologist15412046p___o_mologist_
primatologists19184356p_rimatologists
proctologist1758966p__roctologist_
prologists13311176p_____rologists
protozoologist2663886protozoologist_
psephologist2056606p_se_phologist_
psychologists24127476p__sychologists
pteridologist17144606p_teridologist_
radiobiologist18154676radiobiologist_
radiologists1497366ra___diologists
rheologists1547316___rhe_ologists
seismologists16124196__seismologists
selenologist1357006__selenologist_
semiologists1548226__se_miologists
serologists12410126____serologists
sexologists1947256____sexologists
sociobiologists2063626sociobiologists
sociologists1547946___sociologists
speleologist1555746_spele_ologist_
technologists19125706__technologists
teleologist1249386__tele_ologist_
teratologists1496596__teratologists
topologists1447866___to_pologists
toxicologists2353986__toxicologists
volcanologists20122766vol_canologists
vulcanologists2092306vul_canologists
watercolorist18182546wate_rcolorist_
zoologists2047176___zo__ologists

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.1061685764.2
2DLD Change Limit950242028.48611197.7
3Display Results2022020.1561294.9
 (SQL Overall)1786912028.74820426.5
 
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.