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

40 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
suboptimization3061271suboptimization_
optimization25166464___optimization_
optimizations26155714___optimizations
suboptimizing2961644suboptimiz__i_ng
subtilization2456634sub__tilization_
subtilizations2556064sub__tilizations
optimisation16193945___optimisation_
optimisations17153445___optimisations
suborganization2762185suborganization_
subsidization2553985sub__sidization_
subsidizations2653735sub__sidizations
eroticization2476036_ero_ticization_
eroticizations25115786_ero_ticizations
legitimization2673606_legitimization_
legitimizations2773336_legitimizations
lyophilization31112386_lyophilization_
lyophilizations32122196_lyophilizations
robotization2346866robo_t__ization_
robotizations2446346robo_t__izations
routinization2255836__routinization_
routinizations2355546__routinizations
solmization2247326s__o__lmization_
solmizations2346636s__o__lmizations
suberization2359246sub___erization_
suberizations2468776sub___erizations
sublimation1557186sub__lim__ation_
sublimations1646086sub__lim__ations
suboptimize2662026suboptimiz_____e
suboptimized2861706suboptimiz____ed
suboptimizes2752116suboptimiz____es
subordination1654176subo__rdination_
subordinations1754006subo__rdinations
suburbanization2862056suburbanization_
subvocalization3161926subvocalization_
systemization2774466s__ystemization_
systemizations2864086s__ystemizations
utilization2049686_u___tilization_
utilizations2148896_u___tilizations
victimization2984596__victimization_
victimizations3064286__victimizations

Search took 6 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.0901985455.6
2DLD Change Limit65874404.91013416.3
3Display Results40400.0301333.3
 (SQL Overall)178691405.03035525.0
 
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.