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

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

85 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
neurosecretions1771401neurosecretions_
neurosecretion1671522neurosecretion__
neurosecretory1971234neurosecret_o_ry
oversecretions1963735over_secretions_
deconsecrations2064516deconsecrations_
desecrations1559216de___secrations_
hypersecretions2562776hypersecretions_
neuroscientist1671976neuros_cienti__st
neuroscientists1771456neuros_cientists_
neurosurgeons1471466neuros_ur_geons_
oversecretion1863946over_secretion__
persecutions1654796pe_r_sec_utions_
prosecutions1645616__prosec_utions_
reconsecrations1995106reconsecrations_
retrospections1894176retrospec__tions_
secretions12117856_____secretions_
cerebrations1646967ce_r__ebrations_
concretions1549297___co_ncretions_
consecrations1749217__consecrations_
deconsecration1954787deconsecration__
deprecations1748567depr__ec_ations_
depreciations1846577depr__eciations_
desecration14410077de___secration__
desertions1139887de___se_r_tions_
deuterations1348087deu__te_rations_
discretions1447227___dis_cretions_
enumerations14135517enu__me_rations_
erections112515217_e_r__ec__tions_
eviscerations1882707_e_viscerations_
excretions1946627_e____xcretions_
execrations2048927_e___xecrations_
exonerations1947017_e_xone_rations_
exsections1947637_e__xsec__tions_
exsertions1746747_e__xse_r_tions_
hypersecretion2463277hypersecretion__
indiscretions1652587_indis_cretions_
insurrections15104147insur_rec__tions_
intersections1598967inter_sec__tions_
introjections2255787introjec__tions_
introspections1864067introspec__tions_
neurochemist1964547neuro__chemi__st
neurochemists2063587neuro__chemists_
neuroleptics1672547neurole__pti_cs_
neuropeptides1862567neurope__ptides_
neuroscience1662637neuros_c___ience
neurosciences1762647neuros_cie_nces_
neuroscientific228907neuros_cienti_fic
neurosurgeon1361567neuros_ur_geon__
neurosurgeries15101327neurosurgeri_es_
neurulations1244737neur___ulations_
nonsecretors1452727n__onsecret_ors_
numerations13127297n_u__me_rations_
perfections1848147pe_r_fec__tions_
perorations13314067pe_ro___rations_
perpetrations1746377pe_r_petrations_
persecution1564787pe_r_sec_ution__
perseverations1953247pe_r_severations_
perspirations1786177pe_r_spirations_
procreations1647277__pro__creations_
projections2258477__projec__tions_
proscriptions19114167__pros_criptions_
prosecution1546077__prosec_ution__
prostrations1449767__pros_trations_
protections15510707__protec__tions_
reassertions1253647re_asse_r_tions_
reconsecration1885567reconsecration__
recreations13412257___r__ecreations_
refrigerations1863777refrige_rations_
reinsertions1245277re_inse_r_tions_
reoperations14410067re__ope_rations_
representations17153897representations_
reproductions1865277reproduc__tions_
resections121513037___resec__tions_
resurrections1553467resur_rec__tions_
retroactions1447077retro_ac__tions_
retrodictions1655537retrodic__tions_
retroflections1953877retroflec__tions_
retrospection1784317retrospec__tion__
retroversions1673457retrove_r_sions_
secretins11108467_____secreti_ns_
secretion11118307_____secretion__
subsections1597107_su_bsec__tions_
surjections2075287_sur_jec__tions_
trisections1345647__trisec__tions_
venesections1752937ve_nesec__tions_

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 Filter178691950240.360496363.9
2DLD Change Limit95024859.40610102.5
3Display Results85850.0631349.2
 (SQL Overall)178691859.82918180.0
 
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.