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

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

65 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
hierologies154706(None) 
aerologies11312022_aerologies
herbologies1746562h_erbologies
histologies1546632histologies
horologies14411052h_orologies
hydrologies1948182hydrologies
serologies11311332_serologies
virologies1447212vi_rologies
acarologies1446063acarologies
agrologies1237693_agrologies
andrologies1346113andrologies
anemologies1446923anemologies
areologies1139823are_ologies
astrologies1247923astrologies
biologies12311183bi__ologies
cetologies13410853_cetologies
coprologies1646943coprologies
ecologies12312353__ecologies
enologies10312983__enologies
fetologies1439183_fetologies
gemologies1449003_gemologies
geologies11410643_ge_ologies
hagiologies1645343hagiologies
haplologies1744763haplologies
hierology1655543hierolog__y
hierurgies1451543hier_urgies
homologies16311523h_omologies
horologes1348313h_orolog_es
hymnologies2046103hymnologies
hypnologies2046083hypnologies
ideologies1237333_ideologies
limnologies1445533limnologies
lithologies1546833lithologies
menologies13310603_menologies
metrologies1449583metrologies
mineralogies15102983mineralogies
misologies13139063mi_sologies
mixologies20136583mi_xologies
necrologies1447983necrologies
neologies10411713_ne_ologies
neurologies1248233neurologies
numerologies1563423numerologies
oecologies1339463_oecologies
oenologies1139393_oenologies
oinologies1148303oi_nologies
orologies10311623__orologies
pedologies1439343_pedologies
penologies13311233_penologies
petrologies1449893petrologies
phenologies1749353phenologies
philologies1747203phi_lologies
phlebologies2054653phlebologies
phrenologies1846313phrenologies
pierogies1245873pier__ogies
poenologies1448323poenologies
pyrologies16310013_pyrologies
rheologies1488433rhe_ologies
rhinologies1546503rhi_nologies
sexologies1837713_sexologies
sinologies1148893si_nologies
sitologies1148703si_tologies
stereologies1345913stereologies
theologies141010103the_ologies
urologies1039533__urologies
venologies1438373_venologies

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 Filter1786911216330.393454684.5
2DLD Change Limit121633658.59314154.9
3Display Results65650.0302166.7
 (SQL Overall)178691659.01619819.3
 
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.