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

93 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
declasse116594(None) 
declass1038731declass_
declassed1345001declassed
declasses1246441declasses
decease1049522decea_se
deceases11410152deceases
declare10411232decla_re
declares11611322declares
declaws1336252declaws_
because1136233bec_ause
beclasp1335263becla_sp
beclasped1643753beclasped
beclasps1444353beclasps
chasse115114603__chasse
class75525483__class_
classed104113653__classed
classer93614613__classer
classes94717943__classes
classy11379043__classy
clause84311503__clause
cyclase1436613cycla_se
cyclases1537133cyclases
dealate83617843deala_te
dealates92716683dealates
debase94014473de_ba_se
debases103814133de_bases
decade104216163dec_a_de
decades113615513dec_ades
decafs124010883dec_afs_
decals93717713dec_als_
decane93818873dec_a_ne
decanes103118913dec_anes
decare93919153dec_a_re
decares102818533dec_ares
decays124612913dec_ays_
deceased1247723deceased
deciare10710663decia_re
deciares11510633deciares
declaim1247363decla_im
declaimed1544383declaimed
declaimer1444233declaimer
declaims1345823declaims
declared1248753declared
declarer1148073declarer
declassify1952233declassify
declassing1445123declassing
declaw1266703decla__w
declawed1545933declawed
decline103716613decl_ine
declines113315803declines
decrease1136573decrease
decreases1237233decreases
deflate113613943defla_te
deflates123013943deflates
degases93413103de_gases
degassed11275963de_gassed
degasser10325813de_gasser
degasses10278363de_gasses
deglaze1835583degla_ze
deglazes1935463deglazes
delaine8314793de_laine
delate73827753de_la_te
delates83526283de_lates
delays104014053de_lays_
delouse839833de_louse
demitasse1242873demitasse
deplane10311413depla_ne
deplanes11311213deplanes
detassel943653de_tassel
dewclaws1751873dewclaws_
dewlaps1334663dewlaps_
dewless1137473dewless_
eclats8313033_eclats_
eclipse1144193_eclipse
ectases92911673_ectases
elapse857523_e_lapse
euclase938933eucla_se
euclases1039223euclases
megasse10266243me_gasse
pectase112410363pecta_se
pectases122411193pectases
pelisse967063pe_lisse
reclads1049993reclads_
reclame11411063recla_me
reclames12310893reclames
reclasp1136643recla_sp
reclasped1444873reclasped
reclasps1235053reclasps
recluse95210773recl_use
recluses105111733recluses
relapse947703re_lapse
secalose1046963secalose
unclassy1343653unclassy

Search took 8 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 Filter1786911461620.440406115.9
2DLD Change Limit146162936.82621412.5
3Display Results93930.0462021.7
 (SQL Overall)178691937.31224438.0
 
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.