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

39 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
subspecialize2810236(None) 
subspecialized30122101subspecialized
subspecializes2982291subspecializes
subspecialist1962542subspecialist
specialize2347193___specialize
subspecialists2061993subspecialists
subspecializing3181943subspecializing
subspecialties2061593subspecialties
subspecialty2161933subspecial_ty
unspecialized2763133_unspecialized
overspecialize3062814overspecialize
specialise1446604___specialise
specialized2545844___specialized
specializes2446444___specializes
subspecific2261954subspeci_fi_c
subvocalize2752354sub_voc_alize
musicalize2354495mu_s_ic_alize
nonspecialist1793625nonspecialist
overspecialized3272565overspecialized
overspecializes3172555overspecializes
resocialize22115905_res_ocialize
serialize18812635___s_erialize
socialize2048825___s_ocialize
specialised1654535___specialised
specialises1546005___specialises
specialism1646815___specialism
specialist1448345___specialist
speciality1746335___speciality
subdiscipline2071415subdiscipline
subjectivize35183735sub_jectivize
suboptimize2662025subop_ti_mize
subscale1247615subs__c_al__e
subsidize2145185subs___i_dize
subsocial1345825subs_ocial___
subspecies1644745subspec___ies
subtilize2087135sub___ti_lize
subvocalized2951905sub_voc_alized
subvocalizes2852195sub_voc_alizes
superspecialist21102155superspecialist

Search took 9 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.406440125.6
2DLD Change Limit124790398.48614705.4
3Display Results39390.0301300.0
 (SQL Overall)178691398.92220028.1
 
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.