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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
overdiscounting2261181overdiscounting_
overcounting1846614over___counting_
overdiscount1861594overdiscount____
overdiscounted21111104overdiscount__ed
overdiscounts1961304overdiscount___s
rediscounting1762054_re_discounting_
discounting1547445____discounting_
overdecorating2153685overd_ecorating_
dismounting1545086____dismounting_
miscounting1646056____miscounting_
overcutting1746826over___c_utting_
overdesigning1952716overdes_ign_ing_
overdirecting2053746overdi__recting_
overdocumenting2471356overdocumenting_
overhunting1856526over____hunting_
overhuntings1952866over____huntings
overissuing1544456over_is_su__ing_
overresponding2162136overrespo_nding_
overscoring1746836over__sco__ring_
overshooting1944606over__sho_oting_
discanting1449457____disc_anting_
discontinue1455237____disco_ntinue
discoursing1544857____discoursing_
disjointing2045297____disjointing_
outcounting1444307o____utcounting_
overacting16310917over__ac___ting_
overasserting1754147over_as_serting_
overcasting1748517over___c_asting_
overcastings1853957over___c_astings
overclouding1943647over__clou_ding_
overcoaching2344507over___coaching_
overcoloring1844697over___coloring_
overcoming1848737over___co__ming_
overconcerning2262427overconcern_ing_
overcooking2145797over___co_oking_
overcooling1746847over___co_oling_
overcount1448327over___count____
overcounted1745887over___count__ed
overcounts1545717over___count___s
overcuring16108767over___c_u_ring_
overdecking2246057overd_ec___king_
overdecoration2063947overd_ecorati_on
overdecorations2163727overd_ecorations
overdemanding2152797overd__emanding_
overdoing1439147overd___o___ing_
overdosing1547547overd___o__sing_
overdrinking2143977overd___rinking_
overdubbing2043587overd____ubbing_
overediting1648047overedi_____ting_
overeducating2054857overeduc__ating_
overelaborating21132287overelaborating_
overemoting1747317over__emo__ting_
overencouraging2271627over_encouraging_
overestimating2054327over_estimating_
overexciting2565337over_exc__iting_
overexploiting2762857overexplo_iting_
overfishing2145857overfis____hing_
overfocusing2153337over_foc_u_sing_
overfocussing2252317over_foc_ussing_
overfunding1945387over____funding_
overindulging1952257over_i_ndulging_
overinflating2053967over_i_nflating_
overinforming2252857over_info_rming_
overlighting2044437overli___ghting_
overmedicating2363017overmedi_c__ating_
overmining1649117overmi____n_ing_
overnighting2054257overni___ghting_
overornamenting2181537overornamenting_
overplanting1846977over___planting_
overplotting1845047over__plo_tting_
overprinting1846877over___printing_
overpromoting2153967over__promoting_
overreacting1856667overreac___ting_
overreporting1953807over_repo_rting_
overroasting1646097over___roasting_
overrunning1545057over____running_
oversalting1548577over__s__alting_
oversaturating1864047over__saturating_
oversaucing1746267over__s_au_cing_
oversetting1548817over__s__etting_
overslaughing2152087over__slaughing_
oversmoking2145047over__smo__king_
oversoaking1956787over__s_o_aking_
overspeculating2362777overspeculating_
overspending1945737over__s_pending_
overstating15410737over__s__tating_
overstocking2243647over__sto_cking_
overstudying2043177over__s_tudying_
overstuffing2253057over__s_tuffing_
oversudsing1645017over__s__udsing_
oversupping1945217over__s__upping_
overswinging2053547over__s_winging_
overtightening2261807overtighten_ing_
overvoting1747537over___vo__ting_
overwinding1955757overwi____nding_
recounting1339197___r__ecounting_
rediscount1353537_re_discount____
rediscountable196997_re_discountable
rediscounted1651987_re_discount__ed
rediscounts1452287_re_discount___s
rediscovering2062037_re_discovering_
rediscussing1661847_re_disc_ussing_
undercounting1763087__undercounting_
vermilioning1861497_vermilio_n_ing_
viscounties1653637_v___iscounti_es

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 Filter178691950240.356501941.0
2DLD Change Limit950241058.03311829.2
3Display Results1051050.0761381.6
 (SQL Overall)1786911058.46521109.4
 
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.