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

449 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
decants10351444(None) 
decanes103118911decanes
decant93524221decant_
descants112910141descants
recants93217091recants
secants93413891secants
bezants1877342bezants
cants77036942__cants
deans66131392de_an_s
decadents1346392decadents
decades113615512decades
decafs124010882deca_fs
decals93717712deca_ls
decamps1435642decamps
decanal1038112decanal
decane93818872decan_e
decanted122310492decanted
decanter112510792decanter
decanters12229222decanters
decares102818532decares
decays124612912deca_ys
deceits102810882deceits
decent94023702decent_
decocts1237832decocts
dedans85915072dedan_s
defangs1235362defangs
defats105114552defa_ts
demands114311412demands
demasts1089222demasts
dements103016622dements
dents65031802de__nts
depaints1136642depaints
departs104310682departs
derats74625062dera_ts
desalts839572desalts
desands94810162desands
descant104315592descant_
descents112511202descents
detents83615152detents
deviants1236742deviants
dewans105215142dewan_s
dicasts1078702dicasts
discants112912022discants
docents102810802docents
dopants1038432dopants
ducats95011762duca_ts
gelants82611442gelants
incants92012802incants
levants1037722levants
pecans101515832pecan_s
pedants10310112pedants
recanes93222262recanes
recant83228682recant_
recasts93413532recasts
scants85219722_scants
secant84023292secant_
tenants7311012tenants
accents113511243accents
adamants1186343adamants
alants67722023_alants
ants47243473___ants
ascents93812553ascents
beanos85516523be_anos
beans75734693be_an_s
beasts84519723be_asts
beats76042253be_a_ts
beauts86015283be_auts
becalms1335743becalms
becaps123811403beca_ps
beckets15399823beckets
bents76033693be__nts
bepaints1235113bepaints
bezant17814543bezant_
bezzants1843643bezzants
brants85723053_brants
byzants2153223byzants
canes75350373__canes
cans65050853__can_s
canst74932213__canst
cant66362033__cant_
canto74931013__canto
cantos84826973__cantos
cantus85117763__cantus
canty105226803__canty
carts78946293__carts
casts77237793__casts
cats66356343__ca_ts
cements112714223cements
cents74730333__cents
cetanes9315133cetanes
chants115020393_chants
cosecants1346533cosecants
cunts76125123__cunts
dacoits1079073dacoits
damans94715983daman_s
dangs75623213d__angs
dans56748153d__an_s
darts67635733d__arts
daunts75014083d_aunts
dauts67822243d__auts
dawts97216123d__awts
deacons10310393deacons
deads75726913de_a_ds
deairs74013783de_airs
deals65435343de_a_ls
dealt65234283de_alt_
dean56039483de_an__
deaned84620453de_aned
dears65736883de_a_rs
dearth104212513de_arth
dearths11498843de_arths
death94822523de_a_th
deaths105914443de_aths
deaves105319533de_aves
debags104211063deba_gs
debarks14388493debarks
debars94218043deba_rs
debases103814133debases
debate94419193deba_te
debates103718533debates
debits94214503de_bits
debones103315113debones
debts86418373de__bts
debunks1433763debunks
debutants1243713debutants
debuts93911753de_buts
decadal1137243decadal
decade104216163deca_de
decadent1249003decadent_
decaf114919443deca__f
decagon1135863decagon
decagons1235893decagons
decal85523233deca__l
decalog1136003decalog
decalogs1245633decalogs
decamp1338453deca_mp
decanting132510633decanting
decapod1335433decapod
decapods1444623decapods
decare93919153deca_re
decay114718483deca__y
decayed14309333decayed
decayer13339353decayer
decayers14307963decayers
deceases11410153deceases
decedents1347323decedents
deceit93018213deceit_
decency1537453decency
decenter112412163decenter
decenters122410373decenters
decentest1249083decentest
decently1448013decently
decentre11248553decentre
decentres12238523decentres
decerns10119053decerns
deciares11510633deciares
decides114217653decides
deciles104417723deciles
deckels14367363deckels
deckers144413833deckers
deckhands2043083deckhands
deckings16346683deckings
deckles143312803deckles
decks124822193dec__ks
declaims1345823declaims
declarants1343603declarants
declares11611323declares
declass1038733declass
declaws1336253declaws
declines113315803declines
decoct11313783decoct_
decodes113914983decodes
decors94017773dec_ors
decos85522123dec__os
decoys123911283dec_oys
decrees102513123decrees
decries103319813decries
decrypts1642943decrypts
deducts1166593deducts
deets65330243de__ets
deewans11306903deewan_s
defaces133213403defaces
defames132812253defames
defang1137753defan_g
defat95426693defa_t_
defaults1243333defaults
defeats113511233defeats
defects134511523defects
defends12358773defends
defiant11311923defiant_
defines114118683defines
defunds12376753defunds
degames113312623degames
degamis11268443degamis
degas75119163dega__s
degases93413103degases
degauss933923degauss
degusts936063degusts
dehorts11379773dehorts
deigns8389983deign_s
deists74916433de_ists
dejects17389223dejects
dekares122710873dekares
delaines9312963delaines
delate73827753dela_te
delates83526283delates
delays104014053dela_ys
delfts10439673de_lfts
delicts104012253delicts
delists84414173delists
delts65731793de__lts
demand104314253deman_d
demarks14339233demarks
demast9517063demast_
demeans1039723demean_s
dement93825153dement_
demits94918073de_mits
demons94917723demon_s
demounts1135473demounts
denars74621433dena_rs
denes65639723de__nes
dens55945073de__n_s
dent57158413de__nt_
deodands1144603deodands
depaint10314593depaint_
depart94720563depart_
depends11348993depends
depicts12358463depicts
deplanes11311213deplanes
depones103717093depones
deports105012883deports
depots94716343de_pots
derails84216393derails
derange939813derange
deranges1039973deranges
derat65044083dera_t_
derate74531233dera_te
derates84028893derates
derays105514253dera_ys
desalt7518313desalt_
desand84812633desan_d
descanted1336673descanted
descanter1246443descanter
descanters1345013descanters
descends12266983descends
descent102616293descent_
deserts82513053deserts
desiccants1542663desiccants
desists83611723desists
desmans1039003desman_s
despots10319683despots
details84214043details
detains83716093detains
detects104011093detects
detent73624483detent_
detente83313603detente
detentes92712873detentes
detests83711743detests
detracts11138833detracts
devas96218883deva__s
devests114410473devests
deviant11311313deviant_
devons104512253devon_s
dewan95718043dewan__
dewars105117073dewa_rs
dewaxes18297843dewaxes
dezincs1933753dezincs
dicast9315573dicast_
dicots94915793dic_ots
didacts1186063didacts
dints67431313d__ints
discant103017263discant_
divans104612393divan_s
diwans105110373diwan_s
doats65224883d_oa_ts
docent92918683docent_
dockets144412243dockets
dogcarts1243883dogcarts
dopant9316133dopant_
drafts105012533d_rafts
drats66628373d_ra_ts
ducat86225903duca_t_
ducts85319893duc__ts
duecento1143563duecento
duecentos1243153duecentos
dunts65828413d__unts
dynasts1155103dynasts
easts57530323_e_asts
eats47054873_e_a_ts
ecarte84313503_ecarte
ecartes94212563_ecartes
eclats8313033_eclats
elands74914773_elands
elans55527753_elan_s
elints65816423_elints
eluants737583eluants
enacts84012973_enacts
enchants1347833enchants
epacts105010393_epacts
errants7410643errants
etchants1346023etchants
events94814073_events
exacts15359613_exacts
exalts13328313_exalts
exsecants1893403exsecants
feasts95116093fe_asts
feats86432753fe_a_ts
feints94813873fe_ints
gelant72821673gelant_
gellants9308283gellants
gents65729613ge__nts
gerents82612923gerents
giants74713503_giants
grants73722473_grants
hants86335403__hants
hearts96218943he_arts
heats85838403he_a_ts
hents87330743he__nts
hepcats1436473hepca_ts
hexanes17319463hexanes
incant82418513incant_
incents92414533incents
indicants1247203indicants
infants102210773infants
jacanas1638263jacanas
jeans126022113je_an_s
jurants14379213jurants
leans55536253le_an_s
leant56737783le_ant_
leasts64616413le_asts
lemans85316393leman_s
levant9314493levant_
means75831233me_an_s
meant76537213me_ant_
meats75034053me_a_ts
mediants11299493mediants
medicants1466783medicants
merchants1646223merchants
mutants938583mutants
neats55931903ne_a_ts
oceans81211003ocean_s
octants9128733octants
odorants946043odorants
operants1039483operants
oxcarts1634313oxcarts
pants76536923__pants
peans75437643pe_an_s
peanuts936993pe_anuts
peasants1038263peasants
peats76140193pe_a_ts
pecan91919033pecan__
peccant13311733peccant_
pechans14810503pechan_s
pedant9319493pedant_
pekans121710553pekan_s
penangs10268373penangs
penchants1646203penchants
pendants1139093pendants
pennants1037063pennants
percents122713373percents
picante11310523picante
plants84921803_plants
precasts1239453precasts
precents123015043precents
quants153614143_quants
rants55935343__rants
reactants1146623reactants
reacts83616603re_acts
rebaits9312583rebaits
recalls92613623recalls
recane83022873recan_e
recaned102817203recaned
recanted112513513recanted
recanter101913153recanter
recanters112310483recanters
recaps103615733reca_ps
recast83422773recast_
recent83630853recent_
recepts113010273recepts
recharts1337663recharts
recits83621363rec_its
recoats92616653recoats
recons84922993recon_s
recounts1038773recounts
recreants1146623recreants
recusants1145103recusants
recuts83817373rec_uts
redacts10510943redacts
redans75421023redan_s
regents83416543regents
regrants9310013regrants
rehangs1137563rehangs
relands85214883relands
relents74018503relents
remands104914883remands
remans84823003reman_s
remints95117303remints
remnants1036843remnants
rents55935183re__nts
repaints1038483repaints
repasts93611933repasts
repents93717623repents
replants102811243replants
rerents73319423rerents
resents74221223resents
retints74717023retints
savants1038653savants
scans74625103_scan_s
scant79735073_scant_
scanty114014663_scanty
scarts85321493_scarts
scats75930603_sca_ts
scatts85914663_scatts
scents85317023_scents
sealants82610743sealants
seats54844343se_a_ts
seawants11337973seawants
secantly1345983secantly
seconds1038283seconds
secrets9311773secrets
sects75622893sec__ts
sedans74816093sedan_s
sejant133114483sejant_
servants1138003servants
sewans95215903sewan_s
sextants15287383sextants
slants64819083_slants
sonants7511233sonants
teacarts10116073teacarts
teats55636813te_a_ts
technos1236183technos
tenant6322473tenant_
tents56434213te__nts
tetanus737933tetanus
truants738163truants
tyrants1037453tyrants
upcasts11185643upcasts
vacant11415133vacant_
vegans103910853vegan_s
vents86125933ve__nts
versants1137783versants
vesicants1444753vesicants
wants87932213__wants
weans85326743we_an_s
webcasts1543313webcasts
wechts1446253wec_hts
yeans86624883ye_an_s
yeasts96413053ye_asts
zenanas16286233zenanas

Search took 9 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.406440125.6
2DLD Change Limit1340274497.58017681.7
3Display Results4494490.1532934.6
 (SQL Overall)1786914498.13921954.9
 
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.