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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
ecophysiologies2671301ecophysiologies_
ecophysiology2771624ecophysiolog___y
physiologies2155364___physiologies_
ecclesiologies19141995ec_clesiologies_
epiphytologies2561415epiphy_tologies_
ophiologies1746015__oph__iologies_
physiologist21157325___physiologi_st
cohomologies2054056_co_h_omologies_
coprologies1646946_cop___rologies_
cosmologies1646706_co___smologies_
ecclesiologist1962606ec_clesiologi_st
exobiologies2254406exo___biologies_
geohydrologies2361516geo_hydrologies_
ichthyologies2552296ichthy__ologies_
phycologies2247786___phy_cologies_
physiologic2254716___physiologi__c
physiological2455576___physiological
physiologists22156016___physiologists
phytologies2049046___phy_tologies_
aerobiologies1655057aero___biologies_
amphibologies2352417_amph_ibologies_
apiologies1339067__ap___iologies_
cardiologies1644967_c__ardiologies_
chronologies1846417_c__hronologies_
codicologies1853677_co__dicologies_
conchologies2054567_co__nchologies_
cosmetologies1852927_co_smetologies_
cosmologist1648377_co___smologi_st
craniologies1545377_c__raniologies_
cryobiologies2153617_c_ryobiologies_
cryptologies2055427_c__ryptologies_
cytologies1639267_c___y_tologies_
ecclesiological1992317ec_clesiological
ecclesiologists2062357ec_clesiologists
ecologies12312357ec______ologies_
embryologies2053167e_mbry__ologies_
enzymologies2752957e__nzy_mologies_
epidemiologies2062297e_pidemiologies_
episiotomies1652577e__p_isiotomies_
epizootiologies2771257epizootiologies_
escapologies1753227escap____ologies_
eschatologies1952637e_sch_atologies_
ethnologies1547987e__th__nologies_
ethologies14310547e__th___ologies_
etiologies1139417e_____tiologies_
etymologies17176807e___ty_mologies_
exobiologist2256207exo___biologi_st
geochronologies2261997geochronologies_
geohydrologist2371857geo_hydrologi_st
graphologies1963737graph___ologies_
hagiologies1645347____hagiologies_
histologies1546637____histologies_
hydrologies1948187____hydrologies_
hymnologies2046107____hymnologies_
hypnologies2046087____hypnologies_
ichnologies1746367ic__h__nologies_
ichthyologist2562787ichthy__ologi_st
iconologies1447097ico____nologies_
kinesiologies1851837__kinesiologies_
missiologies1553317___missiologies_
morphologies2044527morph___ologies_
nephologies1747357_neph___ologies_
nephrologies1845077_neph__rologies_
neurophysiology2791627neurophysiolog___y
nosologies1148107_no___s_ologies_
nostologies1246587_no___stologies_
orismologies1553297__o_rismologies_
papyrologies2073607_pap_y_rologies_
pathobiologies2274197_pathobiologies_
phenologies1749357___ph_enologies_
philologies1747207___ph_ilologies_
phlebologies2054657___phlebologies_
phonologies17410007___ph_onologies_
photobiologies2265157pho_tobiologies_
phraseologies1953277___phraseologies_
phrenologies1846317___phrenologies_
phycologist2259187___phy_cologi_st
physiognomies2461477___physiognomies_
physiology2254447___physiolog___y
posologies1349547___p_os_ologies_
psephologies2044847pseph___ologies_
psychobiologies2873727psychobiologies_
psychologies23127857___psychologies_
pyrologies16310017___p_y_rologies_
semasiologies1652997__semasiologies_
sociobiologies19103347_sociobiologies_
sociologies1447807_so___ciologies_
soteriologies1453877_so_teriologies_
technologies1845977tec__h__nologies_
topologies1348977_top____ologies_
tropologies1447737trop____ologies_

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 Limit95024919.26310258.4
3Display Results91910.0631444.4
 (SQL Overall)178691919.68618448.4
 
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.