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

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

93 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
overadvertising237161(None) 
overadvertise2062723overadvertis__e
overadvertised2262203overadvertis_ed
overadvertises2162423overadvertis_es
advertising16143614____advertising
overasserting1754144overassert__ing
overexercising2782584over_exercising
advertisings17131785____advertisings
advertizing25144305____advertizing
overassertion16113515overasserti_on_
overassertions17133305overasserti_ons
overdressing1745735over_d__ressing
overdriving1946095over_d__r_iving
overexerting2346495over_exert__ing
overgoverning2162695overgover__ning
overharvesting2461685overharvest__ing
overidealizing2863455overid_ealizing
overidentifying2671465overid_entifying
overpraising1846135over___praising
overservicing2252735over__servicing
adverting1437226____advert__ing
animadverting206846animadvert__ing
mercerising1653836_mer__cer_ising
overacting16310916overa___ct__ing
overarching2056896overa___r_ching
overarming1639236overa___r__ming
overarranging1862616overa__rranging
overassertive1982516overassert__ive
overasserts1453556overassert_s___
overattention16113236overattenti_on_
overattentions17103186overattenti_ons
overbeating17410486over__beat__ing
overbetting1747456over__be_t_ting
overbreathing22173676over_breat_hing
overbrowsing2143806over___browsing
overcompressing2562266overcompressing
overdaring1539506over_d_ar___ing
overdecking2246056over_d_e__cking
overdemanding2152796over_d_emanding
overdesign1543826over_d_e___sign
overdesigning1952716over_d_esigning
overdeveloping2461786over_developing
overdirecting2053746over_d_irecting
overdiversities2271696overdiversities
overdiversity2361846overdiver__sity
overdosing1547546over_d____osing
overdramatizing3172036overdramatizing
overdrawing1956686over_d__r_awing
overdrinking2143976over_d__rinking
overdrying1846546over_d__r__ying
overdyeing1845086over_dye____ing
overeating141016536over___eat__ing
overediting1648046over___e_diting
overeducating2054856overeducat__ing
overexciting2565336over___exciting
overexertion22115406over_exerti_on_
overexertions23115196over_exerti_ons
overexposing2554196over___exposing
overfavoring2263266overfavor___ing
overfertilize2883306over__fertilize
overfertilizing31101826over__fertilizing
overheating1849936over__heat__ing
overidentified2262586overid_entified
overidentifies2162796overid_entifies
overimpressing2262436over_impressing
overletting1548016over__le_t_ting
overmastering1953356overmaster___ing
overmelting1768116over__melt__ing
overnourishing2171936over_nour_ishing
overoperating1956726over_oper_ating
overpowering2144466overpower___ing
overpricing1947736over___pr_icing
overprizing2648036over___pr_izing
overpromising2153966over__promising
overreporting1953806overreport__ing
overriding1548516over____r_iding
oversetting1548816over__se_t_ting
oversteering1645316oversteer___ing
overstraining1754136over__straining
overstressing1753716over__stressing
overstretching2361766overstre_tching
overstriding1745616over__str_iding
oversweetening2171866over_sweetening
overtiming1699076o_____vertiming
overtiring141210206o_____vertiring
overtraining1646026over___training
overtreating1648556over_treat__ing
overvoting1747536over__v_ot__ing
overwatering1954936overwater___ing
overwetting1847256over__we_t_ting
overwriting1847906over___wr_iting
perverting1646626_per__vert__ing
traversing1444806__tra_ver__sing

Search took 8 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 Limit95024937.10613372.4
3Display Results93930.0801162.5
 (SQL Overall)178691937.54623680.2
 
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.