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

122 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
onomatologists175333(None) 
onomatologist1654401onomatologist_
nematologists16166602_nematologists
onomatologies1653382onomatologi_es
climatologists1983283climatologists
dermatologists18134923dermatologists
hematologists19217053_hematologists
nematologist15208473_nematologist_
neonatologists1584193neonatologists
ontologists1248903on___tologists
primatologists19184353primatologists
climatologist1873944climatologist_
cosmetologists1953144cosmetologists
deontologists1555924deo_ntologists
dermatologist1786464dermatologist_
entomologists1655664entom__ologists
hematologist18219204_hematologist_
narratologists1553214narratologists
nematologies1546694_nematologi_es
neonatologist14135354neonatologist_
nonbiologists1664724_nonbiologists
numerologists1664014_numerologists
oceanologists1654304o_ceanologists
oncologists1448074on___cologists
onomatology1752944onomatolog___y
onomatopoeias1781444onomatopoei_as
ontologist11411364on___tologist_
otologists1149634__o__tologists
pomologists1648984_pom__ologists
primatologist18175314primatologist_
proctologists1856814pro_ctologists
rheumatologists2162254rheumatologists
somatologies1546234_somatologi_es
teratologists1496594_teratologists
thanatologists1852864thanatologists
analogists1147315an__a__logists
angelologists1553375an_gelologists
anthologists1648035an__thologists
apologists1348885____apologists
archaeologists20122815archaeologists
campanologists2152625campanologists
cetologists1449165___cetologists
climatologies1852805climatologi_es
conchologists2154565_conchologists
cosmetologist1853975cosmetologist_
cosmologists1746415_co_smologists
criminologists1952975criminologists
cryptologists2155235_cryptologists
cytologists1748015___cytologists
demonologists1755565_demonologists
deontologist1457415deo_ntologist_
dermatologies1755255dermatologi_es
diabetologists18122815diabetologists
enologists11310625en____ologists
entomologist1556975entom__ologist_
enzymologists2873115en_zymologists
escapologists1853345_escapologists
etymologists18156495etym__ologists
exobiologists2355325exo_biologists
fetologists1547995___fetologists
gemmologists1845235_gem_mologists
gemologists1577885_gem__ologists
gerontologists1654855gerontologists
hematologies1847565_hematologi_es
herpetologists2083635herpetologists
histologists1646295__histologists
horologists1548965_ho__rologists
immunologists18124495_immunologists
limnologists1545325_lim_nologists
malacologists1854405_malacologists
mammalogists1652165mamma__logists
metrologists1588835___metrologists
mixologists2145685___mixologists
monologists14410075___monologists
monometallists1872375monometal_lists
morphologists2154265_morphologists
mycologists1947735___mycologists
myologists1648205___m_yologists
myrmecologists2452785myrmecologists
mythologists2146895___mythologists
narratologist1453835narratologist_
necrologists1547875_n_ecrologists
nematological1855665_nematological
neologists1139775_n___eologists
neonatologies1453825neonatologi_es
nephrologists1954985_nephrologists
neurologists1347645_n_eurologists
nomologies1339475_nom__ologi_es
nonbiologist1555915_nonbiologist_
nostalgists1252645_no_stal_gists
nostologies1246585_no_stologi_es
numerologist1574915_numerologist_
oceanologist1555685o_ceanologist_
oncologist13410415on___cologist_
onomatopoeia1671715onomatopoei__a
onomatopoeic1861625onomatopoei__c
ontologies1139885on___tologi_es
oologists1039855__o___ologists
ornithologists1852595ornithologists
orologists1149825__o__rologists
osteologists1346765__osteologists
otologist10412815__o__tologist_
pathologists1848375___pathologists
pharmacologists2573645pharmacologists
phonologists1848775pho__nologists
planetologists1763625planetologists
pneumatologies1962815pneumatologi_es
pomologist15412045_pom__ologist_
primatologies1863875primatologi_es
proctologist1758965pro_ctologist_
rheumatologist2062855rheumatologist_
semiologists1548225_sem_iologists
sociologists1547945_so_ciologists
somatological1854885_somatological
teratologist13108575_teratologist_
thanatologist1753615thanatologist_
topologists1447865_to__pologists
toxicologists2353985_toxicologists
urbanologists1653255_urbanologists
volcanologists20122765volcanologists
vulcanologists2092305vulcanologists
zoologists2047175_zo___ologists

Search took 8 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 Limit950241226.71614148.9
3Display Results1221220.0801525.0
 (SQL Overall)1786911227.15624970.8
 
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.