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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

243 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
deceases1141015(None) 
decease1049521decease_
deceased1247711deceased
decreases1237221decreases
ceases84427072__ceases
debases103814132de_bases
decades113615512dec_ades
decanes103118912dec_anes
decares102818532dec_ares
deceives1437902deceives
deciares11510632deciares
declares11611312declares
declass1038732declas_s
declasse1165942declasse
declasses1246442declasses
decrease1136562decrease_
decreased1345452decreased
defenses1237912defenses
degases93413102de_gases
degreases1146152degreases
deleaves1248062deleaves
diseases92415812diseases
ectases92911672_ectases
pectases122411192pectases
recesses10312322recesses
releases8313342releases
accesses1287493accesses
appeases1238663appeases
asceses938623asce_ses
beclasps1444353beclasps
becurses1236723becurses
berceuses1344103berceuses
bereaves1338273bereaves
bicepses1443873bicepses
boreases10310253boreases
caseases10410473caseases
cases75048383__c_ases
cease75227653__cease_
ceased94920783__ceased
censes83721803__censes
cereuses1049243cereuses
cesses84221363__cesses
chases115128233__chases
crases85532313__crases
creases94020963_creases
cycases1437533cyc_ases
cyclases1537133cyclases
deaerates10313643deaerates
dealates92716683dealates
deashes113313903d__eashes
deaves105319533d__eaves
debase94014473de_base_
debased113310583de_based
debaser103510413de_baser
debasers11377903de_basers
debates103718533de_bates
debeaked1634613debeaked
debeaks1436103debea_ks
debeards1235503debeards
decade104216163dec_ade_
decafs124010883dec_a_fs
decals93717713dec_a_ls
decamps1435643dec_amps
decane93818873dec_ane_
decants103514443dec_ants
decare93919153dec_are_
decayed14309333dec_ayed
decayer13339353dec_ayer
decayers14307963dec_ayers
decays124612913dec_a_ys
deceasing1338403deceasing
deceits102810883dece_its
deceive1337813deceive_
deceived1535893deceived
deceiver1436233deceiver
deceivers1535723deceivers
decenaries1348123decenaries
decencies1448943decencies
decenter112412163decenter
decenters122410373decenters
decentest1249083decentest
decentres12238523decentres
decerned1237263decerned
decerns10119053dece_rns
deciare10710663deciare_
decides114217653dec_ides
deciles104417723dec_iles
decimates14410693decimates
deckles143312803dec_kles
declaims1345823declaims
declare10411223declare_
declared1248743declared
declarer1148063declarer
declarers1236423declarers
declassed1344993declassed
declawed1545923declawed
declaws1336253decla_ws
declines113315803declines
decodes113914983dec_odes
decorates12314743decorates
decrees102513123dec_rees
decries103319803dec_ries
decuples1395283decuples
decuries11312223decuries
decurves1435863decurves
defaces133213403de_faces
defames132812253de_fames
defeated132812163defeated
defeater122611663defeater
defeaters13289103defeaters
defeats113511233defea_ts
defecates1538593defecates
defences1439633defences
defense1137503defense_
defensed1336223defensed
deflates123013943deflates
defuses114814593de_fuses
degames113312623de_games
degasses10278363degasses
deglazes1935463deglazes
degrades11269923degrades
degrease1045413degrease_
degreased1244713degreased
degreaser1144333degreaser
degreasers1243143degreasers
deixises1635693deixises
dekares122710873de_kares
delates83526283de_lates
deleaded1148333deleaded
deleads9379703delea_ds
deleave1147723deleave_
deleaved1346573deleaved
delegates1139843delegates
deletes83117933dele_tes
delouses9310013delouses
demasts1089223de_masts
demeaned1237283demeaned
demeans1039723demea_ns
demerges12129503demerges
demesnes1137083demesnes
demises103719563de_mises
demoses103815833de_moses
deplanes11311213deplanes
deposes103117213de_poses
depraves1436873depraves
depresses1259883depresses
derates84028893de_rates
dermises112512023dermises
derrises93012783derrises
deserves12109893deserves
desexes1537833dese_xes
despises1139433despises
detentes92712873detentes
deterges101510093deterges
detests83711743dete_sts
devests114410473deve_sts
deviates12312733deviates
devises114116763de_vises
dewaxes18297843de_waxes
diabases1137223diabases
dicasts1078703dic_asts
dickenses1645073dickenses
dictates11311383dictates
diereses938693diere_ses
dieses75218693d_ie_ses
dioceses1137113dioce_ses
discases112014503discases
disease83213843disease_
diseased103011713diseased
diseuses93112763diseuses
dockages1635983dockages
dresses83716173d_resses
duchesses1544133duchesses
duenesses1039333duenesses
duresses939173duresses
eases56041613___eases
ecdyses1333413_ecdyses
ecesis84611203_ece_sis
ecesises1037023_ecesises
ectasis9249613_ectasis
emeses86114963_eme_ses
encases93116053_encases
enchases13310273enchases
entases72816273_entases
erases64425403_e_rases
euclases1039223euclases
excesses1736753excesses
eyases94513683_e_yases
feases95422923__feases
geneses82613523gene_ses
greases84816713_greases
hectares1338853hectares
idocrases1273793idocrases
incases93615973inc_ases
incenses102411003incenses
increases1157383increases
lactases1038523lactases
leases65428113__leases
licenses10118923licenses
miseases102614343miseases
necroses10310563necroses
nemeses948663neme_ses
nucleases1146493nucleases
peases85229473__peases
pectase112410363pectase_
pectates122213953pectates
permeases1347103permeases
pleases94515483_pleases
precesses13310463precesses
precreases1445653precreases
predeceases1653623predeceases
recanes93222263rec_anes
recasts93413533rec_asts
recedes102816063rece_des
receives1339743receives
recess8314263rece_s_s
recessed1139713recessed
reclames12310893reclames
reclasps1235053reclasps
recluses105111733recluses
recrates102420373recrates
recreates11313363recreates
recuses94619463rec_uses
rehearses12286843rehearses
release7312763release_
released9310243released
releaser839503releaser
releasers937323releasers
rennases848983rennases
reverses112513513reverses
reweaves1436603reweaves
secedes103711983sece_des
sucrases10310253sucrases
surceases1157473surceases
teases65426273__teases
teleses7313123tele_ses
teniases838623teniases
terrases82111483terrases
texases1437573te_xases
uncases93516553unc_ases
uneases73316263_uneases
ureases74416723_ureases
whereases1545673whereases

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622437.89018525.0
3Display Results2432430.0932612.9
 (SQL Overall)1786912438.40621257.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.