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

133 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
decamping173494(None) 
becapping1834242becapping
camping143118972__camping
damping133414002d__amping
decanting132510632decanting
decaying15239452deca_ying
defaming15238462defam_ing
encamping1645232encamping
recapping1636452recapping
revamping1734632revamping
scamping153510192_scamping
amping114317573___amping
beaming123618803be_am_ing
becalming1635283becalming
beclasping17134073beclasping
becoming1538163becom_ing
bedamning1534183bedamning
benaming1339693benam_ing
campings154010203__campings
campong14318123__campong
capping143819673__capping
carping123521083__carping
champing183610933_champing
clamping154011153_clamping
comping143518593__comping
cramping153411853_cramping
damming133812743d__amming
damning114211633d__amning
dampings14377523d__ampings
dapping133714793d__apping
deaconing1337193deaconing
deairing10311893de_airing
dealing94323233de_a_ling
deaning94020473de_a_ning
deashing134210953de_ashing
deaving123814753de_a_ving
debagging1533593debagging
debarking1735383debarking
debarring1335713debarring
debasing12238063deba_sing
debating123213733deba_ting
decamp1338453decamp___
decamped1634963decamp_ed
decampment1954183decampment
decamps1435643decamp__s
deceasing1338403deceasing
deceiving1635733deceiving
decerning1337293decerning
deciding132210833dec_iding
decimating1648753decimating
decking153915593dec__king
declaiming1644783declaiming
declaring1339573declaring
declassing1445123declassing
declawing1636213declawing
declining13129353declining
decocting1538123decocting
decoding132410053dec_oding
decomposing1943633decomposing
decoupling1643693decoupling
decoying15208763dec_oying
decreeing1335523decreeing
decrying15237413dec_rying
decrypting1943213decrypting
decupling1534973decupling
decurving1634723decurving
deeming113913123de_em_ing
defacing15238683defa_cing
defanging1535333defanging
defatting1436103defatting
defoaming1645653defoam_ing
degassing1234823degassing
degumming1643133degumming
delating103119603dela_ting
delaying133210973dela_ying
deliming12310373delim_ing
demanding14237923demanding
demarking1736773demarking
demasting1338453demasting
demoing11311753de__moing
departing1349513departing
derailing112011313derailing
deranging1238063deranging
derating103222283dera_ting
deratting1139513deratting
desalting1138843desalting
desanding12207653desanding
descanting1446923descanting
detaching1637263detaching
detailing112510413detailing
detaining112510473detaining
devaluing1434833devaluing
dewaxing20215293dewa_xing
dramming14347563d_ramming
draping114213353d_ra_ping
dreaming124011063dream_ing
dumping133712913d__umping
escaping1347063esca_ping
escarping1435203escarping
exampling2143553_exampling
heaping133015853he_a_ping
lamping123116003__lamping
leaping103215993le_a_ping
ramping123316873__ramping
reaming103924013re_am_ing
reaping103621213re_a_ping
recalling122211903recalling
recaning111416693reca_ning
recanting122414823recanting
recasting122414233recasting
reclasping15105083reclasping
recombing1637323recombing
recouping1438363recouping
remapping1635023remapping
renaming11313693renam_ing
repumping1634813repumping
resampling1544333resampling
restamping1565213restamping
retaping113012553reta_ping
scalping133410453_scalping
scamming15328543_scamming
scaping123715693_sca_ping
scarping133312463_scarping
seaming103222113se_am_ing
stamping133310963_stamping
swamping16307923_swamping
tamping122815813__tamping
teaming103917593te_am_ing
temping122710693te__mping
tramping132711273_tramping
uncapping1635133uncapping
unclamping1743433unclamping
vamping152810233__vamping

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.420425454.8
2DLD Change Limit1486411336.87621617.4
3Display Results1331330.0632111.1
 (SQL Overall)1786911337.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.