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

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

88 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
mainstreaming186129(None) 
mainstream1452733mainstream___
mainstreamed1751383mainstream_ed
mainstreams1552283mainstream__s
mistreating1449283m_i_streating
slipstreaming186813slipstreaming
intreating11614014__in_treating
mainspring1553794mainspr___ing
maltreating1455514ma__ltreating
mastheading1843584ma__stheading
menstruating1553864m_enstruating
miscreating1648494m_i_screating
misframing1846234m_i_sfr_aming
misreading1448264m_i_s_reading
misterming1538604m_i_st_erming
mistracing1569604m_i_str_acing
painstaking1852854painst__aking
streaming12239654____streaming
airstream1153545_airstream___
airstreams1252725_airstream__s
antheming1587305_a_n_the_ming
barnstorming1751585barnst_orming
brainstorming1861325brainst_orming
castrating1349775ca__str_ating
daydreaming1961925da__ydreaming
dispreading1645915_di_spreading
distressing1385975_di_stressing
entreating11811555__en_treating
estreating11710365___estreating
gainsaying1542795gains___aying
increasing1346325__in_creasing
instating10812215__inst__ating
instigating1347155__instigating
instructing1446295__instructing
mainsprings1672405mainspr___ings
maintain1077725main_t__a_in_
maintaining1453595main_t_aining
maintains1167105main_t__a_ins
mastering122315315ma__st_e_ring
mastermind1583955ma__st_ermind
masticating1647835ma__sticating
masturbating1772675ma__sturbating
midstream1443575m_idstream___
midstreams1542575m_idstream__s
ministering1445545m_inist_e_ring
minstrelsies1451155m_instrelsies
misdealing1457365m_i_s_dealing
misdeeming1644995m_i_s_deeming
misdrawing1745805m_i_sdr_awing
miseating121215435m_i_s__eating
misesteeming1752885misest_eeming
misgrading1546825m_i_sgr_ading
mishearing1647885m_i_s_hearing
misleading1446835m_i_s_leading
misnaming1447425m_i_s__naming
mispleading1744355m_i_spleading
misrating121014855m_i_s_r_ating
misrelating1447275m_i_s_relating
misrelying1645505m_i_s_relying
misseating131310945m_i_s_seating
misspeaking2043715m_i_sspeaking
misstamping1842995m_isst__amping
misstating13129315m_isst__ating
missteering1444455m_isst_eering
misstepping1862755m_isst_epping
misstriking1843935m_isstr_iking
mistaking1699695m_i_st__aking
misteaching1944535m_i_st_eaching
mistending1447955m_i_st_ending
mistiming1438915m_i_st__iming
mistrain10311945m_i_str_a_in_
mistraining1446505m_i_straining
mistrains11511355m_i_str_a_ins
mistreatment1653445m_i_streatment
mistrusting1465925m_i_strusting
mistrysting1774315m_i_strysting
moistening1346235moi_st_e_ning
monograming1754315m_onogr_aming
outscreaming1752195_outscreaming
painstakings1961805painst__akings
reinstating1248115reinst__ating
screaming14217835____screaming
steaming114013215____st_eaming
streaking142010325____streaking
streamings13185165____streamings
unseaming1278115__uns__eaming
untreading1247565__un_treading
waitressing1552495wai__tressing

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.406440125.6
2DLD Change Limit124790889.12613674.1
3Display Results88880.0461913.0
 (SQL Overall)178691889.57818656.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.