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 “phenomenologista” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

(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
phenomenologist2382681phenomenologist_
phenomenologies2361993phenomenologi_es
phenomenalist2064054phenomenal__ist_
phenomenalists2162864phenomenal__ists
phenomenology2462424phenomenolog___y
phenomenalism2263455phenomenal__is_m
phenomenalisms2362945phenomenal__isms
phenomenalistic2481425phenomenal__istic
phonologist17411565ph__o__nologist_
phonologists1848775ph__o__nologists
photogeologist21134675photoge_ologist_
photogeologists22173645photoge_ologists
phrenologist1857915ph___renologist_
phrenologists1956295ph___renologists
roentgenologist1771515roentgenologist_
chronologist1857626ch_ro__nologist_
chronologists1966116ch_ro__nologists
demonologist1657056_de__monologist_
demonologists1755566_de__monologists
entomologist1556976__entom__ologist_
entomologists1655666__entom__ologists
hematologist18219206_he__matologist_
hematologists19217056_he__matologists
herpetologist1984796_he_rpetologist_
herpetologists2083636_he_rpetologists
numerologist1574916___numerologist_
numerologists1664016___numerologists
onomatologist1654406__onomatologist_
onomatologists1753336__onomatologists
paleoecologist19114726paleo_ecologist_
paleoecologists20124176paleo_ecologists
penologist13412846p_____enologist_
penologists1449596p_____enologists
pharmacologist2464176ph_armacologist_
pharmacologists2573646ph_armacologists
phenomenons1853236phenomen__o_ns__
photobiologist2266226photo_biologist_
photobiologists2365176photo_biologists
phraseologist1954196ph_rase_ologist_
phraseologists2053576ph_rase_ologists
planetologist1664506plan__etologist_
planetologists1763626plan__etologists
pomologist15412046p___om__ologist_
pomologists1648986p___om__ologists
rheumatologist2062856rhe_umatologist_
rheumatologists2162256rhe_umatologists
sedimentologist1992116_sedimentologist_
selenologist1357006_se__lenologist_
selenologists1455336_se__lenologists
angelologist1454167__an_gelologist_
angelologists1553377__an_gelologists
chronobiologist2392797chronobiologist_
cosmetologist1853977__cosmetologist_
cosmetologists1953147__cosmetologists
criminologist1863647__criminologist_
criminologists1952977__criminologists
dendrologist1555097_den__drologist_
dendrologists1654087_den__drologists
deontologist1457417_de_o_ntologist_
deontologists1555927_de_o_ntologists
dermatologist1786467_de_rmatologist_
dermatologists18134927_de_rmatologists
endocrinologist1971377__endocrinologist_
enologist10314127______enologist_
enologists11310627______enologists
enzymologist2753837__en_zymologist_
enzymologists2873117__en_zymologists
ethnologist1549267__e__thnologist_
ethnologists1647047__e__thnologists
etymologist17158027__etym__ologist_
etymologists18156497__etym__ologists
exobiologist2256207__exo_biologist_
exobiologists2355327__exo_biologists
gemmologist1746547_ge__m_mologist_
gemmologists1845237_ge__m_mologists
gemologist141010287_ge__m__ologist_
gemologists1577887_ge__m__ologists
genealogist1354147_gen__e_alogist_
genealogists1452787_gen__e_alogists
gerontologist1555987_gero_ntologist_
gerontologists1654857_gero_ntologists
gynecologist1954577_gyn__ecologist_
gynecologists2053697_gyn__ecologists
horologist14412367_h__o__rologist_
horologists1548967_h__o__rologists
immunologist17135327___immunologist_
immunologists18124497___immunologists
kremlinologist21141777kre_mlinologist_
kremlinologists22141397kre_mlinologists
lichenologist1973917__lichenologist_
lichenologists2063037__lichenologists
limnologist1446687___lim_nologist_
limnologists1545327___lim_nologists
monologist13413617_____monologist_
monologists14410077_____monologists
myrmecologist2353317__myrmecologist_
myrmecologists2452787__myrmecologists
nematologist15208477___nematologist_
nematologists16166607___nematologists
neologist10712817___n__e_ologist_
neologists1139777___n__e_ologists
neonatologist14135357_ne_onatologist_
neonatologists1584197_ne_onatologists
nonbiologist1555917___nonbiologist_
nonbiologists1664727___nonbiologists
oceanologist1555687oce___anologist_
oceanologists1654307oce___anologists
paleobiologist19156347paleo_biologist_
paleobiologists20115737paleo_biologists
paleontologist1765147paleo_ntologist_
paleontologists1884527paleo_ntologists
paleozoologist2664197paleo_zoologist_
paleozoologists2763857paleo_zoologists
palynologist1856307p___alynologist_
palynologists1954997p___alynologists
pedologist14410867p_____edologist_
pedologists1548277p_____edologists
petrologist14711887p_e___trologist_
petrologists1559147p_e___trologists
phenological2068057ph____enological
phenologies1749357ph____enologi_es
phenomena1645217phenomen_______a
phenomenal1754267phenomenal______
phenomenally2262797phenomenal____ly
phenomenas1754637phenomen____as__
phenomenon1753297phenomen__o____n
philologist1768437ph____ilologist_
philologists1876687ph____ilologists
phonologic1857947ph__o__nologi__c
phonological2058377ph__o__nological
phonologies17410007ph__o__nologi_es
photogeologic2263737photoge_ologi__c
photogeological2463107photoge_ological
photogeologies2163897photoge_ologi_es
phrenological2156337ph___renological
phrenologies1846317ph___renologi_es
phycologist2259187ph____ycologist_
phycologists2367137ph____ycologists
physiologist21157327ph___ysiologist_
physiologists22156017ph___ysiologists
poenologies1448327p___o_enologi_es
primatologist18175317p__rimatologist_
primatologists19184357p__rimatologists
proctologist1758967p__ro_ctologist_
proctologists1856817p__ro_ctologists
protozoologist2663887proto_zoologist_
protozoologists2763037proto_zoologists
psephologist2056607pse___phologist_
psephologists2155297pse___phologists
pteridologist17144607pte__ridologist_
pteridologists18133727pte__ridologists
rheologist1449537rh____e_ologist_
rheologists1547317rh____e_ologists
roentgenologic1871217roentgenologi__c
roentgenologies17151377roentgenologi_es
seismologist15125277_seism__ologist_
seismologists16124197_seism__ologists
semiologist14410717_se__m_iologist_
semiologists1548227_se__m_iologists
speleologist1555747spe__le_ologist_
speleologists1654327spe__le_ologists
technologist18137407_te__chnologist_
technologists19125707_te__chnologists
teleologist1249387_te__le_ologist_
teleologists1347227_te__le_ologists
thanatologist1753617than__atologist_
thanatologists1852867than__atologists

Search took 10 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 Limit950241678.98310578.2
3Display Results1671670.1261325.4
 (SQL Overall)1786911679.46918871.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.