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

251 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
decanting13251063(None) 
descanting1446921descanting
recanting122414821recanting
canting104725902__canting
deaning94020472de_an_ing
debating123213732deba_ting
decamping1734942decamping
decaying15239452deca_ying
decentring1446752decentring
decocting1538122decocting
defanging1535332defanging
defatting1436102defatting
delating103119602dela_ting
demanding14237922demanding
demasting1338452demasting
dementing13311042dementing
denting94422182de__nting
depainting14156152depainting
departing1349512departing
deranging1238062deranging
derating103222282dera_ting
deratting1139512deratting
desalting1138842desalting
desanding12207652desanding
discanting1449452discanting
incanting1289902incanting
levanting1345522levanting
recaning111416692recan_ing
recasting122414232recasting
scanting113914762_scanting
tenanting1036212tenanting
accenting1487823accenting
aerating92821003aera_ting
anting75827023___anting
beaning103820683be_an_ing
beating104326873be_a_ting
becalming1635283becalming
becapping1834243becapping
bechancing2044443bechancing
bepainting15144883bepainting
berating113220763bera_ting
caning94128623__can_ing
canning103620133__canning
cantina93417253__cantina
carting104228283__carting
casting104628343__casting
catting103922643__catting
cementing1438763cementing
chanting143413533_chanting
dancing113611563d__ancing
danging103716093d__anging
darting94020663d__arting
dating85326483d__a_ting
daunting103310403d_aunting
dauting93814763d__auting
dawting123610673d__awting
deaconing1337193deaconing
deairing10311893de_airing
dealing94323233de_a_ling
deashing134210953de_ashing
deaving123814753de_a_ving
debagging1533593debagging
debarking1735383debarking
debarring1335713debarring
debasing12238063deba_sing
debiting122511203de_biting
deboning12109153debon_ing
debunking1733353debunking
debuting12268633de_buting
decant93524223decant___
decanted122310493decant_ed
decanter112510793decant_er
decanters12229223decanters
decants103514443decant__s
deceasing1338403deceasing
deceiving1635733deceiving
decentering1546483decentering
decerning1337293decerning
deciding132210833dec_iding
decimating1648753decimating
decking153915593dec__king
declaiming1644783declaiming
declaring1339573declaring
declassing1445123declassing
declawing1636213declawing
declining13129353declining
decoding132410053dec_oding
decorating14312073decorating
decoying15208763dec_oying
decreeing1335523decreeing
decrying15237413dec_rying
decrypting1943213decrypting
decupling1534973decupling
decurving1634723decurving
dedicating1539143dedica_ting
deducting1436843deducting
defacing15238683defa_cing
defaming15238463defa_ming
defaulting1543393defaulting
defeating142311973defeating
defecating17237783defeca_ting
defecting162510223defecting
defencing16226693defencing
defending15298353defending
defensing14217003defensing
defining133711803defin_ing
deflating142610713deflating
defunding15216123defunding
degassing1234823degassing
degusting1236163degusting
dehorting1447213dehorting
deigning1137753deign_ing
dejecting20217793dejecting
delaying133210973dela_ying
deleting103314423de_leting
delisting112710503delisting
demarking1736773demarking
demeaning1337243demean_ing
demitting13239073demitting
demoting12311423de_moting
demounting1444963demounting
denning93515173de__nning
denoting10311753de_noting
dentin73919573de__ntin_
dentine83320243de__ntine
dentins83419223de__ntins
denying123711293de__nying
depending14208783depending
depicting1537813depicting
deplaning1338053deplan_ing
depleting1378193depleting
deponing121211213depon_ing
deporting1369593deporting
deputing12238793de_puting
derailing112011313derailing
descending1546113descending
deserting11713143deserting
desisting112810383desisting
despiting13179323despiting
detaching1637263detaching
detailing112510413detailing
detaining112510473detaining
detecting13259983detecting
detesting112610323detesting
detonating1248823detonating
detracting1438713detracting
devaluing1434833devaluing
devesting14249903devesting
deviating14311083deviating
devoting1338823de_voting
dewaxing20215293dewa_xing
dezincing2244183dezincing
dictating1338883dictating
dilating102714903dila_ting
dinting93520553d__inting
doating93816863d_oa_ting
docketing1785413docketing
donating10311803dona_ting
drafting13339403d_rafting
dratting10389653d_ratting
ducting113713593duc__ting
dunting93418383d__unting
eanling81416673_e_anling
easting84924303_e_asting
eating75134403_e_a_ting
educating1337933educa_ting
elating83423083_ela_ting
emanating1239003_emanating
enacting11311363_enacting
enchanting1645943enchanting
exacting1838523_exacting
exalting1638033_exalting
feasting122011323fe_asting
feinting123410833fe_inting
gelating103015733gela_ting
granting103514523_granting
hanting114124483__hanting
hearting12513123he_arting
heating114024323he_a_ting
henting113719653he__nting
ideating10311703ide_a_ting
incenting12912063incenting
leaning83721203le_an_ing
legating102313113lega_ting
levantine1264793levantine
locating11311503loca_ting
meaning103918703me_an_ing
merchanting1944313merchanting
negating102012833nega_ting
panting104025423__panting
penancing1436343penancing
planting113515383_planting
precasting15169833precasting
precenting151012153precenting
quanting1849233_quanting
ranting84025413__ranting
reacting113317893re_acting
rebaiting12311643rebaiting
rebating112418343reba_ting
recalling122211903recalling
recapping1636453recapping
rechanging1746043rechanging
recharting1637213recharting
reciting113118073rec_iting
recoating121317463recoating
reconning121410793reconning
recounting1339193recounting
recrating121318793recrating
recutting1239483recutting
redacting13612303redacting
redating102620173reda_ting
regranting1238323regranting
rehanging1437563rehanging
relanding112110923relanding
relating92725443rela_ting
relenting102716773relenting
remanding132211143remanding
remanning12229033remanning
remating112322413rema_ting
reminting122315103reminting
renting84026853re__nting
repainting13128973repainting
repasting122312843repasting
repenting122316553repenting
replanting1338523replanting
rerenting102617663rerenting
resenting102619293resenting
retasting102513413retasting
retinting102215253retinting
scanning113310773_scanning
scantling12107233_scantling
scarting113415263_scarting
scatting113311813_scatting
scenting113212813_scenting
seating84130683se_a_ting
seconding1337613seconding
secreting1279823secreting
sedating103014113seda_ting
slanting94115093_slanting
tenting84621153te__nting
truanting1035603truanting
upcasting1434823upcasting
vacating14310353vaca_ting
venting114218093ve__nting
wanting114220173__wanting
weaning114117193we_an_ing
weanling12118643we_anling
webcasting1842483webcasting
yeaning113814633ye_an_ing
yeanling12107063ye_anling
yeasting12188923ye_asting

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 Filter1786911486410.436409841.7
2DLD Change Limit1486412516.54622707.1
3Display Results2512510.1102281.8
 (SQL Overall)1786912517.09225196.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.