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

136 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
osteologists134676(None) 
osteologist1248561osteologist_
ontologists1248902ont_ologists
osteologies1247052osteologi_es
otologists1149632o_t_ologists
anthologists1648033anthologists
cetologists1449163cet_ologists
cosmetologists1953143cosmetologists
cosmologists1746413cos_mologists
cytologists1748013cyt_ologists
ethologists1549023_ethologists
fetologists1547993fet_ologists
geologists1279163__geologists
histologists1646293hist_ologists
ideologists1346653_ideologists
metrologists1588833metrologists
museologists1544743museologists
mythologists2146893mythologists
neologists1139773__neologists
oncologists1448073o_ncologists
ontologist11411363ont_ologist_
oologists1039853o___ologists
orologists1149823o__rologists
osteological1546373osteological
otologist10412813o_t_ologist_
pathologists1848373pathologists
petrologists1559143petrologists
rheologists1547313_rheologists
serologists12410123_serologists
sexologists1947253_sexologists
sinologists1257673_sinologists
sociologists1547943sociologists
teleologists1347223teleologists
algologists1346144_algologists
angelologists1553374angelologists
anthologist15410464anthologist_
apologists1348884__apologists
astrologies1247934astrologi_es
audiologists1445614audiologists
biologists1349434__biologists
bryologists1745704_bryologists
cetologist13412254cet_ologist_
conchologists2154564conchologists
cosmetologist1853974cosmetologist_
cosmologist1648374cos_mologist_
cytologist16410534cyt_ologist_
deontologists1555924deont_ologists
ecologists13310924__ecologists
enologists11310624__enologists
entomologists1655664entomologists
epistemologists2072124epistemologists
escapologists1853344escapologists
ethnologists1647044ethnologists
ethologist14411894_ethologist_
etymologists18156494etymologists
eulogists1046654___eulogists
fetologist14410404fet_ologist_
futurologists1773074futurologists
gemmologists1845234gemmologists
gemologists1577884_gemologists
genealogists1452784genealogists
geologist11611784__geologist_
gynecologists2053694gynecologists
histologist1547984hist_ologist_
horologists1548964_horologists
hydrologists2046094hydrologists
ideologist1248534_ideologist_
iridologists1444684iridologists
limnologists1545324limnologists
meteorologists1754184meteorologists
metrologist14511234metrologist_
mixologists2145684_mixologists
monologists14410074_monologists
morphologists2154264morphologists
museologist1445804museologist_
musicologists1853544musicologists
mycologists1947734_mycologists
myologists1648204__myologists
mythologist2059004mythologist_
necrologists1547874necrologists
neologisms1345484__neologisms
neologist10712814__neologist_
neurologists1347644neurologists
nonbiologists1664724nonbiologists
nostalgists1252644nost_al_gists
nostologies1246584nost_ologi_es
numerologists1664014numerologists
oceanologists1654304oceanologists
ologists939444____ologists
oncologist13410414o_ncologist_
ontologies1139884ont_ologi_es
oologist9313494o___ologist_
ornithologists1852594ornithologists
orologist10313104o__rologist_
osteoblasts1363214osteo_blasts
osteoclasts1372794osteo_clasts
osteology1365764osteolog___y
osteoporoses1462034osteoporoses
osteoporosis1462034osteoporosis
osteosises1044524oste__osises
osteotomies1354894osteotomi_es
otologies10311404o_t_ologi_es
pathologist17410664pathologist_
pedologists1548274_pedologists
penologists1449594_penologists
petrologist14711884petrologist_
philologists1876684philologists
phonologists1848774phonologists
phrenologists1956294phrenologists
phycologists2367134phycologists
pomologists1648984_pomologists
proctologists1856814proct_ologists
prologists13311174__prologists
psephologists2155294psephologists
psychologists24127474psychologists
radiologists1497374radiologists
rheologist1449534_rheologist_
selenologists1455334selenologists
semiologists1548224semiologists
serologist11413154_serologist_
sexologist1849514_sexologist_
sinologist11510664_sinologist_
sociologist1449884sociologist_
soloists869154_s__olo_ists
speleologists1654324speleologists
syllogists14175174_s_yllogists
teleologist1249384teleologist_
theologises15106734_theologises
topologists1447864_topologists
toxicologists2353984toxicologists
tribologists1546164tribologists
typologists1746814_typologists
ufologists1445424__ufologists
urologists1148414__urologists
virologists1546634_virologists
zoologists2047174__zoologists

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 Filter1786911247900.420425454.8
2DLD Change Limit1247901368.40614845.3
3Display Results1361360.0801700.0
 (SQL Overall)1786911368.90620064.1
 
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.