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

42 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
revalorizations2754551revalorizations_
revalorization2664832revalorization__
valorizations2597793__valorizations_
decolorizations27136104decolorizations_
realizations21415534re_al__izations_
recolonizations26165764recolonizations_
regularizations2564894regularizations_
repolarizations26136174repolarizations_
revalidations1747114reval__idations_
valorization2478414__valorization__
vaporizations2776964__vaporizations_
colorizations241410355__colorizations_
dechlorinations2153115dechlorinations_
decolonizations27145965decolonizations_
decolorization26136415decolorization__
deodorizations2556325de_odorizations_
depolarizations27146335depolarizations_
desalinizations2555395desalinizations_
evaporations1744695_evapor__ations_
glamorizations2664585_glamorizations_
legalizations23410675legal__izations_
memorizations2649535me__morizations_
metallizations25126505metal_lizations_
penalizations24511635penal__izations_
prevarications2154745preva__rications_
realization20417225re_al__ization__
recanalizations2657465recanalizations_
recolonization25155885recolonization__
regularization2455165regularization__
repatriations15136515repa_tri_ations_
repolarization25116295repolarization__
retaliations12511405retal__i_ations_
revaccinations2153615reva_ccinations_
revalidation1657945reval__idation__
revalorizing2553835revaloriz__i_n_g
revaluations1557635reval___uations_
revitalizations2767625revitalizations_
secularizations2675385secularizations_
temporizations2785755te_mporizations_
terrorizations2356175te_rrorizations_
vaporization2697535__vaporization__
velarizations2549275__velarizations_

Search took 4 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 Filter178691435480.406440125.6
2DLD Change Limit43548422.76615744.0
3Display Results42420.0301400.0
 (SQL Overall)178691423.20255806.1
 
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.