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

113 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
phenomenologist238268(None) 
phenomenologies2361992phenomenologies
phenomenalist2064053phenomenal__ist
phenomenology2462423phenomenolog__y
phenomenalism2263454phenomenal__ism
phenomenalists2162864phenomenal__ists
phonologist17411564ph__o__nologist
photogeologist21134674photoge_ologist
phrenologist1857914ph___renologist
roentgenologist1771514roentgenologist
chronologist1857625ch_ro__nologist
demonologist1657055_de__monologist
entomologist1556975__entom__ologist
hematologist18219205_he__matologist
herpetologist1984795_he_rpetologist
numerologist1574915___numerologist
onomatologist1654405__onomatologist
paleoecologist19114725paleo_ecologist
penologist13412845p_____enologist
pharmacologist2464175ph_armacologist
phenomenalisms2362945phenomenal__isms
phenomenalistic2481425phenomenal__istic
phenomenons1853235phenomen__o_ns_
phonologists1848775ph__o__nologists
photobiologist2266225photo_biologist
photogeologists22173645photoge_ologists
phraseologist1954195ph_rase_ologist
phrenologists1956295ph___renologists
planetologist1664505plan__etologist
pomologist15412045p___om__ologist
rheumatologist2062855rhe_umatologist
sedimentologist1992115_sedimentologist
selenologist1357005_se__lenologist
angelologist1454166__an_gelologist
chronobiologist2392796chronobiologist
chronologists1966116ch_ro__nologists
cosmetologist1853976__cosmetologist
criminologist1863646__criminologist
demonologists1755566_de__monologists
dendrologist1555096_den__drologist
deontologist1457416_de_o_ntologist
dermatologist1786466_de_rmatologist
endocrinologist1971376__endocrinologist
enologist10314126______enologist
entomologists1655666__entom__ologists
enzymologist2753836__en_zymologist
ethnologist1549266__e__thnologist
etymologist17158026__etym__ologist
exobiologist2256206__exo_biologist
gemmologist1746546_ge__m_mologist
gemologist141010286_ge__m__ologist
genealogist1354146_gen__e_alogist
gerontologist1555986_gero_ntologist
gynecologist1954576_gyn__ecologist
hematologists19217056_he__matologists
herpetologists2083636_he_rpetologists
horologist14412366_h__o__rologist
immunologist17135326___immunologist
kremlinologist21141776kre_mlinologist
lichenologist1973916__lichenologist
limnologist1446686___lim_nologist
monologist13413616_____monologist
myrmecologist2353316__myrmecologist
nematologist15208476___nematologist
neologist10712816___n__e_ologist
neonatologist14135356_ne_onatologist
nonbiologist1555916___nonbiologist
numerologists1664016___numerologists
oceanologist1555686oce___anologist
onomatologists1753336__onomatologists
paleobiologist19156346paleo_biologist
paleoecologists20124176paleo_ecologists
paleontologist1765146paleo_ntologist
paleozoologist2664196paleo_zoologist
palynologist1856306p___alynologist
pedologist14410866p_____edologist
penologists1449596p_____enologists
petrologist14711886p_e___trologist
pharmacologists2573646ph_armacologists
phenologies1749356ph____enologies
phenomenal1754266phenomenal_____
phenomenally2262796phenomenal___ly
phenomenas1754636phenomen____as_
phenomenon1753296phenomen__o___n
philologist1768436ph____ilologist
phonologic1857946ph__o__nologi_c
phonologies17410006ph__o__nologies
photobiologists2365176photo_biologists
photogeologic2263736photoge_ologi_c
photogeologies2163896photoge_ologies
phraseologists2053576ph_rase_ologists
phrenologies1846316ph___renologies
phycologist2259186ph____ycologist
physiologist21157326ph___ysiologist
planetologists1763626plan__etologists
poenologies1448326p___o_enologies
pomologists1648986p___om__ologists
primatologist18175316p__rimatologist
proctologist1758966p__ro_ctologist
protozoologist2663886proto_zoologist
psephologist2056606pse___phologist
pteridologist17144606pte__ridologist
rheologist1449536rh____e_ologist
rheumatologists2162256rhe_umatologists
roentgenologic1871216roentgenologi_c
roentgenologies17151376roentgenologies
seismologist15125276_seism__ologist
selenologists1455336_se__lenologists
semiologist14410716_se__m_iologist
speleologist1555746spe__le_ologist
technologist18137406_te__chnologist
teleologist1249386_te__le_ologist
thanatologist1753616than__atologist

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.343520965.0
2DLD Change Limit950241136.92313725.8
3Display Results1131130.0761486.8
 (SQL Overall)1786911137.34224338.2
 
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.