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

138 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
phenomenologies236199(None) 
phenomenologist2382682phenomenologist
phenomenology2462413phenomenolog__y
phenologies1749314ph____enologies
phonologies1749974ph__o__nologies
photogeologies2163844photoge_ologies
phrenologies1846304ph___renologies
poenologies1448314p___o_enologies
roentgenologies17151374roentgenologies
chronologies1846405ch_ro__nologies
demonologies1645505_de__monologies
entomologies1575325__entom__ologies
hematologies1847545_he__matologies
herpetologies1953455_he_rpetologies
homologies16311515_h__om__ologies
hymnologies2046105_h__ym_nologies
menologies13310595_____menologies
nomologies1339475___nom__ologies
numerologies1563425___numerologies
oenologies1139395____o_enologies
onomatologies1653385__onomatologies
paleoecologies1963555paleo_ecologies
penologies13311225p_____enologies
pharmacologies2463275ph_armacologies
phenomenalism2263445phenomenal__ism
phenomenalisms2362935phenomenal_isms
phenomenalist2064055phenomenal__ist
phenomenalists2162865phenomenal_ists
phenomenons1853235phenomen__o__ns
phlebologies2054655ph___lebologies
photobiologies2265105photo_biologies
phraseologies1953275ph_rase_ologies
planetologies1653255plan__etologies
pneumatologies1962815pne_umatologies
pomologies15310035p___om__ologies
rheumatologies2062475rhe_umatologies
sedimentologies1961555_sedimentologies
selenologies1345285_se__lenologies
semeiologies1545305_se__meiologies
terminologies1653445_te_rminologies
aerobiologies1655056_aero_biologies
anemologies1446926__an__emologies
angelologies1453016__an_gelologies
balneologies1553316baln__e_ologies
chronobiologies2362096chronobiologies
cohomologies2054056_cohom__ologies
cosmetologies1852926__cosmetologies
criminologies1852956__criminologies
dendrologies1553796_den__drologies
deontologies1445416_de_o_ntologies
dermatologies1755256_de_rmatologies
endocrinologies1971186__endocrinologies
enologies10312976______enologies
enzymologies2752956__en_zymologies
ethnologies1547966__e__thnologies
etymologies17176786__etym__ologies
exobiologies2254406__exo_biologies
gemmologies1745246_ge__m_mologies
gemologies1449006_ge__m__ologies
genealogies1353556_gen__e_alogies
gerontologies1584436_gero_ntologies
gynaecologies2052166_gyn_aecologies
gynecologies1953446_gyn__ecologies
helminthologies2471266_he_lminthologies
herbologies1746556_he___rbologies
hierologies1547066_h___ierologies
homologizes2646146_h__om__ologizes
homologues1645486_h__om__ologues
horologies14411056_h__o__rologies
hypnologies2046086_h___ypnologies
iconologies1447086__ico__nologies
immunologies1774306___immunologies
kremlinologies2161496kre_mlinologies
lichenologies1952896__lichenologies
limnologies1445536___lim_nologies
monologies13312536_____monologies
myrmecologies2352436__myrmecologies
nematologies1546686___nematologies
neologies10411716___n__e_ologies
neonatologies1453826_ne_onatologies
nosologies1148106___no__sologies
nostologies1246586___no_stologies
oceanologies1554226oce___anologies
oecologies1339466____o_ecologies
oinologies1148306____o_inologies
paleobiologies1954896paleo_biologies
paleologies1448576p___ale_ologies
paleontologies17103886paleo_ntologies
paleozoologies2663186paleo_zoologies
palynologies1844876p___alynologies
pathobiologies2274186patho_biologies
pedologies1439346p_____edologies
petrologies1449876p_e___trologies
phenetoles1544156phen__etol___es
phenocopies2055836ph____enocopies
phenomenal1754266phenomenal_____
phenomenalistic2481426phenomenalistic
phenomenally2262796phenomenal___ly
phenomenas1754626phenomen_____as
phenomenon1753296phenomen__o___n
philologies1747196ph____ilologies
phonologic1857926ph__o__nologi_c
phonologist17411556ph__o__nologist
phonologists1848776ph__o__nologists
photogeologic2263686photoge_ologi_c
photogeologist21134626photoge_ologist
photogeologists22173596photoge_ologists
phrenologist1857916ph___renologist
phrenologists1956296ph___renologists
phycologies2247776ph____ycologies
physiologies2155366ph___ysiologies
phytologies2049036ph____ytologies
posologies1349546p___o__sologies
praxeologies2293826p__raxe_ologies
pregnenolones166786pre_gnenolo_nes
primatologies1863876p__rimatologies
proctologies1746316p__ro_ctologies
protozoologies2663146proto_zoologies
psephologies2044846pse___phologies
pteridologies1762926pte__ridologies
radioecologies1882706radio_ecologies
reflexologies2451816_re_flexologies
rheologies1488436rh____e_ologies
rhinologies1546486rh____inologies
roentgenologic1871216roentgenologi_c
roentgenologist1771516roentgenologist
seismologies1543906_seism__ologies
semiologies1448806_se__m_iologies
somatologies1546226___somatologies
speleologies1553886spe__le_ologies
splenomegalies197786splenomegal__ies
stereologies1345906ste__re_ologies
synecologies1844166_syn__ecologies
technologies1845956_te__chnologies
teleologies1247506_te__le_ologies
thanatologies1752826than__atologies
theologies141010096th____e_ologies
venologies1438376_____venologies

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.1261418182.5
2DLD Change Limit950241388.21611565.7
3Display Results1381380.0961437.5
 (SQL Overall)1786911388.43821176.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.