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 “declasses” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
declasses124644(None) 
declasse1165941declasse_
declassed1344991declassed
classes94717942__classes
deceases11410152decea_ses
declares11611312decla_res
declass1038732decla_s_s
degasses10278362de_gasses
beclasped1643743beclasped
beclasps1444353becla_sps
chasses124017503__chasses
clashes124017283__clashes
classed104113653__classed
classer93614613__classer
classers104111833__classers
classis93712723__classis
clauses93813323__clauses
cutlasses1145103cutlasses
cyclases1537133cycla_ses
dealates92716683deala_tes
deashes113313903de__ashes
debases103814133de_ba_ses
decades113615513dec_a_des
decanes103118913dec_a_nes
decares102818533dec_a_res
decease1049523decea_se_
deceased1247713decea_sed
deciares11510633decia_res
declaimed1544383declaimed
declaimer1444233declaimer
declaimers1543593declaimers
declaims1345823decla_ims
declare10411223decla_re_
declared1248743decla_red
declarer1148063decla_rer
declarers1236423declarers
declassifies18152623declassifies
declassify1952233declassify
declassing1445123declassing
declawed1545923decla_wed
declaws1336253decla__ws
declines113315803decl_ines
decreases1237223decreases
deflates123013943defla_tes
degases93413103de_ga_ses
degassed11275963de_gassed
degasser10325813de_gasser
degassers11354833de_gassers
degausses1143203degausses
deglazes1935463degla_zes
delaines9312963de_laines
delates83526283de_la_tes
delouses9310013de_louses
demitasses1342953demitasses
deplanes11311213depla_nes
depresses1259883depresses
detassel943653de_tassel
detassels1042673de_tassels
duchesses1544133duchesses
eclipses1244213_eclipses
ectases92911673_ecta_ses
elapses957663_e_lapses
euclases1039223eucla_ses
eyasses10388023_e_yasses
eyeglasses1442263eyeglasses
glasses84414273__glasses
jackasses2243713jackasses
lasses64827593___lasses
megasses11307743me_gasses
misclasses1465043misclasses
molasses1037233_molasses
nonclasses1244963nonclasses
outclasses12145133outclasses
overclasses1644893overclasses
pectases122411193pecta_ses
pelisses1048483pe_lisses
recesses10312323rec_esses
reclames12310893recla_mes
reclasped1444863reclasped
reclasps1235053recla_sps
recluses105111733recl_uses
recrosses1138373recrosses
reglosses1045343reglosses
relapses1038033re_lapses
repasses101810373re_passes
secaloses1146913secaloses
subclasses1444743subclasses
underclasses1553133underclasses
zebrasses2043513zebrasses

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 Filter1786911486410.453394461.4
2DLD Change Limit148641897.62319499.0
3Display Results89890.0332697.0
 (SQL Overall)178691898.10922036.1
 
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.