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

93 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
geomorphologies2471311geomorphologies_
geomorphologist2471532geomorphologi_st
geomorphology2571664geomorpholog___y
morphologies2044524___morphologies_
geochronologies2261995geochronologies_
morphologist2055505___morphologi_st
demonologies1645506de_mo__nologies_
embryologies2053166_e_mbr_yologies_
gemmologies1745246ge_m___mologies_
gemologies1449006ge_m____ologies_
geochronologist2272306geochronologi_st
geohydrologies2361516geo_hydrologies_
gerontologies1584436ge_ro_ntologies_
graphologies1963736g___raphologies_
helminthologies2471266helminthologies_
meteorologies1653586meteor__ologies_
morphologic2153756___morphologi__c
morphological2353966___morphological
morphologists2154266___morphologists
neoorthodoxies257736neo_orthodoxies_
nephologies1747356ne____phologies_
aerobiologies1655057ae_ro_biologies_
aerologies11312027ae___r__ologies_
anthropologies20113987anthrop_ologies_
carpologies1646407___carp_ologies_
cohomologies2054057_coho__mologies_
conchologies2054567___conchologies_
coprologies1646947___co_prologies_
demonologist1657057de_mo__nologi_st
demythologizes33112627de_m_ythologizes_
dendrologies1553797de_ndr__ologies_
deontologies1445417de__o_ntologies_
dermatologies1755257derm__atologies_
embryologist2053877_e_mbr_yologi_st
endocrinologies1971187_endocrinologies_
entomologies1575327_ento__mologies_
escapologies1753227_e_scap_ologies_
ethologies14310547_e____thologies_
exobiologies2254407_e_xo_biologies_
garbologies1544887g___ar_bologies_
gemmologist1746547ge_m___mologi_st
gemologist141010287ge_m____ologi_st
geochronologic2371687geochronologi__c
geohydrologist2371857geo_hydrologi_st
geologies11410647ge______ologies_
geomorphic2055637geomorph____i__c
geophagies1754157ge__o_ph__agies_
gerontologist1555987ge_ro_ntologi_st
graphologist19114867g___raphologi_st
hematologies1847567he_m__atologies_
herbologies1746567he___r_bologies_
herpetologies1953467he___rpetologies_
homologies16311527_hom____ologies_
homophonies2156517_homo_ph__onies_
homophylies2455157_homo_phyl__ies_
horologies14411057___hor__ologies_
mesomorphies2153907mesomorph____ies_
meteorologist1654877meteor__ologi_st
methodologies2053487metho__dologies_
metrologies1449587me__tr__ologies_
monologies13312547___mo__nologies_
morphology2144217___morpholog___y
mythologies2047847___m_ythologies_
necrologies1447987ne__cr__ologies_
nematologies1546697ne_m__atologies_
neonatologies1453827ne__onatologies_
nephrologies1845077ne____phrologies_
neurobiologies1763917neuro_biologies_
neurologies1248237ne__ur__ologies_
nomologies1339477_nom____ologies_
numerologies1563427_numer__ologies_
omophagies1853987__omo_ph__agies_
onomatologies1653387__onomatologies_
ophiologies1746017____o_phiologies_
ornithologies1752737__ornithologies_
orologies10311627____or__ologies_
petrologies1449897pe__tr__ologies_
photobiologies2265157photo_biologies_
photogeologies2163897photo_geologies_
pomologies15310047_pom____ologies_
protozoologies2663167proto_zoologies_
psephologies2044847___psephologies_
remythologizes3282507re_m_ythologizes_
semasiologies1652997se_m_asiologies_
semeiologies1545307se_m__eiologies_
semiologies1448807se_m___iologies_
serologies11311337se___r__ologies_
somatologies1546237_som__atologies_
soteriologies1453877_soter_iologies_
teratologies1346877te___ratologies_
terminologies1653447term__inologies_
topologies1348977___to_p_ologies_
tropologies1447737__tro_p_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 Limit95024938.86010725.1
3Display Results93930.0801162.5
 (SQL Overall)178691939.30019214.1
 
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.