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

57 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
decolorizations27136101decolorizations_
decolonizations27145962decolonizations_
decolorization26136412decolorization__
colorizations241410353__colorizations_
dechlorinations2153113dechlorinations_
decolonization26146023decolonization__
deodorizations2556323de_odorizations_
depolarizations27146333depolarizations_
recolonizations26165763recolonizations_
colonizations24229424__colonizations_
colorization231711194__colorization__
dechlorination2053414dechlorination__
deodorization2456464de_odorization__
depolarization26136484depolarization__
recolonization25155884recolonization__
repolarizations26136174repolarizations_
revalorizations2754554revalorizations_
secularizations2675384secularizations_
aerosolizations2453795aerosolizations_
bipolarizations2883875bipolarizations_
chlorinations1855535__chlorinations_
colonisations15216175__colonisations_
colonization232010235__colonization__
colonizationist26102185__colonizationist
colorations13911895__color__ations_
decelerations1646425deceler__ations_
dechlorinating2162185dechlorinati_n_g
decimalizations2957585decimalizations_
declarations1546805dec_lar__ations_
declinations15410225dec_l__inations_
decollations1547365decol___lations_
decolorizing2555135decoloriz__i_n_g
decorations14312885dec__or__ations_
decortications1966775deco_rtications_
deflorations1646065de_flor__ations_
defoliations1647595defol__i_ations_
deionizations2349215de__ionizations_
delocalizations27137005delocalizations_
demobilizations2955495demobilizations_
demonetizations2755715demonetizations_
demonizations25410245de__monizations_
demoralizations27128355demoralizations_
desalinizations2555395desalinizations_
discolorations17104305discolor__ations_
factorizations2855765fac_torizations_
memorizations2649535me__morizations_
motorizations2449125__motorizations_
polarizations24219715__polarizations_
regularizations2564895regularizations_
repolarization25116295repolarization__
revalorization2664835revalorization__
secularization2565645secularization__
solarizations22219275__solarizations_
temporizations2785755te_mporizations_
terrorizations2356175te_rrorizations_
valorizations2597795__valorizations_
velarizations2549275ve__larizations_

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.533335255.2
2DLD Change Limit43548572.59316794.4
3Display Results57570.0301900.0
 (SQL Overall)178691573.15656619.5
 
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.