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 “decentralize” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

38 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
decentralize245540(None) 
decentralized26144591decentralized
decentralizes2575141decentralizes
centralize2149962__centralize
centralise1269603__centralise
centralized2348153__centralized
centralizer2246833__centralizer
centralizes2249423__centralizes
decentralizing2763363decentralizing
demineralize2484863demineralize
overcentralize28114243overcentralize
centralised1446604__centralised
centralises1349294__centralises
centralism1448644__centralism
centralist12511064__centralist
centrality1547744__centrality
centralizers2354334__centralizers
decentre11248554decentr____e
decentring1446754decentr__ing
decimalize2446604dec__imalize
degenerative1754964degenerative
demineralized2694074demineralized
demineralizer2593584demineralizer
demineralizes25104444demineralizes
demoralize2269224d__emoralize
denaturalize2264254denaturalize
desacralize2354294de_sacralize
desexualize2854184dese_xualize
devitalize23107654de_vit_alize
essentialize2163764essentialize
federalize2345824fede__ralize
generalize20198454__generalize
neutralize19117924__neutralize
orientalize2065984orient_alize
overcentralized30133774overcentralized
overcentralizes29123884overcentralizes
recanalize2147254recan__alize
technicalize2893074technicalize

Search took 9 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 Filter1786911247900.390458182.1
2DLD Change Limit124790387.94015716.6
3Display Results38380.0162375.0
 (SQL Overall)178691388.34621410.4
 
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.