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

49 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
specializations28115631specializations_
specialisations19132422specialisations_
specialization27106282specialization__
serializations23710933s_erializations_
socializations2548483s_ocializations_
specialisation18182753specialisation__
decimalizations2957584_decimalizations_
penalizations24511634_pe_nalizations_
serialization22911724s_erialization__
socialization2449104s_ocialization__
specifications2345354speci_fications_
sterilizations2357984steri_lizations_
cephalizations3087595_cephalizations_
decimalization2857885_decimalization__
derealizations24910815_derealizations_
equalizations3149045__equalizations_
feudalizations2756555_feudalizations_
focalizations2748995_foc_alizations_
idealizations2379455ide__alizations_
initializations2475505initializations_
labializations2547875_labializations_
legalizations23410675_le_galizations_
lexicalizations33125925_lexicalizations_
localizations2449795_loc_alizations_
mechanizations3055815_mechanizations_
musicalizations28115055musicalizations_
penalization23512665_pe_nalization__
periodizations2655575_periodizations_
pluralizations2556615_pluralizations_
radicalizations27125765radicalizations_
realizations21415535_re__alizations_
recanalizations2657465_recanalizations_
revitalizations2767625_revitalizations_
secularizations2675385s_ecularizations_
sensualizations24286205sensualizations_
signalizations2456735s_ignalizations_
specialities1656795speciali__ti_es_
specializing2655505specializ__i_n_g
speciations1548485spec___i_ations_
specification2245765speci_fication__
speculations1646395spec_ul__ations_
stabilizations2565605stabi_lizations_
sterilization2258865steri_lization__
subtilizations2556065subti_lizations_
thermalizations2955195thermalizations_
trivializations2754485trivializations_
verbalizations2849175_verbalizations_
vernalizations2649255_vernalizations_
vocalizations2749275_voc_alizations_

Search took 4 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 Limit43548492.75015835.6
3Display Results49490.0331484.8
 (SQL Overall)178691493.07958035.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.