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

116 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
narratologists155321(None) 
narratologist1453831narratologist_
narratologies1452752narratologi_es
dermatologists18134923dermatologists
narratological1763093narratological
nematologists16166603n_ematologists
neonatologists1584193neonatologists
teratologists1496593_teratologists
archaeologists20122814_archaeologists
campanologists2152624campanologists
cardiologists1765144ca_rdiologists
climatologists1983284climatologists
cryptologists2155234_cryptologists
dermatologist1786464dermatologist_
gerontologists1654854gerontologists
hematologists19217054_hematologists
herpetologists2083634herpetologists
malacologists1854404ma_lacologists
malariologists1773354malariologists
martyrologists2062894martyrologists
narratology1552384narratolog___y
necrologists1547874necr__ologists
nematologist15208474n_ematologist_
neonatologist14135354neonatologist_
neurologists1347644neur__ologists
onomatologists1753334onomatologists
parasitologists1862804parasitologists
pharmacologists2573644pharmacologists
primatologists19184354primatologists
proctologists1856814_proctologists
teratologist13108574_teratologist_
thanatologists1852864thanatologists
urbanologists1653254_urbanologists
algologists1346145_a__lgologists
analogists1147315_a_na__logists
angelologists1553375_angelologists
anthologists1648035_a_nthologists
anthropologists2183415anthropologists
apologists1348885____apologists
archaeologist19113495_archaeologist_
audiologists1445615_a_udiologists
bryologists1745705__br_yologists
campanologist2053385campanologist_
cardiologist1656625ca_rdiologist_
cartoonists1384405ca_r_to_onists
cetologists1449165___cetologists
chronologists1966115_chronologists
climatologist1873945climatologist_
cosmetologists1953145cosmetologists
cryptologist2056435_cryptologist_
cytologists1748015___cytologists
deontologists1555925_deontologists
dermatologies1755255dermatologi_es
diabetologists18122815diabetologists
dialectologists1992395dialectologists
embryologists2153125embr_yologists
escapologists1853345_escapologists
fetologists1547995___fetologists
gerontologist1555995gerontologist_
graphologists20123835_graphologists
hematologist18219205_hematologist_
herpetologist1984795herpetologist_
histologists1646295__histologists
horologists1548965_hor__ologists
hydrologists2046095hydr__ologists
iridologists1444685__iridologists
malacologist1755635ma_lacologist_
malariologist1693925malariologist_
mammalogists1652165mamma__logists
martyrologist1953325martyrologist_
metrologists1588835metr__ologists
morphologists2154265_morphologists
myrmecologists2452785myrmecologists
necrologist14410135necr__ologist_
nematologies1546695n_ematologi_es
neologists1139775n____eologists
neonatologies1453825neonatologi_es
nephrologists1954985n_ephrologists
neurobiologists18114315neurobiologists
neurologist1249985neur__ologist_
nonbiologists1664725n_onbiologists
numerologists1664015n_umerologists
oceanologists1654305_oceanologists
onomatologist1654405onomatologist_
ontologists1248905___ontologists
ornithologists1852595_ornithologists
orologists1149825__or__ologists
otologists1149635____otologists
paleontologists1884525paleontologists
palynologists1954995pa_lynologists
papyrologists2154085pa_pyrologists
paralogisms1654115pa_ra__logisms
parasitologist1763255parasitologist_
pathologists1848375pa__thologists
petrologists1559145petr__ologists
pharmacologist2464175pharmacologist_
phraseologists2053575phraseologists
phrenologists1956295_phrenologists
planetologists1763625planetologists
primatologist18175315primatologist_
proctologist1758965_proctologist_
prologists13311175__pr__ologists
pteridologists18133725pteridologists
radiologists1497375__radiologists
rheologists1547315___rheologists
rheumatologists2162255rheumatologists
serologists12410125_ser__ologists
teratologies1346875_teratologi_es
thanatologist1753615thanatologist_
tribologists1546165__tribologists
trichologists1955425_trichologists
urbanologist1554045_urbanologist_
urologists1148415__ur__ologists
virologists1546635_vir__ologists
volcanologists20122765volcanologists
vulcanologists2092305vulcanologists

Search took 7 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.360496363.9
2DLD Change Limit950241165.73316574.9
3Display Results1161160.0761526.3
 (SQL Overall)1786911166.16928966.0
 
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.