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

110 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
ichthyologies255229(None) 
ichthyologist2562782ichthyologist
ichthyologists2662312ichthyologists
ichnologies1746363ic__hnologies
ichthyological2882453ichthyological
ichthyology2652163ichthyolog__y
anthologies151012014_anth_ologies
cetologies13410854_cet__ologies
chronologies1846414_chronologies
cytologies1639264_cyt__ologies
ethnologies1547984__ethnologies
ethologies14310544__eth_ologies
ichthyoids2251884ichthy__o_ids
iconologies1447094ic__onologies
lichenologies1952914lich_enologies
lithologies1546834_lith_ologies
mythologies2047844_myth_ologies
pathologies1748734_path_ologies
scatologies1446864scat__ologies
theologies141010104___theologies
victimologies2151764vic_timologies
acarologies1446065ac__arologies
aetiologies1248985_aet_iologies
anthologizes253038395_anth_ologizes
archaeologies1952825arch_aeologies
archeologies1845005_archeologies
astrologies1247925_ast_rologies
autecologies1554575_autecologies
bryologies1646045___bryologies
cardiologies1644955_cardiologies
carpologies1646405_c_arpologies
codicologies1853665_codicologies
cohomologies2054055_cohomologies
conchologies2054565_conchologies
coprologies1646945_c_oprologies
cosmologies1646705_c_osmologies
craniologies1545375_craniologies
cryptologies2055425_cryptologies
dactylologies2051805dactylologies
ecologies12312355ec____ologies
ecophysiologies2671305ecophysiologies
embryologies2053165_embryologies
entomologies1575325_entomologies
epiphytologies2561415epiphytologies
eschatologies1952635esch_atologies
etiologies1139415__et_iologies
etymologies17176805__etymologies
fetologies1439185_fet__ologies
futurologies1652425_futurologies
graphologies1963735graph_ologies
hagiologies1645345__hagiologies
haplologies1744765__haplologies
herbologies1746565__herbologies
hierologies1547065__hierologies
histologies1546635__histologies
homologies16311525__h_omologies
horologies14411055__h_orologies
hydrologies1948185__hydrologies
hymnologies2046105__hymnologies
hypnologies2046085__hypnologies
ichthyofaunas2781335ichthyofaunas
ichthyoid2152315ichthy__o_i_d
ichthyophagous2781085ichthyophagous
ichthyosaurs2371545ichthyo_saurs
ideologies1237335i___deologies
immunologies1774305i_mmunologies
iridologies1344585i__ridologies
karyologies1944445__karyologies
martyrologies1952335martyrologies
methodologies2053485methodologies
metrologies1449585_met_rologies
microbiologies2164985microbiologies
morphologies2044525morph_ologies
myologies1539755____myologies
mythologizes3054615_myth_ologizes
nephologies1747355_neph_ologies
nephrologies1845075_nephrologies
nostologies1246585nost__ologies
oceanologies1554235oc_eanologies
ontologies1139885_ont__ologies
ophiologies1746015__ophiologies
ophthalmologies2671605ophthalmologies
ornithologies1752735ornith_ologies
osteologies1247055_ost_eologies
otologies10311405__ot__ologies
petrologies1449895_pet_rologies
phenologies1749355_ph_enologies
philologies1747205_ph_ilologies
phlebologies2054655_phlebologies
phonologies17410005_ph_onologies
phrenologies1846315_phrenologies
phycologies2247785_ph_ycologies
physiologies2155365_physiologies
phytologies2049045_ph_ytologies
psephologies2044845pseph_ologies
psychologies23127855psych_ologies
rheologies1488435___rheologies
rhinologies1546505_rh_inologies
sitologies1148705_sit__ologies
tautologies1245915taut__ologies
technologies1845975_technologies
theologise14117745___theologise
theologises15106735___theologises
theologizes24106065___theologizes
theologues14124405___theologues
tocologies1349765___tocologies
tokologies1547145___tokologies
topologies1348975___topologies
trichologies1845575trich_ologies
typologies1647645___typologies

Search took 9 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.420425454.8
2DLD Change Limit1247901107.84615904.9
3Display Results1101100.0601833.3
 (SQL Overall)1786911108.32621461.8
 
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.