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

36 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
porcelainized276143(None) 
porcelainize2561461porcelainize_
porcelainizes2671531porcelainizes
porcelainizing2861353porcelainizing
porcelainlike217773porcelainlike_
cocainized2444644co_c__ainized
pollinized2245644po___llinized
porcelain1344134porcelain____
porcelains1444384porcelain___s
circularized26124155circula_rized
cocainize2245785co_c__ainize_
cocainizes2345495co_c__ainizes
formularized2752475formula_rized
gelatinized2254205___gelatinized
grecianized2453055_grecia_nized
masculinized26152205mascul_inized
melanized2158575___mela_nized
organized2047545_or__ga_nized
platinized2246915p____latinized
poeticized2445785po__e_ticized
polarized21610285po___la_rized
polemicized2753435po_le_micized
pollinize2046895po___llinize_
pollinizer2144955po___llinizer
pollinizes2146955po___llinizes
popularized2554745po_pula_rized
porcelaneous1681545porcela_neous
preconized2467145p_r_e_conized
prelaunched1951925p_r_elaunched
prelimited1545495p_r_el_imited
proclaimed1743255proc_la__imed
proletarianized2792235proletarianized
proselytized2752085prosel_ytized
prussianized24122205p_russianized
relativized2454025__r_elativized
volcanized2544925volc__a_nized

Search took 10 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.403443402.0
2DLD Change Limit124790369.25313486.4
3Display Results36360.0301200.0
 (SQL Overall)178691369.68618448.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.