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

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

183 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
gemmologies174524(None) 
gemologies1449001ge_mologies
gemmologist1746542gemmologist
gemmologists1845232gemmologists
geologies11410642ge__ologies
semiologies1448802semiologies
aerologies11312023ae_rologies
aetiologies1248983aetiologies
anemologies1446923anemologies
cetologies13410853ce_tologies
cosmologies1646703cosmologies
demonologies1645503demonologies
ecologies12312353_e_cologies
enologies10312983_e_nologies
ethologies14310543_ethologies
etiologies1139413_etiologies
etymologies17176803etymologies
fetologies1439183fe_tologies
garbologies1544883garbologies
gemmology1843953gemmolog__y
gemologist141010283ge_mologist
gemologists1577883ge_mologists
genealogies1353573genealogies
geologizes2146793ge__ologizes
hematologies1847563hematologies
herbologies1746563herbologies
homologies16311523_homologies
hymnologies2046103hymnologies
limnologies1445533limnologies
mammalogies1552463mammalogies
menologies13310603me_nologies
metrologies1449583metrologies
myologies1539753__myologies
necrologies1447983necrologies
nematologies1546693nematologies
neologies10411713ne__ologies
nephologies1747353nephologies
neurologies1248233neurologies
nomologies1339473_nomologies
oecologies1339463oe_cologies
oenologies1139393oe_nologies
pedologies1439343pe_dologies
penologies13311233pe_nologies
petrologies1449893petrologies
pomologies15310043_pomologies
seismologies1543903seismologies
semeiologies1545303semeiologies
serologies11311333se_rologies
sexologies1837713se_xologies
symbologies1945173symbologies
teleologies1247513teleologies
venologies1438373ve_nologies
zymologies2546413_zymologies
acarologies1446064acarologies
agrologies1237694_agrologies
algologies1246794_algologies
andrologies1346114andrologies
angelologies1453014ange_lologies
angiologies1346134angiologies
anthologies151012014anthologies
apiologies1339064_apiologies
apologies12311194__apologies
areologies1139824_areologies
astrologies1247924astrologies
audiologies1345624audiologies
axiologies1837484_axiologies
biologies12311184__biologies
bryologies1646044_bryologies
carpologies1646404carpologies
cohomologies2054054cohomologies
coprologies1646944coprologies
cytologies1639264_cytologies
demagogies1593674de_magogies
dendrologies1553794dendrologies
deontologies1445414deontologies
dermatologies1755254dermatologies
doxologies1946324_doxologies
embolies1239154_embol__ies
embryologies2053164_embryologies
entomologies1575324entomologies
enzymologies2752954enzymologies
ethnologies1547984ethnologies
etymologise17185254etymologise
etymologises18174734etymologises
etymologizes27143934etymologizes
eulogies938524_e__ulogies
gemmules13183214gemmul___es
gemological1747024ge_mological
gemology1546164ge_molog__y
geologer1044484ge__olog_er
geologers1143624ge__ologers
geologic1247794ge__ologi_c
geologist11611784ge__ologist
geologists1279164ge__ologists
geologize2046364ge__ologize
geologized2245414ge__ologized
gerontologies1584434gerontologies
glaciologies1663684glaciologies
graphologies1963734graphologies
gynecologies1953444gynecologies
hagiologies1645344hagiologies
haplologies1744764haplologies
hierologies1547064hierologies
histologies1546634histologies
homologizes2646144_homologizes
homologues1645494_homologues
horologies14411054_horologies
hydrologies1948184hydrologies
hypnologies2046084hypnologies
ichnologies1746364ichnologies
iconologies1447094iconologies
ideologies1237334_ideologies
immunologies1774304immunologies
iridologies1344584iridologies
karyologies1944444karyologies
lexicologies2253634lexicologies
lithologies1546834lithologies
misologies13139064_misologies
mixologies20136584_mixologies
monologies13312544_monologies
museologies1444544museologies
mycologies1848864_mycologies
mythologies2047844mythologies
neologizes2047244ne__ologizes
nephrologies1845074nephrologies
nosologies1148104_nosologies
nostologies1246584nostologies
numerologies1563424numerologies
oceanologies1554234oceanologies
oinologies1148304_oinologies
ologies8615024____ologies
oncologies1348654_oncologies
ontologies1139884_ontologies
oologies9312994___oologies
ophiologies1746014ophiologies
orismologies1553294orismologies
orologies10311624__orologies
osteologies1247054osteologies
otologies10311404__otologies
paleologies1448584paleologies
pathologies1748734pathologies
phenologies1749354phenologies
philologies1747204philologies
phonologies17410004phonologies
phycologies2247784phycologies
phytologies2049044phytologies
poenologies1448324poenologies
posologies1349544_posologies
psephologies2044844psephologies
pyrologies16310014_pyrologies
radiologies1347804radiologies
rheologies1488434_rheologies
rhinologies1546504rhinologies
sarcologies1446434sarcologies
scatologies1446864scatologies
selenologies1345284selenologies
semasiologies1652994semasiologies
semicolonies1653564semicolonies
semiologist14410714semiologist
semiologists1548224semiologists
sinologies1148894_sinologies
sitologies1148704_sitologies
sociologies1447804sociologies
somatologies1546234somatologies
speleologies1553884speleologies
stereologies1345914stereologies
tautologies1245914tautologies
technologies1845974technologies
teratologies1346874teratologies
terminologies1653444terminologies
tetralogies1245084tetralogies
theologies141010104_theologies
tocologies1349764_tocologies
tokologies1547144_tokologies
topologies1348974_topologies
tribologies1446124tribologies
tropologies1447734tropologies
typologies1647644_typologies
ufologies1345984__ufologies
uranologies1246134uranologies
urologies1039534__urologies
virologies1447214_virologies
zoologies1939014__zoologies

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 Filter1786911488190.420425454.8
2DLD Change Limit1488191838.17318208.6
3Display Results1831830.1101663.6
 (SQL Overall)1786911838.70320532.1
 
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.