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

228 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
decamps143564(None) 
decamp1338451decamp_
becaps123811402beca_ps
camps116330262__camps
damps105220412d__amps
decades113615512decades
decafs124010882deca_fs
decals93717712deca_ls
decamped1634962decamped
decanes103118912decanes
decants103514442decants
decares102818532decares
decays124612912deca_ys
defames132812252defames
degames113312622degames
degamis11268442degamis
encamps1335422encamps
recaps103615732reca_ps
revamps1433992revamps
scamps125014172_scamps
abamps1236253_abamps
amps86230343___amps
beams95328173be_am_s
becalms1335743becalms
became123213163becam_e
becap114315053beca_p_
beclasps1444353beclasps
becomes132911963becomes
bedamns1235733bedamns
bedlamps1543663bedlamps
benames112814603benames
camas96333523__camas
cames97047313__cames
camos95927613__camos
camp106336453__camp_
campi116217783__campi
campo115219763__campo
campos125217953__campos
campus125213923__campus
campy145116183__campy
cams87047283__cam_s
caps87147893__ca_ps
carps96932253__carps
champs154915683_champs
clamps124515083_clamps
comps115526053__comps
cramps125615563_cramps
dames85435853d__ames
damns84916923d__amns
damp96228843d__amp_
dams77444373d__am_s
daps77239163d__a_ps
deacons10310393deacons
deads75726913de_a_ds
deairs74013783de_airs
deals65435343de_a_ls
deans66131393de_a_ns
dears65736883de_a_rs
deaths105914443de_aths
deaves105319533de_aves
debags104211063deba_gs
debarks14388493debarks
debars94218043deba_rs
debases103814133debases
debates103718533debates
decadal1137243decadal
decade104216163deca_de
decaf114919443deca__f
decagon1135863decagon
decagons1235893decagons
decal85523233deca__l
decalog1136003decalog
decalogs1245633decalogs
decamping1734943decamping
decanal1038113decanal
decane93818873deca_ne
decant93524223deca_nt
decapod1335433decapod
decapods1444623decapods
decare93919153deca_re
decay114718483deca__y
decayed14309333decayed
decayer13339353decayer
decayers14307963decayers
deceases11410153deceases
deceits102810883deceits
decerns10119053decerns
deciares11510633deciares
decides114217653decides
deciles104417723deciles
decimal1238083decimal
decimals1345863decimals
deckels14367363deckels
deckers144413833deckers
deckles143312803deckles
decks124822193dec__ks
declaims1345823declaims
declares11611313declares
declass1038733declass
declaws1336253declaws
decocts1237833decocts
decodes113914983decodes
decompose1644543decompose
decors94017773dec_ors
decos85522123dec__os
decoys123911283dec_oys
decrees102513123decrees
decries103319803decries
decrypt1545703decrypt
decrypts1642943decrypts
decuman1236573decuman
dedans85915073deda_ns
deems85421773de_em_s
deeps84921773de__eps
defaces133213403defaces
defame123212433defam_e
defamed14309833defamed
defamer132710323defamer
defamers14258523defamers
defangs1235363defangs
defats105114553defa_ts
defoams1336193defoam_s
degame102713183degam_e
degami10279013degam_i
degas75119163dega__s
degases93413103degases
degauss933923degauss
degums10438623degum_s
deisms94411043deism_s
dekares122710873dekares
delates83526283delates
delays104014053dela_ys
delimes10314193delimes
demands114311413demands
demarks14339233demarks
demasts1089223demasts
demes86032693de__mes
demos86022993de__mos
denars74621433dena_rs
denims95214323denim_s
departs104310683departs
derails84216393derails
derates84028893derates
derats74625063dera_ts
derays105514253dera_ys
dermas94116813de_rmas
dermis94717163de_rmis
derms85022893de_rm_s
desalts839573desalts
desands94810163desands
descants112910143descants
desmans1039003desmans
details84214043details
detains83716093detains
devas96218883deva__s
dewans105215143dewa_ns
dewars105117073dewa_rs
dewaxes18297843dewaxes
dewlaps1334663dewlaps
dicamba1453413dicamba
dicambas1553793dicambas
dicasts1078703dicasts
dirams94413703diram_s
dramas95814663d_ramas
drams86025833d_ram_s
dreams94513983dream_s
ducats95011763duca_ts
dumps105220103d__umps
dunams937833dunam_s
dynamos1373853dynamos
encamp1235943encamp_
escarps11397373escarps
exams14199083_exam_s
gamps105323713__gamps
gelcaps1235203gelca_ps
gramps114114273_gramps
heaps105223223he_a_ps
hemps126917333he__mps
icecaps1343863iceca_ps
jicamas1845053jicamas
kemps135012523ke__mps
lamps95624833__lamps
leaps75522933le_a_ps
metumps1334133metumps
neaps75618323ne_a_ps
oilcamps1442163oilcamps
pecans101515833peca_ns
preamps1336613preamps
ramps96224633__ramps
reams75729623re_am_s
reaps75626193re_a_ps
recalls92613623recalls
recanes93222263recanes
recants93217093recants
recap95718023reca_p_
recasts93413533recasts
reclames12310893reclames
reclasps1235053reclasps
recombs1336753recombs
recoups1188843recoups
redcaps1247073redca_ps
remaps105012873rema_ps
renames92418053renames
repumps1334403repumps
restamps1234703restamps
revamp1336013revamp_
samps96124673__samps
scalps104315233_scalps
scamp115717313_scamp_
scampi12469103_scampi
scams94423973_scam_s
scarps104718603_scarps
scaups105411933_scaups
seams75731663se_am_s
secants93413893secants
sesames9310743sesames
stamps105614023_stamps
swamps135910263_swamps
tamps95524083__tamps
teacups1133963teacups
teams75726513te_am_s
temps95417133te__mps
toecaps1135553toeca_ps
tramps105114453_tramps
uncaps1039813unca_ps
unclamps1443693unclamps
vamps125415483__vamps
webcams1643073webcam_s

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272285.95622502.9
3Display Results2282280.0763000.0
 (SQL Overall)1786912286.42227824.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.