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

66 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
overspeculated2212336(None) 
overspeculate20123501overspeculate_
overspeculates21133401overspeculates
overpopulated2194413over_populated
overregulated1894423over_regulated
overspeculating2362773overspeculating
overspeculation2263333overspeculation
overstimulated2093673overstimulated
operculated1645154oper___culated
overarticulated2182534overarticulated
overdecorated2053444over_decorated
overeducated1954354over__educated
overoperated1876044overope__rated
overpopulate19114684over_populate_
overpopulates2094594over_populates
overregulate1684494over_regulate_
overregulates1794544over_regulates
oversaturated1754094overs_aturated
overspecialized3272564overspecialized
overstimulate1883844overstimulate_
overstimulates1983654overstimulates
speculated15186614____speculated
vermiculated2064514_ver_miculated
vesiculated1745554_ve_s_iculated
deregulated14134735_der__egulated
gesticulated1654545_ge_sticulated
operculate1446255oper___culate_
osculated1298145o___s__culated
overarticulate1972715overarticulate_
overarticulates2072625overarticulates
overdecorate1853745over_decorate_
overdecorates1953435over_decorates
overeducate1754515over__educate_
overeducates1854395over__educates
overheated1739485over_he___ated
overinflated1953945over__inflated
overmedicated2253485over_medicated
overmelted1646905over_me__l_ted
overoperate1676695overope__rate_
overoperates17116615overope__rates
overpackaged2552035over_pac_kaged
overpedaled1844305over_pe__daled
overpedalled1953025over_pedal_led
overpeopled1944115over_peopl__ed
overpersuaded20122085over_persuaded
overplanted1746235over_p___lanted
overplayed19206755over_p___layed
oversalted1447685overs___al_ted
oversaturate1554425overs_aturate_
oversaturates1654215overs_aturates
overscaled1646465overs__c__aled
overspecialize3062815overspecialize
overspecializes3172555overspecializes
overspiced1845955overspic____ed
overspilled1743805oversp__il_led
overstated14119445overs____tated
overtreated1547415overtre___ated
peculated142310845_____peculated
perpetuated1653755_per_petu_ated
persecuted1543505_pers_ecu__ted
reregulated13135405_rer__egulated
speculate13239185____speculate_
speculates14237905____speculates
vermiculate1855725_ver_miculate_
vesiculate1547225_ve_s_iculate_
vesiculates1646295_ve_s_iculates

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.1101624463.6
2DLD Change Limit95024666.92313725.8
3Display Results66660.0461434.8
 (SQL Overall)178691667.07925242.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.