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

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
conchologies205456(None) 
conchologist2055812conchologist
conchologists2154562conchologists
oncologies1348652_onc_ologies
anthologies151012013_anthologies
codicologies1853673codicologies
cohomologies2054053cohomologies
conchology2153733concholog__y
coprologies1646943co_prologies
cosmologies1646703co_smologies
iconologies1447093icon__ologies
monologies13312543mon__ologies
morphologies2044523morphologies
oecologies1339463_oec_ologies
ontologies1139883_on_tologies
psychologies23127853psychologies
sociologies1447803so_ciologies
tocologies1349763to_c_ologies
trichologies1845573trichologies
andrologies1346114_andrologies
anemologies1446924_anemologies
angiologies1346134_angiologies
anthologizes253038394_anthologizes
archeologies1845004_archeologies
cardiologies1644964cardiologies
carpologies1646404c_arpologies
cetologies13410854c__etologies
chronologies1846414chronologies
conchies153214854conch____ies
conchoids1766284conch__o_ids
cosmetologies1852924cosmetologies
craniologies1545374craniologies
cryptologies2055424cryptologies
cytologies1639264c__ytologies
dendrologies1553794dendrologies
deontologies1445414deon_tologies
doxologies1946324do__xologies
ecologies12312354__ec_ologies
enologies10312984_en__ologies
ethologies14310544__ethologies
glaciologies1663694glaciologies
graphologies1963734graphologies
gynecologies1953444gynecologies
homologies16311534ho__mologies
horologies14411054ho__rologies
ichnologies1746364__ichnologies
lithologies1546834_lithologies
menologies13310604men__ologies
monologues1346274mon__ologues
mycologies1848864_myc_ologies
mythologies2047844_mythologies
necrologies1447994_necrologies
neologies10411724__n_eologies
neonatologies1453824neonatologies
nephologies1747354_nephologies
nomologies1339474__nomologies
nosologies1148104__nosologies
nostologies1246584no_stologies
oceanologies1554234oceanologies
oenologies1139394_o_enologies
oinologies1148304_o_inologies
oncologic1446494_onc_ologi_c
oncologist13410414_onc_ologist
oncologists1448074_onc_ologists
oologies9312994_o___ologies
ophiologies1746014_ophiologies
ornithologies1752734ornithologies
orologies10311624_o__rologies
osteologies1247054_osteologies
otologies10311404_o__tologies
pathologies1748734_pathologies
penologies13311234pen__ologies
phonologies17410004phon__ologies
phycologies2247784phyc_ologies
poenologies1448324po_enologies
pomologies15310044po__mologies
posologies1349544po__sologies
proctologies1746314proctologies
psephologies2044844psephologies
psychologise23107044psychologise
psychologises24136164psychologises
psychologizes33135314psychologizes
sarcologies1446434sarc_ologies
sinologies1148894sin__ologies
somatologies1546234somatologies
synecologies1844164synecologies
technologies1845974_technologies
tokologies1547144to__kologies
topologies1348974to__pologies
toxicologies2263754toxicologies
venologies1438374ven__ologies
volcanologies1952344volcanologies
zoologies1939014zo___ologies

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.440406115.9
2DLD Change Limit124790936.98317870.5
3Display Results93930.0462021.7
 (SQL Overall)178691937.46923924.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.