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

33 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
overcompressing2562261overcompressing_
overimpressing2262433over_impressing_
decompressing2152914_de_compressing_
overcompress2182914overcompress____
overcompressed2472714overcompress__ed
overcompresses2372854overcompress__es
compressing1846425____compressing_
overcorrecting2262755overco_rrecting_
overdressing1745735over___dressing_
overstressing1753715over__stressing_
decompression20102746_de_compressi_on
decompressions21102656_de_compressions
derepressing1653566_der__epressing_
encompassing1962296__encomp_assing_
overcoloring1844696overcolor___ing_
overcoming1848736overcom_____ing_
overcommitting2462216overcom_mitting_
overcompensate2393016overcomp_ens_ate
overcompensated2582766overcomp_ensated
overcompensates2482846overcomp_ensates
overconcerning2262426overco_ncerning_
overcontrolling2171396overcontrolling_
overfocussing2252316overfo__cussing_
overimpress1852326over_impress____
overimpressed2162426over_impress__ed
overimpresses2062766over_impress__es
overnourishing2171936overno_urishing_
overoperating1956706over_o_perating_
overpassing1746646over___p_assing_
overpraising1846136over___praising_
overprocessing2262856over_processing_
overspreading2053606over__spreading_
recompensing1953866_re_comp_ensing_

Search took 7 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 Filter178691658740.1101624463.6
2DLD Change Limit65874336.32610413.2
3Display Results33330.0331000.0
 (SQL Overall)178691336.46927622.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.