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

98 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
overadvertising2371611overadvertising_
overadvertise2062724overadvertis___e
overadvertised2262204overadvertis__ed
overadvertises2162424overadvertis__es
advertising16143615____advertising_
advertisings17131785____advertisings
overasserting1754145overassert__ing_
overexercising2782585over_exercising_
advertizing25144306____advertizing_
overassertion16113516overasserti_on__
overassertions17133306overasserti_on_s
overdressing1745736over_d__ressing_
overdriving1946096over_d__r_iving_
overexerting2346496over_exert__ing_
overgoverning2162696overgover__ning_
overharvesting2461686overharvest__ing_
overidealizing2863456overid_ealizing_
overidentifying2671466overid_entifying_
overpraising1846136over___praising_
overservicing2252736over__servicing_
adverting1437227____advert__ing_
animadverting206847animadvert__ing_
mercerising1653837_mer__cer_ising_
overacting16310917overa___ct__ing_
overarching2056897overa___r_ching_
overarming1639237overa___r__ming_
overarranging1862617overa__rranging_
overassertive1982517overassert__i_ve
overasserts1453557overassert_s____
overattention16113237overattenti_on__
overattentions17103187overattenti_on_s
overbeating17410487over__beat__ing_
overbetting1747457over__be_t_ting_
overbreathing22173677over_breat_hing_
overbreathings23171677over_breat_hings
overbrowsing2143807over___browsing_
overcompressing2562267overcompressing_
overdaring1539507over_d_ar___ing_
overdecking2246057over_d_e__cking_
overdemanding2152797over_d_emanding_
overdesign1543827over_d_e___si_gn
overdesigning1952717over_d_esigning_
overdesigns1653287over_d_e___signs
overdeveloping2461787over_developing_
overdirecting2053747over_d_irecting_
overdiversities2271697overdiversiti_es
overdiversity2361847overdiver__si_ty
overdosing1547547over_d____osing_
overdramatizing3172037overdramatizing_
overdrawing1956687over_d__r_awing_
overdrinking2143977over_d__rinking_
overdrying1846547over_d__r__ying_
overdyeing1845087over_dye____ing_
overeating141016537over___eat__ing_
overediting1648047over___e_diting_
overeducating2054857overeducat__ing_
overentertained1972047overentert_ained
overexciting2565337over___exciting_
overexertion22115407over_exerti_on__
overexertions23115197over_exerti_on_s
overexposing2554197over___exposing_
overfavoring2263267overfavor___ing_
overfertilize2883307over__fertili_ze
overfertilized3063047over__fertilized
overfertilizes2973107over__fertilizes
overfertilizing31101827over__fertilizing_
overheating1849937over__heat__ing_
overidentified2262587overid_entifi_ed
overidentifies2162797overid_entifi_es
overimpressing2262437over_impressing_
overletting1548017over__le_t_ting_
overmastering1953357overmaster___ing_
overmelting1768117over__melt__ing_
overnourishing2171937over_nour_ishing_
overoperating1956727over_oper_ating_
overpowering2144467overpower___ing_
overpricing1947737over___pr_icing_
overprizing2648037over___pr_izing_
overpromising2153967over__promising_
overreporting1953807overreport__ing_
overriding1548517over____r_iding_
oversetting1548817over__se_t_ting_
oversteering1645317oversteer___ing_
overstraining1754137over__straining_
overstressing1753717over__stressing_
overstretching2361767overstre_tching_
overstriding1745617over__str_iding_
oversweetening2171867over_sweetening_
overtiming1699077o_____vertiming_
overtiring141210207o_____vertiring_
overtraining1646027over___training_
overtreating1648557over_treat__ing_
overvoting1747537over__v_ot__ing_
overwatering1954937overwater___ing_
overwetting1847257over__we_t_ting_
overwriting1847907over___wr_iting_
perverting1646627_per__vert__ing_
traversing1444807__tra_ver__sing_

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 Limit95024988.87610705.7
3Display Results98980.0761289.5
 (SQL Overall)178691989.31219189.3
 
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.