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

247 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
ichthyologists266231(None) 
ichthyologist2562781ichthyologist_
ichthyologies2552292ichthyologi_es
ichthyological2882453ichthyological
anthologists1648034_anth_ologists
cetologists1449164_cet__ologists
chronologists1966114_chronologists
cytologists1748014_cyt__ologists
ethnologists1647044__ethnologists
ethologists1549024__eth_ologists
ichthyology2652164ichthyolog___y
lichenologists2063034lich_enologists
mythologists2146894_myth_ologists
pathologists1848374_path_ologists
victimologists2262254vic_timologists
anthologist15410465_anth_ologist_
archaeologists20122815arch_aeologists
bryologists1745705___bryologists
cardiologists1765145_cardiologists
cetologist13412255_cet__ologist_
chronologist1857625_chronologist_
conchologists2154565_conchologists
cosmologists1746415_c_osmologists
cryptologists2155235_cryptologists
cytologist16410535_cyt__ologist_
ecologists13310925ec____ologists
embryologists2153125_embryologists
entomologists1655665_entomologists
ethnologist1549265__ethnologist_
ethologist14411895__eth_ologist_
etymologists18156495__etymologists
fetologists1547995_fet__ologists
futurologists1773075_futurologists
graphologists20123835graph_ologists
histologists1646295__histologists
horologists1548965__h_orologists
hydrologists2046095__hydrologists
ichnologies1746365ic__hnologi_es
ichthyoids2251895ichthy__o_i_ds
ideologists1346655i___deologists
immunologists18124495i_mmunologists
iridologists1444685i__ridologists
lichenologist1973915lich_enologist_
martyrologists2062895martyrologists
methodologists2153475methodologists
metrologists1588835_met_rologists
microbiologists22134815microbiologists
morphologists2154265morph_ologists
myologists1648205____myologists
mythologist2059005_myth_ologist_
nephrologists1954985_nephrologists
oceanologists1654305oc_eanologists
ontologists1248905_ont__ologists
ornithologists1852595ornith_ologists
osteologists1346765_ost_eologists
otologists1149635__ot__ologists
pathologist17410665_path_ologist_
petrologists1559145_pet_rologists
philologists1876685_ph_ilologists
phonologists1848775_ph_onologists
phrenologists1956295_phrenologists
phycologists2367135_ph_ycologists
physiologists22156015_physiologists
psephologists2155295pseph_ologists
psychologists24127475psych_ologists
rheologists1547315___rheologists
technologists19125705_technologists
theologises15106735___theologises
topologists1447865___topologists
trichologists1955425trich_ologists
typologists1746815___typologists
victimologist2162625vic_timologist_
algologists1346146___algologists
angelologists1553376_angelologists
anthologies151012016_anth_ologi_es
anthologizes253038396_anth_ologizes
anthropologists2183416anthropologists
apologists1348886____apologists
archaeologist19113496arch_aeologist_
audiologists1445616__audiologists
bacteriologists2063256bacteriologists
biologists1349436____biologists
bryologist1647386___bryologist_
campanologists2152626campanologists
cardiologist1656626_cardiologist_
cetologies13410856_cet__ologi_es
chiropodists2062396_ch_iropodists
chronologies1846416_chronologi_es
climatologists1983286climatologists
colonists112512506_c____olonists
colorists112313596_c____olorists
conchologist2055816_conchologist_
cosmetologists1953146cosmetologists
cosmologist1648376_c_osmologist_
criminologists1952976criminologists
cryobiologists2254106cryobiologists
cryptologist2056436_cryptologist_
cytologies1639266_cyt__ologi_es
demonologists1755566_demonologists
dendrologists1654086_dendrologists
deontologists1555926_deontologists
dermatologists18134926dermatologists
diabetologists18122816diabetologists
dialectologists1992396dialectologists
dichotomists2093226dic__h_otomists
ecclesiologists2062356ecclesiologists
ecologist12314146ec____ologist_
electrologists1765656electrologists
embryologist2053886_embryologist_
enologists11310626____enologists
entomologist1556976_entomologist_
enzymologists2873116_enzymologists
epistemologists2072126epistemologists
escapologists1853346_escapologists
ethnologies1547986__ethnologi_es
ethologies14310546__eth_ologi_es
etymologises18174736__etymologises
etymologist17158026__etymologist_
exobiologists2355326_exobiologists
fetologist14410406_fet__ologist_
futurologist1673506_futurologist_
gemmologists1845236__gemmologists
gemologists1577886___gemologists
geohydrologists2461526geohydrologists
geologists1279166____geologists
gerontologists1654856gerontologists
glaciologists1753946_glaciologists
graphologist19114866graph_ologist_
gynecologists2053696_gynecologists
hematologists19217056_hematologists
herpetologists2083636herpetologists
histologist1547986__histologist_
horologist14412366__h_orologist_
hydrologist1948336__hydrologist_
ichthyofaunas2781336ichthyo_faunas
ichthyoid2152316ichthy__o_i__d
ichthyophagous2781086ichthyophagous
ichthyosaurians26191356ichthyosaurians
ichthyosaurs2371546ichthy__osaurs
iconologies1447096ic__onologi_es
ideologist1248536i___deologist_
immunologist17135326i_mmunologist_
iridologist1345796i__ridologist_
lexicologists2374156_lexicologists
lichenologies1952916lich_enologi_es
limnologists1545326__limnologists
lithologies1546836_lith_ologi_es
liturgiologists17141806liturgiologists
malacologists1854406_malacologists
malariologists1773356malariologists
martyrologist1953326martyrologist_
meteorologists1754186meteorologists
methodologist2054316methodologist_
metrologist14511236_met_rologist_
microbiologist21135496microbiologist_
mixologists2145686___mixologists
monologists14410076___monologists
morphologist2055506morph_ologist_
museologists1544746__museologists
musicologists1853546_musicologists
mycologists1947736___mycologists
myologist15411096____myologist_
myrmecologists2452786myrmecologists
mythologies2047846_myth_ologi_es
mythologizes3054616_myth_ologizes
narratologists1553216narratologists
necrologists1547876__necrologists
nematologists16166606_nematologists
neologists1139776____neologists
neonatologists1584196neonatologists
nephrologist1856306_nephrologist_
neurologists1347646__neurologists
nonbiologists1664726_nonbiologists
numerologists1664016_numerologists
oceanologist1555686oc_eanologist_
ologists939446______ologists
oncologists1448076___oncologists
onomatologists1753336onomatologists
ontologist11411366_ont__ologist_
oologists1039856_____oologists
ophthalmologist26101786ophthalmologist_
ornithologist1753326ornith_ologist_
orologists1149826____orologists
osteologist1248566_ost_eologist_
otologist10412816__ot__ologist_
palynologists1954996_palynologists
papyrologists2154086_papyrologists
pathologies1748736_path_ologi_es
pedologists1548276___pedologists
penologists1449596___penologists
petrologist14711886_pet_rologist_
philologist1768436_ph_ilologist_
phonologist17411566_ph_onologist_
photobiologists2365176photobiologists
photogeologists22173646photogeologists
phraseologists2053576phraseologists
phrenologist1857916_phrenologist_
phycologist2259186_ph_ycologist_
physiologist21157326_physiologist_
piccoloists1752776pic___colo_ists
planetologists1763626planetologists
pomologists1648986___pomologists
primatologists19184356primatologists
proctologists1856816_proctologists
prologists13311176____prologists
protozoologists2763036protozoologists
psephologist2056606pseph_ologist_
psychologises24136166psych_ologises
psychologisms26124776psych_ologisms
psychologist23109116psych_ologist_
pteridologists18133726pteridologists
radiologists1497376__radiologists
rheologist1449536___rheologist_
scatologies1446866scat__ologi_es
seismologists16124196_seismologists
selenologists1455336_selenologists
semiologists1548226__semiologists
serologists12410126___serologists
sexologists1947256___sexologists
sinologists1257676___sinologists
sociobiologists2063626sociobiologists
sociologists1547946__sociologists
speleologists1654326_speleologists
syllogists14175176____syllogists
technologist18137406_technologist_
teleologists1347226__teleologists
teratologists1496596_teratologists
thanatologists1852866thanatologists
theologians1552946___theologians
theologies141010106___theologi_es
theologise14117746___theologis_e
theologised16124156___theologised
theologizes24106066___theologizes
topologist13410646___topologist_
toxicologists2353986_toxicologists
tribologists1546166__tribologists
trichologist1856746trich_ologist_
typologist1648896___typologist_
ufologists1445426____ufologists
urbanologists1653256_urbanologists
urologists1148416____urologists
vexillologists2591746vexillologists
victimologies2151766vic_timologi_es
virologists1546636___virologists
volcanologists20122766volcanologists
vulcanologists2092306vulcanologists
zoologists2047176____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.373479064.3
2DLD Change Limit1247902479.14013653.2
3Display Results2472470.1731427.7
 (SQL Overall)1786912479.68618448.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.