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

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

90 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
speleologies155388(None) 
paleologies1448582_paleologies
selenologies1345282s_elenologies
speleologist1555742speleologist
speleologists1654322speleologists
stereologies1345912stereologies
teleologies1247512_teleologies
pedologies1439343_pe_dologies
penologies13311233_pe_nologies
petrologies1449893_petrologies
phlebologies2054653_phlebologies
psephologies2044843psephologies
semeiologies1545303s_emeiologies
semiologies1448803s_emiologies
serologies11311333s_e_rologies
sexologies1837713s_e_xologies
speleological1853913speleological
speleology1653013speleolog__y
aerologies11312024_ae_rologies
aetiologies1248984_aetiologies
algologies1246794__algologies
anemologies1446924ane_mologies
angelologies1453014angel_ologies
apiologies1339064ap__iologies
apologies12311194ap___ologies
archeologies1845004archeologies
areologies1139824__areologies
balneologies1553314balneologies
bibliologies1753374bibliologies
cetologies13410854_ce_tologies
ecologies12312354__e_cologies
enologies10312984__e_nologies
ethologies14310544__ethologies
etiologies1139414__etiologies
fetologies1439184_fe_tologies
gemmologies1745244_gemmologies
gemologies1449004_ge_mologies
genealogies1353574_genealogies
geologies11410644___geologies
haplologies1744764hapl_ologies
herbologies1746564_herbologies
hierologies1547064hie_rologies
ideologies1237334__ideologies
menologies13310604_me_nologies
metrologies1449584_metrologies
museologies1444544_museologies
necrologies1447984_necrologies
neologies10411714___neologies
nephologies1747354_nephologies
nephrologies1845074nephrologies
neurologies1248234_neurologies
oceanologies1554234oceanologies
oecologies1339464_oe_cologies
oenologies1139394_oe_nologies
ophiologies1746014op_hiologies
osteologies1247054_osteologies
palynologies1844874_palynologies
pathologies1748734_pathologies
phenologies1749354_phenologies
philologies1747204_philologies
phonologies17410004_phonologies
phrenologies1846314_phrenologies
phycologies2247784_phycologies
phytologies2049044_phytologies
poenologies1448324_poenologies
pomologies15310044_p_omologies
posologies1349544_p_osologies
praxeologies2293824praxeologies
psychologies23127854psychologies
pyrologies16310014_p_yrologies
reflexologies2451814reflexologies
rheologies1488434__rheologies
sarcologies1446434s_arcologies
scatologies1446864s_catologies
seismologies1543904seismologies
selenologist1357004s_elenologist
selenologists1455334s_elenologists
sinologies1148894s__inologies
sitologies1148704s__itologies
sociologies1447804s_ociologies
somatologies1546234somatologies
soteriologies1453874soteriologies
symbologies1945174s_ymbologies
synecologies1844164synecologies
teleologic1375374_teleologi_c
teleologist1249384_teleologist
teleologists1347224_teleologists
teleonomies1354684_teleonomies
theologies141010104__theologies
venologies1438374_ve_nologies

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 Filter1786911247900.373479064.3
2DLD Change Limit124790907.20617317.5
3Display Results90900.0601500.0
 (SQL Overall)178691907.63923391.9
 
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.