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

44 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
overaccentuates2271511overaccentuates_
overaccentuate2171542overaccentuate__
overaccentuated2371472overaccentuate_d
accentuates1553065____accentuates_
accentuate1453526____accentuate__
accentuated1652706____accentuate_d
accentuating1762837____accentuating
accentuation1653467____accentuation
deconcentrates1993147_deconcentrates_
deracinates1445867_dera_cin__ates_
eventuates1394187__e___ventuates_
fragmentates1852587__fragment_ates_
orchestrates1773797o__r_chestrates_
orientates1046047o__r__ient_ates_
overacute1447117overa_c___u_te__
overadvertises2162427overadvert_ises_
overarticulates2072627overarticulates_
overattentions17103187overattent_ions_
overcentralize28114247over__centralize
overcentralizes29123887over__centralizes_
overcompensates2482847overcompen_sates_
overconsumes1952937over__consu_mes_
overdecorates1953437over__decorates_
overeducates1854397over___educates_
overestimates1854867over___estimates_
overidentifies2162797over_identifies_
overinflates1853957over___inflates_
overingenuities1991737overingen_uities_
overmedicates2153517over__medicates_
overoperates17116617over_ope__rates_
overorchestrate2381427overorchestrate__
overpersuades19112147over__persuades_
overregulates1794547over__regulates_
oversaturates1654217over___saturates_
overspeculates21133407over_speculates_
overstates131110117over____st_ates_
oxalacetates2171157oxala_ce_t_ates_
peradventures1961267_peradventu_res_
percentages1653427_per__cent_ages_
perpetuates1584307_per__pe_tuates_
reaccelerates1761987_re_accelerates_
reconcentrates1893487_reconcentrates_
revaccinates19143357_revaccin__ates_
vaccinates1746567_v__accin__ates_

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.343520965.0
2DLD Change Limit95024448.90610669.7
3Display Results44440.0331333.3
 (SQL Overall)178691449.28219251.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.