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

167 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
dialectologists199239(None) 
dialectologist1882681dialectologist_
diabetologists18122812diabe_tologists
dialectologies1892082dialectologi_es
diabetologist17133143diabe_tologist_
dialectological2162093dialectological
dialectology1961774dialectolog___y
electrologists1765654__electrologists
malacologists1854404_malac_ologists
paleontologists1884524_paleontologists
planetologists1763624plane_tologists
algologists1346145__al__gologists
cetologists1449165___ce_tologists
cosmetologists1953145cosme_tologists
deontologists1555925d__eontologists
dermatologists18134925d_ermatologists
dialogists1265605dia_____logists
ecclesiologists2062355ecclesiologists
ecologists13310925____ec_ologists
electrologist1657055__electrologist_
fetologists1547995___fe_tologists
glaciologists1753945__glaciologists
gynecologists2053695_gynec_ologists
herpetologists2083635herpe_tologists
histologists1646295hi___stologists
ideologists1346655_i_de__ologists
lichenologists2063035liche_nologists
malacologist1755635_malac_ologist_
malariologists1773355_malariologists
myrmecologists2452785myrmec_ologists
narratologists1553215_narratologists
necrologists1547875___necrologists
paleobiologists20115735_paleobiologists
paleoecologists20124175_paleoecologists
paleontologist1765145_paleontologist_
paleozoologists2763855_paleozoologists
palynologists1954995_pal_ynologists
planetologist1664505plane_tologist_
proctologists1856815__proctologists
selenologists1455335_sele_nologists
speleologists1654325spele__ologists
teleologists1347225_tele__ologists
thanatologists1852865tha_natologists
algologist1248246__al__gologist_
angelologists1553376__angelologists
anthologists1648036__a_nthologists
apologists1348886__a___pologists
audiologists1445616__a_udiologists
bacteriologists2063256bacteriologists
bidialectalisms22161396bidialectal__isms
biologists1349436bi_____ologists
biotechnologist2371566biotechnologist_
campanologists2152626_campanologists
cardiologists1765146_ca_rdiologists
cetologist13412256___ce_tologist_
climatologists1983286_climatologists
conchologists2154566__conchologists
cosmetologist1853976cosme_tologist_
cryptologists2155236__cryptologists
cytologists1748016____cytologists
demonologists1755566d__emonologists
dendrologists1654086d__endrologists
deontologist1457416d__eontologist_
dermatologist1786466d_ermatologist_
diabolists1354466dia___bol__ists
dialecticians1861786dialect__icians
dialectics1544216dialect____i_cs
diallists1056006dial____l__ists
dialogist1148276dia_____logist_
dichotomists2093226di___chotomists
ecclesiologist1962606ecclesiologist_
ecologist12314146____ec_ologist_
electrologies1656266__electrologi_es
enologists11310626____e_nologists
epidemiologists2162496epidemiologists
epistemologists2072126episte_mologists
ethologists1549026____ethologists
fetologist14410406___fe_tologist_
gemmologists1845236___gemmologists
gemologists1577886___ge_mologists
geologists1279166___ge__ologists
gerontologists1654856_gerontologists
glaciologist1654896__glaciologist_
graphologists20123836gra__phologists
gynecologist1954576_gynec_ologist_
hematologists19217056__hematologists
herpetologist1984796herpe_tologist_
histologist1547986hi___stologist_
ichthyologists2662316_ichthyologists
ideologist1248536_i_de__ologist_
immunologists18124496_i_mmunologists
iridologists1444686_i__ridologists
lexicologists2374156___lexicologists
lichenologist1973916liche_nologist_
limnologists1545326___limnologists
liturgiologists17141806liturgiologists
malacologies1754386_malac_ologi_es
malariologist1693926_malariologist_
martyrologists2062896_martyrologists
meteorologists1754186_meteorologists
metrologists1588836___metrologists
microbiologists22134816microbiologists
mineralogists1652316mi_ne_ralogists
mixologists2145686mi____xologists
museologists1544746_muse__ologists
musicologists1853546_music_ologists
mycologists1947736___myc_ologists
myrmecologist2353316myrmec_ologist_
narratologist1453836_narratologist_
necrologist14410126___necrologist_
nematologists16166606__nematologists
neologists1139776___ne__ologists
neonatologists1584196_neonatologists
neurologists1347646___neurologists
numerologists1664016_nume_rologists
oceanologists1654306__oceanologists
oncologists1448076___onc_ologists
onomatologists1753336_onomatologists
ontologists1248906____ontologists
osteologists1346766_oste__ologists
otologists1149636_____otologists
paleobiologist19156346_paleobiologist_
paleoecologist19114726_paleoecologist_
paleologies1448586_pale__ologi_es
paleontologies17103886_paleontologi_es
paleozoologist2664196_paleozoologist_
palynologist1856306_pal_ynologist_
papyrologists2154086_pa_pyrologists
parasitologists1862806parasitologists
pathologists1848376_pa__thologists
pedologists1548276___pe_dologists
penologists1449596___pe_nologists
petrologists1559146___petrologists
pharmacologists2573646pharmacologists
philologists1876686phil___ologists
phraseologists2053576phrase__ologists
phrenologists1956296_phre_nologists
phycologists2367136__phyc_ologists
piccoloists1752776pi___ccolo_ists
planetologies1653256plane_tologi_es
primatologists19184356_primatologists
proctologist1758966__proctologist_
psephologists2155296__psephologists
psychologists24127476__psychologists
radiologists1497366_ra__diologists
rheologists1547316__rhe__ologists
rheumatologists2162256rheumatologists
sedimentologist1992116sedi_mentologist_
selectionists1556026_select_ionists
selenologist1357006_sele_nologist_
semiologists1548226___semiologists
serologists12410126___se_rologists
sexologists1947256___se_xologists
sinologists1257676si____nologists
sociologists1547946___sociologists
speleologist1555746spele__ologist_
technologists19125706___technologists
teleologist1249386_tele__ologist_
teratologists1496596__teratologists
thanatologist1753616tha_natologist_
toxicologists2353986_toxic_ologists
trichologists1955426__trichologists
victimologists2262256vi_ctimologists
virologists1546636vi____rologists
volcanologists20122766_volcanologists
vulcanologists2092306_vulcanologists
watercolorists19152036_watercolorists

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 Filter178691950240.356501941.0
2DLD Change Limit950241678.05011804.2
3Display Results1671670.1231357.7
 (SQL Overall)1786911678.52920951.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.