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 “phrenologists” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

277 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
phrenologists195629(None) 
phrenologist1857911phrenologist_
chronologists1966112chronologists
penologists1449592p__enologists
phonologists1848772ph_onologists
phrenologies1846312phrenologi_es
chronologist1857623chronologist_
enologists11310623___enologists
palynologists1954993palynologists
pedologists1548273p__edologists
penologist13412843p__enologist_
phenologies1749353ph_enologi_es
philologists1876683ph_ilologists
phonologist17411563ph_onologist_
phraseologists2053573phraseologists
phrenological2156333phrenological
phycologists2367133ph_ycologists
physiologists22156013physiologists
prologists13311173p_r__ologists
rheologists1547313rh_e_ologists
selenologists1455333selenologists
angelologists1553374angelologists
bryologists1745704_br_yologists
cardiologists1765144cardiologists
cetologists1449164__cetologists
chronologies1846414chronologi_es
demonologists1755564demonologists
ecologists13310924___ecologists
enologist10314124___enologist_
ethnologists1647044_ethnologists
fetologists1547994__fetologists
gemologists1577884__gemologists
geologists1279164__ge_ologists
gerontologists1654854gerontologists
gynecologists2053694gynecologists
herpetologists2083634herpetologists
histologists1646294_histologists
horologists1548964_h_orologists
hydrologists2046094_hydrologists
ideologists1346654_ide_ologists
immunologists18124494immunologists
iridologists1444684_iridologists
lichenologists2063034lichenologists
limnologists1545324_limnologists
monologists14410074__monologists
morphologists2154264morphologists
museologists1544744muse_ologists
myrmecologists2452784myrmecologists
neologists1139774__ne_ologists
nephrologists1954984nephr__ologists
numerologists1664014numerologists
oceanologists1654304oceanologists
orologists1149824_or__ologists
osteologists1346764oste_ologists
paleontologists1884524paleontologists
palynologist1856304palynologist_
papyrologists2154084papyrologists
pathologists1848374p_athologists
pedologist14410864p__edologist_
penologies13311234p__enologi_es
petrologists1559144p_etrologists
pharmacologists2573644pharmacologists
phenological2068054ph_enological
philologist1768434ph_ilologist_
phlebologies2054654phlebologi_es
phlebotomists2261844phlebotomists
phonologies17410004ph_onologi_es
phraseologist1954194phraseologist_
phrenology1944894phrenolog___y
phycologist2259184ph_ycologist_
physiologist21157324physiologist_
planetologists1763624planetologists
poenologies1448324p_oenologi_es
pomologists1648984p__omologists
proctologists1856814proctologists
prologist12315084p_r__ologist_
psephologists2155294psephologists
psychologists24127474psychologists
pteridologists18133724pteridologists
rheologist1449534rh_e_ologist_
selenologist1357004selenologist_
serologists12410124__serologists
sexologists1947254__sexologists
sinologists1257674__sinologists
speleologists1654324spele_ologists
technologists19125704technologists
teleologists1347224tele_ologists
teratologists1496594teratologists
theologises15106734th_e_ologises
threnodists1551944thren__odists
tribologists1546164_tribologists
urbanologists1653254urbanologists
urologists1148414_ur__ologists
virologists1546634vir__ologists
algologists1346145__algologists
analogists1147315___analogists
angelologist1454165angelologist_
anthologists1648035_anthologists
anthropologists2183415anthropologists
apologists1348885___apologists
archaeologists20122815archae_ologists
areologies1139825_are_ologi_es
audiologists1445615_audiologists
biologists1349435___biologists
bryologist1647385_br_yologist_
campanologists2152625campanologists
cardiologist1656625cardiologist_
cetologist13412255__cetologist_
chronologers1852485chronolog_ers
chronologic1955785chronologi__c
chronological2175955chronological
conchologists2154565conchologists
cosmetologists1953145cosmetologists
cosmologists1746415_cosmologists
criminologists1952975criminologists
cryptologists2155235cryptologists
cytologists1748015__cytologists
demonologist1657055demonologist_
dendrologists1654085dendrologists
deontologists1555925deontologists
dermatologists18134925dermatologists
diabetologists18122815diabetologists
ecologist12314145___ecologist_
embryologists2153125embryologists
enologies10312985___enologi_es
entomologists1655665entomologists
enzymologists2873115enzymologists
epidemiologists2162495epidemiologists
epistemologists2072125epistemologists
escapologists1853345escapologists
ethnologist1549265_ethnologist_
ethologists1549025__ethologists
etymologists18156495_etymologists
eulogists1046655___e_ulogists
exobiologists2355325exobiologists
fetologist14410405__fetologist_
futurologists1773075futurologists
gemmologists1845235_gemmologists
gemologist141010285__gemologist_
genealogists1452785__genealogists
geologist11611785__ge_ologist_
gerontologist1555985gerontologist_
glaciologists1753945glaciologists
graphologists20123835graphologists
gynecologist1954575gynecologist_
hematologists19217055hematologists
henotheists1754495_h_enotheists
herbologies1746565_herbologi_es
herpetologist1984795herpetologist_
hierologies1547065_hierologi_es
histologist1547985_histologist_
horologist14412365_h_orologist_
hydrologist1948335_hydrologist_
hymnologies2046105_hymnologi_es
hypnologies2046085_hypnologi_es
ichthyologists2662315ichthyologists
ideologist1248535_ide_ologist_
immunologist17135325immunologist_
iridologist1345795_iridologist_
kremlinologists22141395_kremlinologists
lexicologists2374155lexicologists
lichenologist1973915lichenologist_
limnologist1446685_limnologist_
malacologists1854405malacologists
martyrologists2062895martyrologists
menologies13310605__menologi_es
meteorologists1754185meteorologists
metrologists1588835_metrologists
mineralogists1652315mineralogists
mixologists2145685__mixologists
monologist13413615__monologist_
monologuists1553955__monologuists
morphologist2055505morphologist_
museologist1445805muse_ologist_
musicologists1853545musicologists
mycologists1947735__mycologists
myologists1648205___myologists
myrmecologist2353315myrmecologist_
mythologists2146895_mythologists
narratologists1553215narratologists
necrologists1547875_necrologists
nematologists16166605nematologists
neologisms1345485__ne_ologisms
neologist10712815__ne_ologist_
nephrologist1856305nephr__ologist_
neurologists1347645_neurologists
nonbiologists1664725nonbiologists
numerologist1574915numerologist_
oceanologist1555685oceanologist_
oenologies1139395__oenologi_es
ologists939445_____ologists
oncologists1448075__oncologists
ontologists1248905__ontologists
oologists1039855____oologists
orologist10313105_or__ologist_
osteologist1248565oste_ologist_
otologists1149635___otologists
paleobiologists20115735paleobiologists
paleoecologists20124175paleoecologists
paleologies1448585pale_ologi_es
paleontologist1765145paleontologist_
paleozoologists2763855paleozoologists
palynologies1844875palynologi_es
papyrologist2055095papyrologist_
paralogisms1654115par__alogisms
parasitologists1862805parasitologists
pathologist17410665p_athologist_
pedologies1439345p__edologi_es
penological1648875p__enological
petrologist14711885p_etrologist_
pharmacologist2464175pharmacologist_
pheneticists1953285ph_eneticists
phenocopies2055865ph_enocopi_es
phenocrysts2152095ph_eno_crysts
phenolics1645055ph_enol__i_cs
phenology1846995ph_enolog___y
phenomenologist2382685phenomenologist_
philologies1747205ph_ilologi_es
phlebotomist2162555phlebotomist_
phonologic1857945ph_onologi__c
phonological2058375ph_onological
photobiologists2365175photobiologists
photogeologists22173645photogeologists
phraseologies1953275phraseologi_es
phrenitises1644495phren__itises
phycologies2247785ph_ycologi_es
physiologies2155365physiologi_es
phytologies2049045ph_ytologi_es
piccoloists1752775p_iccolo_ists
planetologist1664505planetologist_
poloists10910525p____olo_ists
pomologist15412045p__omologist_
primatologists19184355primatologists
proctologist1758965proctologist_
prologizes2248115p_r__ologizes
prosodists1345945p_r__osodists
psephologist2056605psephologist_
psychologises24136165psychologises
psychologisms26124775psychologisms
psychologist23109115psychologist_
pteridologist17144605pteridologist_
pyrologies16310015pyr__ologi_es
radiologists1497365_radiologists
rheologies1488435rh_e_ologi_es
rhinologies1546505rh_inologi_es
seismologists16124195seismologists
selenologies1345285selenologi_es
semiologists1548225_semiologists
serologist11413155__serologist_
sexologist1849515__sexologist_
sinologist11510665__sinologist_
sociologists1547945_sociologists
speleologist1555745spele_ologist_
technologist18137405technologist_
teleologist1249385tele_ologist_
teratologist13108575teratologist_
thanatologists1852865thanatologists
theologians1552945th_e_ologians
theologies141010105th_e_ologi_es
theologise14117745th_e_ologis_e
theologised16124155th_e_ologised
theologizes24106065th_e_ologizes
threnodist1453205thren__odist_
topologists1447865__topologists
toxicologists2353985toxicologists
tribologist1447725_tribologist_
trichologists1955425trichologists
typologists1746815__typologists
ufologists1445425___ufologists
uranologies1246135_uranologi_es
urbanologist1554045urbanologist_
urologist10411055_ur__ologist_
venologies1438375__venologi_es
virologist1448815vir__ologist_
volcanologists20122765volcanologists
vulcanologists2092305vulcanologists
zoologists2047175___zoologists

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 Filter1786911247900.390458182.1
2DLD Change Limit1247902779.18613584.8
3Display Results2772770.1901457.9
 (SQL Overall)1786912779.76618297.3
 
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.