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

47 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
marginalized256318(None) 
marginalize2364191marginalize_
marginalizes2463571marginalizes
marginalia1363273marginali__a
marginalities1654323marginalities
marginality1754403marginali_ty
marginalizing2653383marginalizing
marginated14187343margina__ted
adrenalized2253504_adrenalized
animalized2247014_a_nimalized
banalized21118704ba___nalized
canalized21611694ca___nalized
cannibalized26142974cannibalized
capitalized2556474ca_pitalized
criminalized2654034criminalized
diagonalized24253224diagonalized
digitalized2345314_digitalized
finalized22279244___finalized
jargonized2844344jargon__ized
labialized2245404la_bi_alized
magnetized23457684ma_g_netized
mainlined1254354ma__in_lined
marbelized2454614mar__belized
marginal1137604marginal____
marginally1654964marginal__ly
marginals1246004marginal___s
marginate12179604margina__te_
marginates13168744margina__tes
marginating1545894marginati_ng
margination1447434marginati_on
marginations1546454marginations
margined1237744margin____ed
marinaded13276534mar_ina__ded
marinated122513174mar_ina__ted
materialized2446554materialized
moralized21310754mor___alized
musicalized2553794m_usicalized
nationalized22197344nationalized
parfocalized2952504parfocalized
personalized2455874personalized
racialized2247684ra_ci_alized
radicalized2444844ra_dicalized
rationalized22198034rationalized
regionalized2355244_regionalized
serialized20810694ser_i_alized
signalized2145734_sig_nalized
vernalized2348424ver__nalized

Search took 8 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 Limit124790476.70318617.0
3Display Results47470.0301566.7
 (SQL Overall)178691477.12325086.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.