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

280 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
decamp133845(None) 
decamps1435641decamps
became123213162became
becap114315052beca_p
camp106336452__camp
damp96228842d__amp
decade104216162decade
decaf114919442deca_f
decafs124010882decafs
decal85523232deca_l
decals93717712decals
decamped1634962decamped
decane93818872decane
decant93524222decant
decare93919152decare
decay114718482deca_y
decays124612912decays
defame123212432defame
degame102713182degame
degami10279012degami
encamp1235942encamp
recap95718022reca_p
revamp1336012revamp
scamp115717312_scamp
abamp11310603_abamp
amp77541023___amp
beam86939233be_am_
beams95328173be_ams
beamy126218573be_amy
becalm1239203becalm
becalms1335743becalms
becaps123811403becaps
beclasp1335263beclasp
become123312593become
bedamn1137813bedamn
bedlamp1464513bedlamp
bename103316073bename
cam78058983__cam_
came87648753__came
camo85731753__camo
campi116217783__campi
campo115219763__campo
camps116330263__camps
campy145116183__campy
cams87047283__cams
cap76758983__ca_p
carp85139813__carp
ceca84820783ceca__
cecal94619113ceca_l
cecum11611843cecum_
champ145017963_champ
clamp115517653_clamp
comp106731253__comp
cramp115120693_cramp
dam67457043d__am_
dame77140313d__ame
damn75724323d__amn
damps105220413d__amps
dams77444373d__ams
dap66652453d__a_p
deacon9510423deacon
dead65434243de_a_d
deads75726913de_ads
deaf85838403de_a_f
deair65817193de_air
deal56347413de_a_l
deals65435343de_als
dealt65234283de_alt
dean56039483de_a_n
deans66131393de_ans
dear55343603de_a_r
dears65736883de_ars
deary95826843de_ary
deash95617243de_ash
death94822523de_ath
deave95022333de_ave
debag94212303deba_g
debags104211063debags
debar85517863deba_r
debark134210943debark
debars94218043debars
debase94014473debase
debate94419193debate
decadal1137243decadal
decades113615513decades
decagon1135863decagon
decalog1136003decalog
decamping1734943decamping
decanal1038113decanal
decanes103118913decanes
decants103514443decants
decapod1335433decapod
decares102818533decares
decayed14309333decayed
decayer13339353decayer
decease1049523decease
deceit93018213deceit
decent94023703decent
decern91310953decern
deciare10710663deciare
decide104116873decide
decile94619213decile
decimal1238083decimal
deck115827753dec__k
decked145217623decked
deckel134911043deckel
decker135215993decker
deckle1312012453deckle
decks124822193dec_ks
declaim1247363declaim
declaims1345823declaims
declare10411223declare
declass1038733declass
declaw1266703declaw
declaws1336253declaws
deco76125973dec__o
decoct11313783decoct
decode104414743decode
decor84717573dec_or
decors94017773decors
decos85522123dec_os
decoy115716313dec_oy
decoys123911283decoys
decree93117783decree
decry115514353dec_ry
decrypt1545703decrypt
decuman1236573decuman
decury1277963decury
dedal75719023deda_l
dedans85915073dedans
deem75432893de_em_
deems85421773de_ems
deep76031883de__ep
deface123113863deface
defamed14309833defamed
defamer132710323defamer
defames132812253defames
defang1137753defang
defat95426693defa_t
defats105114553defats
defoam1238563defoam_
defoams1336193defoams
degage92711383degage
degames113312623degames
degamis11268443degamis
degas75119163dega_s
degum94711903degum_
degums10438623degums
deism84116033deism_
deisms94411043deisms
dekare112811563dekare
delate73827753delate
delay94820633dela_y
delays104014053delays
delime9314043delime
demand104314253demand
demark134211023demark
demast9517063demast
deme76536283de__me
demo77427553de__mo
demy105422853de__my
denar65223293dena_r
denari710917353denari
denars74621433denars
denary105316863denary
denim85518843denim_
denims95214323denims
depart94720563depart
derail74218813derail
derat65044083dera_t
derate74531233derate
derats74625063derats
deray95024183dera_y
derays105514253derays
derm76031893de_rm_
derma84918513de_rma
dermal93614343dermal
dermas94116813dermas
derms85022893de_rms
desalt7518313desalt
desand84812633desand
descant104315583descant
desman9311693desman
detach12310413detach
detail74516433detail
detain74617383detain
deva85720983deva__
devas96218883deva_s
dewan95718043dewa_n
dewans105215143dewans
dewar95817733dewa_r
dewars105117073dewars
dewax165510853dewa_x
dewlap1264843dewlap
dicamba1453413dicamba
dicast9315573dicast
digamy1335893digamy
diram84419473diram_
dirams94413703dirams
dram75832003d_ram_
drama85117413d_rama
drams86025833d_rams
dream85120393dream_
dreams94513983dreams
dreamt94615713dreamt
dreamy12509993dreamy
ducal84816423duca_l
ducat86225903duca_t
ducats95011763ducats
dump95927093d__ump
dunam8313733dunam_
dunams937833dunams
dynamo1274163dynamo
encamps1335423encamps
escarp10449003escarp
exam132514623_exam_
exams14199083_exams
fecal105119213feca_l
gamp98833213__gamp
gelcap1136213gelca_p
gramp106218323_gramp
heap96432893he_a_p
hemp115725623he__mp
icecap1245223iceca_p
jicama1734883jicama
kemp126418763ke__mp
lamp86233823__lamp
leap66032683le_a_p
metump1235713metump
neap66927013ne_a_p
oilcamp1343053oilcamp
pecan91919033peca_n
pecans101515833pecans
preamp1238993preamp
ramp85934003__ramp
ream65841613re_am_
reams75729623re_ams
reap65934743re_a_p
recall83815723recall
recane83022873recane
recant83228683recant
recaps103615733recaps
recast83422773recast
reclame11411063reclame
reclasp1136643reclasp
recomb1238873recomb
recoup10810373recoup
redcap1158493redca_p
remap95418103rema_p
rename82718813rename
repump1235683repump
restamp1146483restamp
revamps1433993revamps
samp85733593__samp
scalp95217983_scalp
scam85932353_scam_
scampi12469103_scampi
scamps125014173_scamps
scams94423973_scams
scarp95724103_scarp
scaup95515993_scaup
seam66645973se_am_
seams75731663se_ams
seamy105921273se_amy
secant84023293secant
sesame8311013sesame
stamp95217363_stamp
swamp125015323_swamp
tamp86133003__tamp
teacup1036253teacup
team66238653te_am_
teams75726513te_ams
temp85323333te__mp
toecap1037323toeca_p
tramp96319773_tramp
uncap9312283unca_p
unclamp1344993unclamp
vamp115521543__vamp
webcam1545543webcam_
webcams1643073webcams

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 Filter1786911127160.373479064.3
2DLD Change Limit1127162805.56320261.7
3Display Results2802800.0933010.8
 (SQL Overall)1786912806.02929638.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.