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

73 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
terminology175320(None) 
criminology1952423criminology
demonology1744383de_monology
dermatology1853923dermatology
kremlinology2271163kremlinology
pteridology1852593pter_idology
rhinology1645083__rhinology
semiology1546893se_mi_ology
technology1944913te_chnology
teratology1445293ter_atology
terminally1567023terminal_ly
terminologies1653443terminologies
tribology1545123t_r_ibology
aerobiology1753954aerobiology
aerology1238744aer___ology
aetiology1346424ae_ti_ology
cardiology1744394cardi_ology
chronology1945544chr_onology
craniology1644214_craniology
enology11239814_e___nology
ethnology1645694_e_thnology
etiology1236444_e_ti_ology
etymology1844754etym__ology
gemmology1843954ge_m_mology
gemology1546164ge_m__ology
germinally1655254germinal_ly
gerontology1653364gerontology
helminthology2561204helminthology
hematology1995774he_matology
herbology1845424her__bology
herpetology2053064herpetology
hymnology21104714_hym_nology
immunology1853404_immunology
iridology1443804_ir_idology
lexicology2353164le_xicology
limnology1544434_lim_nology
menology14218484___menology
misology1447134___misology
mixology2144834___mixology
monology142310114___monology
myrmecology2462094myrmecology
nematology16125204ne_matology
oenology12227824oe___nology
oinology12196704___oinology
organology1553454_organology
penology14238484pe___nology
phrenology1944894phr_enology
selenology1444224se_lenology
semeiology1644114se_meiology
semicolony1753134se_micolony
serology1238144ser___ology
sinology12247184___sinology
soteriology1553274soter_i_ology
stereology1444784ster__eology
teemingly1545074teemingl__y
teleology1345734te__leology
terminably1755554termin_ably
terminal1039734terminal___
terminals1147454terminal__s
terminator1246634terminato_r
terminators1346034terminators
terming104016004termin___g_
terminological1953644terminological
terpinol1044074terpinol___
terpinols1143734terpinol__s
terricolous1352414terricolous
toxicology2353524t_oxicology
trichology1944844t_richology
trilogy1136014t_r_i__logy
tropology1546424t_r_opology
uranology1344894_ur_anology
urbanology1652514_urbanology
venology15226634ve___nology

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 Filter1786911488190.406440125.6
2DLD Change Limit148819739.42015798.2
3Display Results73730.0332212.1
 (SQL Overall)178691739.85918124.7
 
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.