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

282 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
decoct1131378(None) 
decocts1237831decocts
dacoit9415452dacoit
decant93524222decant
deceit93018212deceit
decent94023702decent
deco76125972deco__
decocted1437692decocted
decode104414742decode
decor84717572deco_r
decors94017772decors
decos85522122deco_s
decoy115716312deco_y
decoys123911282decoys
deduct10610792deduct
defect124816172defect
dehort104618102dehort
deject164512842deject
delict94320332delict
depict113514792depict
deport94922392deport
depot85727922depo_t
detect94217402detect
devout10712992devout
dicot85429092dico_t
recoat84024272recoat
recock145112722recock
accost101112263accost
acock132110213_acock
ascot76522513asco_t
becket144619883becket
become123312593become
begot84625953bego_t
bemock1636173bemock
besot76429713beso_t
coact96130583__coact
coat67558353__coat
coca88030643__coca
cock126332903__cock
coco87330603__coco
coft97939683__coft
colt67158243__colt
concoct10312903concoct
coot67860383__coot
cost68057943__cost
cot510483223__co_t
dacoits1079073dacoits
dacoity1366183dacoity
dakoit11310353dakoit
deacon9510423deaco_n
deacons10310393deacons
dealt65234283de_alt
debit85727853de_bit
debone93714783debone
debouch15124253debouch
debt77139023de__bt
debut86024143de_but
decade104216163decade
decaf114919443dec_af
decafs124010883decafs
decal85523233dec_al
decals93717713decals
decamp1338453decamp
decane93818873decane
decants103514443decants
decare93919153decare
decay114718483dec_ay
decays124612913decays
deceits102810883deceits
decency1537453decency
decern91310953decern
decide104116873decide
decile94619213decile
deck115827753de__ck
decked145217623decked
deckel134911043deckel
decker135215993decker
deckle1312012453deckle
decks124822193dec_ks
declaw1266703declaw
decocting1538123decocting
decoction1447523decoction
decoctive1745863decoctive
decoded123212393decoded
decoder113712293decoder
decodes113914983decodes
decolor1087033decolor
decorate11315193decorate
decorum1246943decorum
decoyed14358343decoyed
decoyer13348683decoyer
decree93117783decree
decrown13206053decrown
decry115514353dec_ry
decrypt1545703decrypt
decury1277963decury
deduce1079253deduce
deducts1166593deducts
deet57356583de__et
deface123113863deface
defat95426693de_fat
defeat103817163defeat
defects134511523defects
deficit1339683deficit
deflect13399973deflect
defoam1238563defoam
defocus1335283defocus
defog1048523defo_g
defogs1156683defogs
deforce13267243deforce
deform1259633deform
defrock1744643defrock
defrost1139553defrost
deft85540223de__ft
defunct1345773defunct
degust8310253degust
dehorn10439653dehorn
dehorts11379773dehorts
deice84320033de_ice
deist64633593de_ist
dejecta17376363dejecta
dejects17389223dejects
delft95623323de_lft
delicts104012253delicts
delist74625053delist
delt57855273de__lt
demast9517063demast
dement93825153dement
demic105119193demic_
demit84832303de_mit
demo77427553demo__
demob104913503demo_b
demobs11429483demobs
democrat1347953democrat
demode104013463demode
demoed103713443demoed
demon86520313demo_n
demons94917723demons
demos86022993demo_s
demote94817803demote
demount1049743demount
denote74118043denote
dent57158413de__nt
deoxy1648883de_oxy
depart94720563depart
depicts12358463depicts
depone93616553depone
deports105012883deports
depose94215763depose
deposit10313003deposit
depots94716343depots
derat65044083de_rat
desalt7518313desalt
descant104315593descant
descent102616293descent
desert72725493desert
desist74818813desist
desorb95210203desorb
desoxy1744623desoxy
despot93413293despot
detach12310413detach
detects104011093detects
detent73624483detent
detest74122843detest
detick1339383detick
detour778193detour
detox13310953deto_x
detract101414633detract
deuce84517493de_uce
devest104418703devest
device124512163device
devoice13347343devoice
devoid1189363devoid
devoir1076033devoir
devon95113683devo_n
devons104512253devons
devote104513783devote
devour1076703devour
dewool1047403dewool
deworm1249533deworm
dicast9315573dicast
dicots94915793dicots
didact10711203didact
dimout9414243dimout
direct93817333direct
divot95723073divo_t
doat56947673d__oat
doc66841513d__oc_
docent92918683docent
dock116228743d__ock
docket134721173docket
docs75631153d__ocs
doit56347853d__oit
dolt56649423d__olt
dost57248353d__ost
dot47573183d__o_t
dovecot1356733doveco_t
droit65127123d_roit
dropt86924433d_ropt
ducat86225903duc_at
duct75735463d__uct
dugout8310363dugout
duroc84513143duroc_
durocs9569703durocs
echt95722903_ec_ht
eclat7523603_eclat
edict84722283_edict
educt85017103_educt
eject145016043_eject
elect74327033_elect
enact73525363_enact
epact94921533_epact
epoch1248203_epoch
erect74129333_erect
eruct74022353_eruct
escort84616483escort
escot75320083esco_t
evict104417143_evict
exact143516933_exact
gemot84024233gemo_t
helot85332683helo_t
mecca1139933mec_ca
peacoat11412913peacoat
peacock1745143peacock
petcock1744603petcock
picot95031013pico_t
react74634333re_act
reboot84119333reboot
recant83228683recant
recast83422773recast
recce9514563rec_ce
recent83630853recent
recept103319083recept
recit75235103rec_it
recoal84117983recoal
recoats92616653recoats
recocks154711463recocks
recode93618713recode
recoil84016723recoil
recoin84320293recoin
recomb1238873recomb
recon75624243reco_n
recons84922993recons
recook125513923recook
recopy1339043recopy
record96117433record
recork126315493recork
recount9315173recount
recoup10810373recoup
recut74729243rec_ut
redact9419043redact
redcoat10410883redcoat
redock134311543redock
redout71820253redout
refect114319333refect
reject154116283reject
relict83623903relict
relock124713523relock
reluct83916113reluct
report85326023report
repot75132623repo_t
resect84424703resect
resort65728623resort
retort66831153retort
revolt9316223revolt
rococo1036813rococo
scoot75729153_scoot
scot66242613_sco_t
scout75031453_scout
seacock1545573seacock
secant84023293secant
secco9312423sec_co
seccos1039923seccos
second9411153second
secret8325063secret
sect67443623se__ct
select82621173select
setout64719473setout
uncock1438563uncock
veloce11310133veloce
wecht13415443wec_ht
yecch15558093yec_ch

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 Limit1127162826.12618399.6
3Display Results2822820.0933032.3
 (SQL Overall)1786912826.59227107.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.