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

39 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
marginalization2763041marginalization_
marginalizing2653394marginaliz__i_ng
animalization2448895_a_nimalization_
animalizations2548255_a_nimalizations
canalization23411165ca___nalization_
canalizations24410435ca___nalizations
cannibalization2872805cannibalization_
capitalization2756195ca_pitalization_
capitalizations2856055ca_pitalizations
criminalization2863195criminalization_
diagonalization2663015diagonalization_
digitalization2586365_digitalization_
digitalizations2686185_digitalizations
finalization2459925___finalization_
finalizations2549255___finalizations
labialization2458345la_bi_alization_
labializations2547875la_bi_alizations
magnetization2554835ma_g_netization_
magnetizations2654285ma_g_netizations
marginalities1654335marginali__ti_es
margination1447435margin____ation_
marginations1546455margin____ations
materialization2675215materialization_
moralization23411615mor___alization_
moralizations24410815mor___alizations
musicalization2795455m_usicalization_
musicalizations28115055m_usicalizations
nationalization24114175nationalization_
personalization2654015personalization_
radicalization26126045ra_dicalization_
radicalizations27125755ra_dicalizations
rationalization24114565rationalization_
regionalization2554235_regionalization_
serialization22911725ser_i_alization_
serializations23710935ser_i_alizations
signalization2357395_sig_nalization_
signalizations2456735_sig_nalizations
vernalization25410035ver__nalization_
vernalizations2649255ver__nalizations

Search took 3 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.296603685.8
2DLD Change Limit43548392.36018452.5
3Display Results39390.0301300.0
 (SQL Overall)178691392.68666526.8
 
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.