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

40 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
subspecializes298229(None) 
subspecialize28102361subspecialize_
subspecialized30122101subspecialized
subspecialists2061992subspecialists
subspecialties2061592subspecialties
specializes2446443___specializes
subspecialist1962543subspeciali_st
subspecializing3181943subspecializing
unspecialized2763133_unspecialized
overspecializes3172554overspecializes
specialises1546004___specialises
specialize2347194___specialize_
specialized2545844___specialized
subspecialty2161934subspecial__ty
subspecies1644744subspec___i_es
subvocalizes2852194sub_voc_alizes
musicalizes2454035mu_s_ic_alizes
nonspecialists1882745nonspecialists
overspecialize3062815overspecialize_
overspecialized3272565overspecialized
resocializes23135585_res_ocializes
serializes19912055___s_erializes
socializes2148405___s_ocializes
specialise1446605___specialise_
specialised1654535___specialised
specialisms1745975___specialisms
specialists1546205___specialists
specialities1656795___specialities
specialties1544665___specialties
subdisciplines2171205subdisciplines
subjectivizes36183645sub_jectivizes
suboptimizes2752115subop_ti_mizes
subscales1347345subs__c_al__es
subsidiaries1552415subs_idiari_es
subsidizes2245085subs___i_dizes
subsocieties1652705subs_ocieti_es
subspecific2261955subspeci_fi__c
subtilizes2166875sub___ti_lizes
subvocalize2752355sub_voc_alize_
subvocalized2951905sub_voc_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.360496363.9
2DLD Change Limit95024405.87616171.5
3Display Results40400.0301333.3
 (SQL Overall)178691406.26628517.6
 
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.