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

33 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
provincializes306203(None) 
provincialize2962071provincialize_
provincialized3161831provincialized
provincialisms23102222provincialisms
provincialists21122312provincialists
provincialities2262252provincialities
provincialism22102433provinciali_sm
provincialist20102813provinciali_st
provinciality2362343provinciali_ty
provincializing3271593provincializing
provincials1852943provincial___s
politicalizes2663184p_oliticalizes
provincial1754014provincial____
provincially2253024provincial__ly
tropicalizes2554124tropi_c_alizes
colonializes2354395_colon_ializes
criminalizes2554675crimin__alizes
politicalize2553825p_oliticalize_
politicalized2762825p_oliticalized
principalities2083205pr__incipalities
principles1643845pr__incipl__es
prolificacies22131655prolificaci_es
pronunciations18122785pronunciations
provinces1646855provinc_____es
provocatives2253375prov_oc_atives
racializes2148465_r___acializes
radicalizes2345695_radi_c_alizes
resocializes23135585_r_esocializes
revitalizes23117695_revi__talizes
socializes2148405_so___cializes
trivializes2385325tr__i_vializes
tropicalize2454315tropi_c_alize_
tropicalized2653335tropi_c_alized

Search took 7 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 Filter178691950240.343520965.0
2DLD Change Limit95024335.98315882.3
3Display Results33330.0331000.0
 (SQL Overall)178691336.35928100.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.