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

82 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
dendrologists165408(None) 
dendrologist1555091dendrologist_
dendrologies1553792dendrologi_es
demonologists1755563demonologists
dendrologic1652663dendrologi__c
dendrological1853833dendrological
deontologists1555923deontologists
enologists11310623_en__ologists
hydrologists2046093_hydrologists
metrologists1588833me_trologists
necrologists1547873ne_crologists
nephrologists1954983nephrologists
neurologists1347643ne_urologists
pedologists1548273pe_d_ologists
penologists1449593pen__ologists
petrologists1559143pe_trologists
serologists12410123se__rologists
andrologies1346114_andrologi_es
anthologists1648034_anthologists
audiologists1445614_audiologists
cardiologists1765144cardiologists
cetologists1449164ce__tologists
conchologists2154564conchologists
demonologist1657054demonologist_
dendrology1653114dendrolog___y
deontologist1457414deontologist_
dermatologists18134924dermatologists
ecologists13310924_e__cologists
electrologists1765644electrologists
embryologists2153124_embryologists
enologist10314124_en__ologist_
entomologists1655664_entomologists
enzymologists2873114_enzymologists
ethnologists1647044_ethnologists
ethologists1549024_e_thologists
etymologists18156494_etymologists
fetologists1547994fe__tologists
futurologists1773074futurologists
gemmologists1845234ge_mmologists
gemologists1577884ge__mologists
genealogists1452784gen_ealogists
geohydrologists2461524geohydrologists
geologists1279164ge___ologists
gynecologists2053694gynecologists
hematologists19217054hematologists
horologists1548964__horologists
hydrologist1948334_hydrologist_
ideologists1346654__ideologists
iridologists1444684irid_ologists
lexicologists2374154lexicologists
meteorologists1754184meteorologists
metrologist14511224me_trologist_
mineralogists1652314mineralogists
monologists14410074mon__ologists
necrologist14410124ne_crologist_
nematologists16166604nematologists
neologists1139774__n_eologists
neonatologists1584194neonatologists
nephrologist1856304nephrologist_
neurologist1249984ne_urologist_
nonbiologists1664724nonbiologists
numerologists1664014numerologists
oncologists1448074_on_cologists
ontologists1248904_on_tologists
orologists1149824___orologists
papyrologists2154084papyrologists
pedologist14410864pe_d_ologist_
penologist13412844pen__ologist_
petrologist14711884pe_trologist_
prologists13311174___prologists
radiologists1497364_radiologists
seismologists16124194seismologists
selenologists1455334selenologists
semiologists1548224se_miologists
serologist11413154se__rologist_
sexologists1947254se__xologists
sinologists1257674sin__ologists
technologists19125704technologists
teleologists1347224te_leologists
teratologists1496594teratologists
urologists1148414___urologists
virologists1546634__virologists

Search took 6 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 Filter178691950240.1261418182.5
2DLD Change Limit95024825.70316662.1
3Display Results82820.0631301.6
 (SQL Overall)178691825.89230327.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.