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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

192 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
herpetologies195346(None) 
herpetologist1984792herpetologist
herpetologists2083632herpetologists
dermatologies1755253dermatologies
gerontologies1584433gerontologies
hematologies1847563he_matologies
herbologies1746563her__bologies
herpetological2253323herpetological
herpetology2053063herpetolog__y
teratologies1346873ter_atologies
aerobiologies1655054aerobiologies
aerologies11312024aer___ologies
areologies1139824_ar_e_ologies
carpologies1646404carp__ologies
cetologies13410854___cetologies
cosmetologies1852924cosmetologies
cryptologies2055424_cryptologies
deontologies1445414de_ontologies
fetologies1439184___fetologies
haplologies1744764h_ap_lologies
hierologies1547064h__ierologies
histologies1546634h__istologies
horologies14411054hor___ologies
hypnologies2046084h_yp_nologies
morphologies2044524morp_hologies
myrmecologies2352434myrmecologies
narratologies1452754narratologies
nematologies1546694ne_matologies
neonatologies1453824neonatologies
nephologies1747354ne_p_hologies
nephrologies1845074ne_phrologies
pedologies1439344___pedologies
penologies13311234___penologies
petrologies1449894___petrologies
phrenologies1846314phr_enologies
planetologies1653254planetologies
proctologies1746314_proctologies
reflexologies2451814reflexologies
rheologies1488434__rhe_ologies
rheumatologies2062474rheumatologies
selenologies1345284se_lenologies
semeiologies1545304se_meiologies
serologies11311334ser___ologies
stereologies1345914ster_e_ologies
teleologies1247514te_le_ologies
terminologies1653444terminologies
aetiologies1248985ae__tiologies
agrologies1237695agr___ologies
anemologies1446925__anemologies
angelologies1453015_angelologies
apiologies1339065__ap_iologies
apologies12311195__ap__ologies
archeologies1845005_archeologies
autecologies1554575_autecologies
balneologies1553315balne_ologies
bryologies1646045_br__yologies
campanologies2052465campanologies
cardiologies1644965car_diologies
chronologies1846415chr_onologies
climatologies1852805climatologies
coprologies1646945_cop_rologies
craniologies1545375_craniologies
cytologies1639265___cytologies
demonologies1645505de_monologies
dendrologies1553795de_ndrologies
dermatologic1854505dermatologi_c
dermatologist1786465dermatologist
dermatologists18134925dermatologists
dialectologies1892085dialectologies
ecologies12312355____ecologies
electrologies1656255_electrologies
embryologies2053165_embryologies
enologies10312985____enologies
entomologies1575325_entomologies
enzymologies2752955_enzymologies
epiphytologies2561415epiphytologies
escapologies1753225_escapologies
eschatologies1952635eschatologies
ethnologies1547985_e_thnologies
ethologies14310545_e__thologies
etiologies1139415_e__tiologies
etymologies17176805_e_tymologies
exobiologies2254405_exobiologies
feretories1348605fer_et__ories
garbologies1544885gar__bologies
gemmologies1745245ge__mmologies
gemologies1449005___gemologies
genealogies1353575ge_ne_alogies
geologies11410645___ge_ologies
gerontologic1653765gerontologi_c
gerontologist1555985gerontologist
gerontologists1654855gerontologists
graphologies1963735_graphologies
gynaecologies2052165gynaecologies
gynecologies1953445_gynecologies
hagiologies1645345h__agiologies
helminthologies2471265helminthologies
hematologic1956365he_matologi_c
hematologist18219205he_matologist
hematologists19217055he_matologists
heretofore1692385her_etofo_re_
herstories1348605her_st__ories
heterodoxies2353835he_terodoxies
heterogonies16104815he_terogonies
heterologous1653535he_terologous
heteronomies1755385he_teronomies
homologies16311525h___omologies
horologes1348315hor___olog_es
hydrobiologies2473805hydrobiologies
hydrologies1948185h__ydrologies
hymnologies2046105h__ymnologies
ideologies1237335__ide_ologies
iridologies1344585_ir_idologies
karyologies1944445kar__yologies
laryngologies18122145laryngologies
lexicologies2253635le_xicologies
lichenologies1952915lichenologies
martyrologies1952335martyrologies
menologies13310605___menologies
meteorologies1653585meteorologies
methodologies2053485methodologies
metrologies1449585me__trologies
museologies1444545_muse_ologies
necrologies1447985ne__crologies
neologies10411715___ne_ologies
neurobiologies1763915neurobiologies
neurologies1248235ne__urologies
nostologies1246585__nostologies
numerologies1563425_numerologies
oecologies1339465___oecologies
oenologies1139395___oenologies
onomatologies1653385onomatologies
ontologies1139885___ontologies
ophiologies1746015__ophiologies
organologies1454085_organologies
orismologies1553295_orismologies
ornithologies1752735_ornithologies
orologies10311625_or___ologies
osteologies1247055_oste_ologies
otologies10311405____otologies
paleologies1448585_pale_ologies
papyrologies2073605_papyrologies
parasitologies1782365parasitologies
pathologies1748735___pathologies
perpetuities1653475perpet_uities
petalodies1344845___petalodies
pharmacologies2463275pharmacologies
phenologies1749355__phenologies
phenomenologies2361995phenomenologies
phlebologies2054655_phlebologies
phraseologies1953275phraseologies
phytologies2049045__phytologies
pneumatologies1962815pneumatologies
poenologies1448325__poenologies
pomologies15310045___pomologies
posologies1349545___posologies
praxeologies2293825_praxeologies
primatologies1863875primatologies
psephologies2044845psep_hologies
pteridologies1762935pter_idologies
pyrologies16310015___pyrologies
radiologies1347805__radiologies
rhinologies1546505__rhinologies
sarcologies1446435sar__cologies
scatologies1446865__scatologies
sedimentologies1961555sedimentologies
seismologies1543905se_ismologies
semasiologies1652995semasiologies
semiologies1448805se__miologies
sexologies1837715___sexologies
sitologies1148705___sitologies
somatologies1546235_somatologies
speleologies1553885__speleologies
synecologies1844165_synecologies
tautologies1245915__tautologies
technologies1845975te_chnologies
teratologic1455655ter_atologi_c
teratologist13108575ter_atologist
teratologists1496595ter_atologists
thanatologies1752835thanatologies
theologies141010105__the_ologies
topologies1348975_top__ologies
tribologies1446125_tr_ibologies
trichologies1845575_trichologies
tropologies1447735_tr_opologies
typologies1647645_typ__ologies
uranologies1246135_ur_anologies
urbanologies1552965_urbanologies
urologies1039535_ur___ologies
venologies1438375___venologies
vexillologies2451465vexillologies
virologies1447215vir___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 Filter1786911247900.403443402.0
2DLD Change Limit1247901929.28313442.9
3Display Results1921920.1261523.8
 (SQL Overall)1786911929.81218211.5
 
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.