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

210 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
deceased124771(None) 
decease1049521decease_
deceases11410151deceases
decreased1345451decreased
ceased94920782__ceased
debased113310582de_based
debeaked1634612debeaked
decayed14309332dec_ayed
deceived1535892deceived
decerned1237262decerned
declared1248742declared
declassed1344992declassed
declawed1545922declawed
decrease1136562decrease_
decreases1237222decreases
defeated132812162defeated
defensed1336222defensed
degreased1244712degreased
deleaded1148332deleaded
deleaved1346572deleaved
demeaned1237282demeaned
diseased103011712diseased
recessed1139712recessed
released9310242released
accessed1385403accessed
appeased1335793appeased
beclasped1643743beclasped
becursed1335583becursed
beheaded1536373beheaded
beleaped1336103beleaped
bemeaned1335783bemeaned
bereaved1446403bereaved
cased86032413__c_ased
cease75227653__cease_
ceases84427073__ceases
censed94016323__censed
cessed94615613__cessed
chased125019293__chased
creased104315583_creased
deaerated11311113deaerated
dealated103213603dealated
deaned84620453d__eaned
deashed123411303d__eashed
deaved114916553d__eaved
debase94014473de_base_
debaser103510413de_baser
debases103814133de_bases
debated113916083de_bated
debeard1137353debea_rd
debearded1443373debearded
decade104216163dec_ade_
decades113615513dec_ades
decamped1634963decamped
decane93818873dec_ane_
decanes103118913dec_anes
decanted122310493decanted
decapod1335433dec_apod
decare93919153dec_are_
decares102818533dec_ares
decayer13339353dec_ayer
deceasing1338403deceasing
deceive1337813deceive_
deceiver1436233deceiver
deceives1437903deceives
decenter112412163decenter
decentred13236233decentred
deciare10710663deciare_
deciares11510633deciares
decided124312423dec_ided
decimated1548953decimated
decked145217623dec__ked
declaimed1544383declaimed
declare10411223declare_
declarer1148063declarer
declares11611313declares
declass1038733declas_s
declasse1165943declasse
declasses1246443declasses
declined123910883declined
decocted1437683decocted
decoded123212383dec_oded
decorated13312203decorated
decoyed14358333dec_oyed
decreed112710253dec_reed
decried112612853dec_ried
decupled1494983decupled
decurved1534843decurved
deeded94615543de_e_ded
deejayed2042443deejayed
deemed104713063de_e_med
defaced142910973de_faced
defamed14309833de_famed
defeater122611663defeater
defecated1637493defecated
defected15289973defected
defenced1537203defenced
defended1437223defended
defense1137503defense_
defenses1237913defenses
deferred13106363deferred
deflated133412303deflated
defleaed1344943deflea_ed
defoamed15356243defoamed
defrayed1635403defrayed
defused125211093de_fused
degases93413103de_gases
degassed11275963degassed
degermed1335453degermed
deglazed2034953deglazed
degraded12288323degraded
degrease1045413degrease_
degreaser1144333degreaser
degreases1146153degreases
dejected19307593dejected
delated93722873de_lated
delayed123310763de_layed
delead84112343delea__d
deleave1147723deleave_
deleaves1248063deleaves
delegated1238373delegated
deleted93314903dele_ted
deloused1036973deloused
demasted1238763de_masted
demented12311273demented
demerged13157603demerged
demised113613683de_mised
dentated10411703dentated
depended1337983depended
depermed1436453depermed
deplaned1238653deplaned
deposed113412023de_posed
depraved1535543depraved
depressed1357623depressed
derated93623503de_rated
descended1446283descended
deserted101012203deserted
deserved13108133deserved
desexed1636173dese_xed
despised1236923despised
detected12289733detected
deterged11127923deterged
deterred10137803deterred
detested10279623detested
deveined1336673deveined
develed123611933deve_led
devested13239133devested
deviated13311043deviated
devised123712563de_vised
dewaxed19316053de_waxed
dewclawed1941533dewclawed
dictated1239203dictated
discased122510853discased
disease83213843disease_
diseases92415813diseases
dogeared1145793dogeared
dreaded103612023d_readed
dreamed114310633d_reamed
dressed93511873d_ressed
eased65430403___eased
ectases92911673_ectases
emersed10138513_emersed
encased103512313_encased
enchased1437383enchased
erased74816753_e_rased
excessed1844943excessed
feased105718713__feased
greased93812393_greased
incased103612393inc_ased
incensed11277953incensed
increased1245533increased
leased74722883__leased
licensed11145723licensed
necrosed1137213necrosed
pectase112410363pectase_
pectases122411193pectases
pleased103712073_pleased
precessed1437523precessed
precreased1544413precreased
predeceased1752983predeceased
recaned102817203rec_aned
receded112713043rece_ded
received1437983received
recesses10312323recesses
reclasped1444863reclasped
recleaned1236583recleaned
recoaled113111783recoaled
recoated113416783recoated
recrated112918603recrated
recreated12412533recreated
recused104714423rec_used
regeared1039433regeared
rehearsed13305913rehearsed
reheated122415003reheated
release7312763release_
releaser839503releaser
releases8313343releases
repealed113211873repealed
repeated113117443repeated
resealed92713963resealed
reseated93220263reseated
reteamed1138013reteamed
revealed123211213revealed
reversed122711613reversed
reweaved1535953reweaved
seceded11319203sece_ded
secerned1136103secerned
surceased1264843surceased
teased74721153__teased
uncased104216953unc_ased
unleased9310713unleased

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.1561145455.1
2DLD Change Limit1461622107.12320519.7
3Display Results2102100.0802625.0
 (SQL Overall)1786912107.35924282.0
 
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.