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

34 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
subspecialized3012210(None) 
subspecialize28102361subspecialize_
subspecializes2982291subspecializes
unspecialized2763132_unspecialized
specialized2545843___specialized
subspecialist1962543subspeciali_st
subspecialists2061993subspecialists
subspecializing3181943subspecializing
subspecialties2061593subspecialties
overspecialized3272564overspecialized
specialised1654534___specialised
specialize2347194___specialize_
specializes2446444___specializes
subspecialty2161934subspecial__ty
subvocalized2951904sub_voc_alized
musicalized2553795mu_s_ic_alized
overspecialize3062815overspecialize_
overspecializes3172555overspecializes
resocialized24105195_res_ocialized
serialized20810695___s_erialized
socialized2247365___s_ocialized
specialise1446605___specialise_
specialises1546005___specialises
subjectivized37213215sub_jectivized
suboptimized2861705subop_ti_mized
subsidized2344325subs___i_dized
subspecies1644745subspec___i_es
subspecific2261955subspeci_fi__c
subtilized2246145sub___ti_lized
subvocalize2752355sub_voc_alize_
subvocalizes2852195sub_voc_alizes
supercivilized31101605su__percivilized
unspecified1952655_unspeci_fi_ed
unsterilized2253515_unsteri_lized

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 Limit95024345.98615874.4
3Display Results34340.0301133.3
 (SQL Overall)178691346.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.