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

461 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
docent9291868(None) 
decent94023701decent
docents102810801docents
nocent83217411nocent
accent105116262accent
ascent84519652ascent
cent67451012__cent
cogent9321002cogent
concent114422512concent
decant93524222decant
deceit93018212deceit
dement93825142dement
dent57158412d__ent
descent102616292descent
detent73624482detent
docket134721172docket
document1348662document
doest65829522do_est
dopant9316132dopant
doven94718552doven_
dovens104413902dovens
doyen95014412doyen_
doyens104810222doyens
dozen155017472dozen_
dozens164612462dozens
dozenth2044322dozenth
eocene8311612eocene
foment113718302foment
incent83320722incent
loment84021472loment
lucent8313822lucent
moment103319682moment
ponent82821592ponent
potent84223352potent
recent83630852recent
rodent7519242rodent
scent75831622_scent
abducent13105703abducent
absent84016993absent
accents113511233accents
accept123210623accept
adducent1284713adducent
adjacent18134313adjacent
advent102613753advent
agent65829643_agent
ament76036543_ament
ancient9514733ancient
anent54931843_anent
ardent73022613ardent
argent74023663argent
arpent84822093arpent
ascend9429733ascend
ascents93812553ascents
assent65119953assent
attent62818323attent
avocet11412683avoce_t
bent67759913__bent
blent76230953_blent
bonnet85524633bonnet
brent75734133_brent
cadent94120363cadent
cant66362033__cant
celt65646713__celt
cement103321663cement
cento76625173__cento
cents74730333__cents
centu76119413__centu
cholent12313253cholent
client8316343client
coagent10313983coagent
coconut11511473coconut
coden86128543coden_
codens94821013codens
comet95946073come_t
comment1310317703comment
conceit113218073conceit
concents122516603concents
concept133314443concept
concert113325223concert
consent93723113consent
content94326153content
convent123919413convent
copen94826433copen_
copens106119963copens
cornet84436733cornet
coset75748843cose_t
count74932053co_unt
coven106925043coven_
covens114919263covens
covert114925503covert
covet105638943cove_t
coyest11316053coyest
cozen165019703cozen_
cozens176314923cozens
cunt66243673__cunt
dace76934923dace__
daces85030683dace_s
dacoit9415453dacoit
daunt65929083d_aunt
daven94916473daven_
davens104612913davens
dawen95413723dawen_
debt77139023d__ebt
decadent1249003decadent
decane93818873decane
decants103514443decants
decedent12310213decedent
deceits102810883deceits
decency1537453decency
decenter112412163decenter
decently1448013decently
decentre11248553decentre
decern91310953decern
decerns10119053decerns
decoct11313783decoct
deet57356583d__eet
defeat103817163defeat
defect124816173defect
defend113910493defend
deft85540223d__eft
deject164512843deject
delt57855273d__elt
dements103016623dements
den47554343d__en_
dene56643413d__ene
deni56929393d__eni
dens55945073d__ens
dents65031803d__ents
deny86027123d__eny
depend103510923depend
deponent11410553deponent
descant104315583descant
descend11248153descend
descents112511203descents
desert72725493desert
detect94217403detect
detente83313603detente
detents83615153detents
detest74122843detest
devest104418703devest
dicast9315573dicast
dice75841893dice__
diced95824683dice_d
dicentra1145433dicentra
dicer85426423dice_r
dicers94720743dicers
dices86434243dice_s
dicey114819333dice_y
diciest103316523diciest
dicing105718763dicing
dickens144410133dickens
dicot85429093dic_ot
diene65720133d_iene
diet57357533d_ie_t
digest84019623digest
diluent8310263diluent
dint56759053d__int
diocese1036853diocese
dipnet91317473dipnet
direct93817333direct
direst75024243direst
discant103017253discant
discept12310623discept
dissent84018683dissent
distent84120853distent
divert103922813divert
divest106820073divest
dizen155214933dizen_
dizens164911393dizens
doat56947673do__at
doc66841513doc___
docetic1239913docetic
docile94213123docile
dock116228743doc__k
docked145018333docked
docker134417653docker
dockers143715003dockers
dockets144412243dockets
docking153615013docking
docks126022313doc_ks
docs75631153doc__s
doctor938993doctor
documents1446523documents
doe47361953do_e__
doer57734703do_e_r
doers65225713do_ers
does56554473do_e_s
doeth9411983do_eth
dogcart1148043dogcart
doge66233803doge__
dogear838193dogear
doges75630163doge_s
dogey105719513doge_y
dogeys115510663dogeys
doing74923583do_ing
doit56347853do__it
dolce85816683dolce__
dolcetto1142773dolcetto
dole56550003dole__
doled75430913dole_d
doles67843753dole_s
doling84923133doling
dolmen93911373dolmen_
dolmens10388693dolmens
dolt56649423do__lt
dome77240733dome__
domed95423263dome_d
domes85735563dome_s
domine92918253domine
doming104218393doming
domino92611493domino
don46757653do__n_
dona55529633do__na
done55747913do__ne
donee66931013done_e
donees74519493donees
dong66031653do__ng
donna66215033do_nna
donne65520463do_nne
donned85015743donned
donnee74317063donnee
donnert82815533donnert
dons56048703do__ns
donut6324513do_nut
dopants1038433dopants
dope76038893dope__
doped95326713dope_d
doper86128393dope_r
dopers95522483dopers
dopes84935043dope_s
dopey116020353dope_y
dopiest103315993dopiest
doping103919463doping
dore56353303dore__
dormant102814373dormant
dormient1148453dormient
dose56442433dose__
dosed76626913dose_d
doser66228563dose_r
dosers75723633dosers
doses65938503dose_s
dosing83920273dosing
dost57248353do__st
dot47573183do___t
dote55442883dote__
doted75227073dote_d
doter65428623dote_r
doters74423913doters
dotes65836693dote_s
dotiest83717453dotiest
doting84821913doting
doubt8720093do_ubt
douce85518423douce__
doucely1344883doucely
douceur1043113douceur
dought114915513dought
dourest8312943dourest
dove85131563dove__
dovecot1356733dovecot
dovened12389063dovened
doves94728153dove_s
dowed104632613dowe_d
dowel95618193dowe_l
dowels104813343dowels
dower95027703dowe_r
dowers104523293dowers
dowery134311663dowery
dowing114221513dowing
down86427493do_wn_
downed115314783downed
downer104414923downer
downs94918573do_wns
downy125714553do_wny
doyenne1143883doyenne
doze145829083doze__
dozed165619353doze_d
dozened18377453dozened
dozenths2142793dozenths
dozer158419273doze_r
dozers164815423dozers
dozes155226303doze_s
doziest174012473doziest
dozing174214193dozing
dracena1034923dracena
drest65530343d_rest
driest74722753driest
dryest104811123dryest
ducat86225903duc_at
duce76933503duce__
duces86327473duce_s
duct75735463duc__t
duecento1143563duecento
duet56446263d_ue_t
dulcet9314493dulce_t
dunt55746873d__unt
duodena943453duodena
duvet9321873duve_t
dwelt94316523d_welt
eluent6315483eluent
erodent8313823erodent
event85924443_event
except1797653except
extent132714913extent
facet106038523face_t
fluent9313933fluent
foments122912053foments
font77143753fo__nt
forest94926743forest
forint9325023forint
fornent10312933fornent
forwent13310533forwent
fount84727033fo_unt
gent56954393__gent
gerent73223093gerent
godet7530043gode_t
hent76656383__hent
honest94822423honest
hornet94926433hornet
horrent10313553horrent
hosen85623883hosen_
incant82418503incant
incents92414533incents
incept102712753incept
incest82918743incest
indecent11411273indecent
indent73021243indent
indolent91311683indolent
innocent1048163innocent
intent63122773intent
invent93316363invent
jocund1633623jocund
joint125227723jo_int
kent86846963__kent
lament85024943lament
latent64124303latent
lent46360533__lent
licente91210893licente
locket123922473locket
locknut1345253locknut
locust85312343locust
loden66621143loden_
lodens74315063lodens
lomenta92710133lomenta
loments93413473loments
lowest93915593lowest
miocene1147923miocene
modest93818453modest
molest85022743molest
momenta11299853momenta
momento11348903momento
moments113113123moments
mordent10313993mordent
motet75641193mote_t
mount74128063mo_unt
nascent9610523nascent
nicest82315663nicest
nomen75621623nomen_
nonet54540843none_t
novena936763novena
obento837893_obento
ocean71212963_ocean
oceans81211003_oceans
ocelot8813383_ocelot
octant81216553_octant
octet7324063_octet
oddest81710863oddest
oddment1145923oddment
odorant8411393odorant
omen66828183_omen_
omens75618963_omens
omenta83411723_omenta
oncet74626543once_t
oocyst1136133oocyst
oogeny10117923oogeny
open66427003_open_
opens76118553_opens
orient6322533orient
oven76624143_oven_
ovens86217453_ovens
overt85630723_overt
oxen116218593_oxen_
parent83230423parent
patent84524923patent
pent66559073__pent
percent113520603percent
pocket144622623pocket
poet65552903po_e_t
point75338733po_int
polenta9310093polenta
portent93619643portent
precent113520263precent
pschent1437413pschent
recant83228683recant
recept103319073recept
redolent9411883redolent
regent74127673regent
relent64431853relent
rent46661243__rent
repent84728873repent
rerent63832453rerent
resent63833623resent
rident7520193rident
rochet115423003rochet
rocket125425283rocket
rodents8611543rodents
roset55945243rose_t
rouen54920903rouen_
rouens64814443rouens
roven85521973roven_
rowen84921153rowen_
rowens94515303rowens
scant79735073_scant
scena74815783_scena
scend85516293_scend
scene77220573_scene
scents85317023_scents
secant84023293secant
sent46963013__sent
shent85933503_shent
silent64125843silent
sklent103614353sklent
sobeit8315363sobeit
socket123923523socket
socmen1039193socmen_
solvent10310833solvent
sonant6621953sonant
sonnet65923503sonnet
sorbent92915243sorbent
sorest65028003sorest
sowens93613153sowens
spent75532833_spent
splent84720193splent
sprent84522383sprent
stent55634513_stent
tacet75840023tace_t
talent6323323talent
tent46159863__tent
token95419313token_
tokens104711563tokens
tomenta9319833tomenta
torment9316173torment
torrent7313413torrent
unbent83216593unbent
unkent103116053unkent
unpent83117373unpent
unrent63219783unrent
unsent63820963unsent
upsent83314063upsent
urgent73816043urgent
vacant11415133vacant
vent76049053__vent
violent102110813violent
voces105918053voce_s
volant9316323volant
went76051873__went
wisent93516343wisent
woken124614973woken_
women104619253women_
wont75842503wo__nt
woven115215173woven_
wovens12449833wovens

Search took 6 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.1401276364.3
2DLD Change Limit1127164615.48620546.1
3Display Results4614610.1562955.1
 (SQL Overall)1786914615.78230904.7
 
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.