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

168 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
deceasing133840(None) 
decreasing1446521decreasing
ceasing104118262__ceasing
debasing12238062de_basing
debeaking1735922debeaking
decaying15239452dec_aying
deceiving1635732deceiving
decerning1337292decerning
declaring1339572declaring
declassing1445122declassing
declawing1636212declawing
defeating142311972defeating
defensing14217002defensing
degreasing1345422degreasing
deleading1237772deleading
deleaving1436262deleaving
demeaning1337242demeaning
diseasing11310832diseasing
recessing12611012recessing
releasing10411012releasing
unceasing1239652unceasing
accessing1445833accessing
appeasing1446343appeasing
beclasping17134073beclasping
becursing1435453becursing
beheading1636163beheading
beleaping1436743beleaping
bemeaning1436193bemeaning
bereaving1537573bereaving
casing94829103__c_asing
censing104215263__censing
cessing103814813__cessing
chasing133715893__chasing
creasing113314443_creasing
deaerating12311563deaerating
dealing94323233d__ealing
deaning94020473d__eaning
deashing134210953d__eashing
deaving123814753d__eaving
debating123213733de_bating
debearding1543733debearding
decamping1734943decamping
decanting132510633decanting
decease1049523deceas__e
deceased1247723deceas_ed
deceases11410153deceas_es
decentring1446753decentring
deciding132210833dec_iding
decimating1648763decimating
decking153915593dec__king
declaiming1644783declaiming
declining13129353declining
decocting1538123decocting
decoding132410053dec_oding
decorating14312073decorating
decoying15208763dec_oying
decreasingly1952233decreasingly
decreeing1335523decreeing
decrying15237413dec_rying
decupling1534973decupling
decurving1634723decurving
deeding103315123de_e_ding
deejaying2142753deejaying
deeming113913123de_e_ming
defacing15238683de_facing
defaming15238463de_faming
defecating17237783defecating
defecting162510223defecting
defencing16226693defencing
defending15298353defending
deferring1436143deferring
deflating142610713deflating
defleaing1444743deflea_ing
defoaming1645653defoaming
defraying1735853defraying
defusing13227943de_fusing
degassing1234823degassing
degerming1435753degerming
deglazing2135133deglazing
degrading13137373degrading
dejecting20217793dejecting
dekeing13358353deke__ing
delating103119603de_lating
delaying133210973de_laying
delegating1337673delegating
deleing93313953dele__ing
deleting103314423dele_ting
delousing1136303delousing
demasting1338453de_masting
dementing13311043dementing
demerging1436643demerging
demising122012523de_mising
depending14208783depending
deperming1537113deperming
deplaning1338053deplaning
deposing12129773de_posing
depraving1635973depraving
depressing1448093depressing
derating103222283de_rating
descending1546113descending
deserting11713143deserting
deserving1497903deserving
desexing1736293dese_xing
despising13167503despising
detecting13259983detecting
deterging1237853deterging
deterring1138623deterring
detesting112610323detesting
deveining1436393deveining
develing133212733deve_ling
devesting14249903devesting
deviating14311083deviating
devising133111523de_vising
dewaxing20215293de_waxing
dictating1338883dictating
discasing1339433discasing
dogearing1235763dogearing
dreading113712803d_reading
dreaming124011063d_reaming
dressing102810423d_ressing
easing74926463___easing
encasing11610823_encasing
enchasing1567733enchasing
erasing8317963_e_rasing
excessing1945713excessing
feasing113916653__feasing
greasing102811393_greasing
incasing11610603inc_asing
incensing1297663incensing
increasing1346323increasing
leasing83920163__leasing
licensing1244753licensing
necrosing1247703necrosing
pleasing112611593_pleasing
precessing1598743precessing
precreasing1645703precreasing
predeceasing18103063predeceasing
recaning111416693rec_aning
recasting122414233rec_asting
receding122713763rece_ding
receiving1538993receiving
reclasping15105083reclasping
recleaning1336753recleaning
recoaling121312453recoaling
recoating121317463recoating
recrating121318793recrating
recreating131214583recreating
recusing112512883rec_using
regearing112211413regearing
rehearing132211763rehearing
rehearsing1444343rehearsing
reheating132314913reheating
repealing122513543repealing
repeating122618983repeating
rereading111212713rereading
resealing102115673resealing
reseating102421533reseating
reteaming122110443reteaming
retearing102214253retearing
revealing132611883revealing
reversing132611483reversing
rewearing132310703rewearing
reweaving16227073reweaving
seceding12288563sece_ding
secerning1246203secerning
surceasing1345073surceasing
teasing83918513__teasing
uncasing11511003unc_asing

Search took 7 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.420425454.8
2DLD Change Limit1486411686.45323034.4
3Display Results1681680.0802100.0
 (SQL Overall)1786911686.95325699.8
 
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.