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

418 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
cannot8361677(None) 
cannon84514441cannon
annoy869712_annoy
bannet84925332bannet
cahoot11416472cahoot
candor94516422candor
canna75919332cann_a
cannas84518402cannas
canned95022062canned
cannel84216402cannel
canner84625982canner
cannie83819362cannie
cannoli937262cannoli
cannons94412882cannons
canny105817692cann_y
canoe75627252ca_noe
canon74725302ca_non
canons85522062canons
canso75019402canso_
cansos84915382cansos
canst74932212ca_nst
cant66362032ca_n_t
canto74931012canto_
canton85722992canton
cantor85621522cantor
cantos84826972cantos
canyon114512032canyon
carnet84732872carnet
carrot8423122carrot
connote9311612connote
crannog1044242crannog
gannet74321852gannet
sannop837372sannop
tannoy958352tannoy
abbot9318453_abbot
afoot8420113_afoot
allot54933873_allot
ancon75718233_ancon
anenst63514983_anenst
anent54931843_anent
angst6415493_angst
anion55028813_anion
anna45529013_ann_a
annal56520763_annal
annas55824883_annas
annex12310883_annex
annona648873_annona
annoys967523_annoys
annul55813383_annul
anoa45634473_a_noa
anon46134853_a_non
ant37270793_a_n_t
anyon85615223_anyon
argot67728653_argot
ascot76522513_ascot
aunt46553653_aun_t
ballot84624093ballot
banco94019393banco_
bancos104713893bancos
bandit93821133bandit
bandog1038723bandog
banjo143812443banjo_
banjos15378893banjos
bankit123617043bankit
banknote1444833banknote
banned94721343banned
banner84421503banner
bannets94013843bannets
bannock1545043bannock
banns75321233bann_s
beknot1239763beknot
bennet84823363bennet
bonnet85524633bonnet
cabinet11318903cabinet
cablet104429463cablet
cabob114616813ca_bob
cacao95420003cacao_
cacaos104616183cacaos
cachet134526413cachet
cachou13310623cachou
cadent94120363cadent
cadet85339343ca_det
cahoots1238473cahoots
cahow135110943ca_how
cain65643913cain__
cains75334303cain_s
cajon144513903ca_jon
callet84536763callet
callow114714663callow
calo64936443ca_lo_
calos74431903ca_los
cameo95924993cameo_
cameos105818003cameos
camion103917193camion
camlet104426583camlet
camo85731753ca_mo_
camos95927613ca_mos
campo115219763campo_
campos125217953campos
campout13412853campout
can57760143ca_n__
canal75428043ca_nal
canals84421663canals
canape10913513canape
canard9314763canard
canary11314693canary
canasta938363canasta
cancan10314103cancan
cancel105316683cancel
cancer104220923cancer
cancha134411613cancha
candent10417363candent
candid104517853candid
candle94321483candle
candors104216763candors
candour104210243candour
candy115119823ca_ndy
cane66653123ca_n_e
caned85838093ca_ned
caner75334773ca_ner
caners84629203caners
canes75350373ca_nes
canful11610263canful
cangue91012443cangue
canid85526343ca_nid
canids95118133canids
canine83826703canine
canines93724033canines
caning94128623caning
caninity1338063caninity
canker124422523canker
cannelon1045123cannelon
cannels93413363cannels
canners93822663canners
cannery123610013cannery
cannier94014163cannier
canniest10313363canniest
cannily1239263cannily
canning103620133canning
cannolis1037863cannolis
cannoned11118143cannoned
cannonry1343293cannonry
cannula937433cannula
canoed94618963canoed
canoer85121073canoer
canoes84725883canoes
canola8313623canola
canonic11312933canonic
canonist10513533canonist
canonry1235923canonry
canopy1337723canopy
cans65050853ca_n_s
cantal84122033cantal
cantata93811813cantata
cantdog1134573cantdog
canted94825783canted
canter85230113canter
canthi11310973canthi
cantic103920543cantic
cantle84522153cantle
cantons95221203cantons
cantors94620753cantors
cants77036943ca_nts
cantus85117763cantus
canty105226803ca_nty
canula8312963canula
canvas113813333canvas
canyons124511593canyons
canzona1836073canzona
canzone1858813canzone
canzonet19410583canzonet
canzoni1836153canzoni
caplet104226813caplet
capo85829213ca_po_
capon95221873ca_pon
capons104119503capons
capos94826073ca_pos
capote10315733ca_pote
captor104914603captor
caput9823983ca_put
carat75048793ca_rat
carbo94923843carbo_
carbon104919043carbon
carbos105122263carbos
carboy134914183carboy
cardon94120853cardon
caret75360563ca_ret
cargo85322073cargo_
cargos94619183cargos
carhop133610763carhop
carn66245433carn__
carnal83919203carnal
carnets93918403carnets
carney115315703carney
carnie84421093carnie
carns75937563carn_s
carny105822923carn_y
carob95325223ca_rob
carol75128613ca_rol
carom95025563ca_rom
carpet104530093carpet
carport11316033carport
carrom10513403carrom
carrots9714623carrots
carroty1248943carroty
cart66570343ca__rt
carton84522663carton
cartop104213563cartop
cashoo11312253cashoo
casino84317553casino_
casinos93512833casinos
casket124820993casket
cast67159903ca__st
castor84418533castor
cat58282343ca___t
catboat11412243catboat
catgut9310803catgut
cation83925503cation
catnap1098383catnap
catnip1097973catnip
caught124911683caught
caveat11417723caveat
cavort11316173cavort
cenote83715843c_enote
censor84011293censor
cent67451013c_en_t
cento76625173cento_
centos85920463centos
challot123613263challot
chalot113020133chalot
channel123910483channel
chanson1238043chanson
chant105932693chan_t
chantor123710313chantor
chariot12316213chariot
chaunt11613493chaun_t
chino105823313chino_
chinos115018693chinos
cineol8108203cineol
clangor10426683clangor
cloot76127053c_loot
clot66542423c__lot
coannex1635513coannex
cobnut10311323cobnut
concoct10312903concoct
condo85322593condo_
condom114215363condom
condor94616973condor
condos94322333condos
confit113316403confit
congo85623133congo_
congos94219883congos
congou94313243congou
conn66229133conn__
connate9315753connate
connect113515743connect
conned95119703conned
conner84423963conner
connoted1138863connoted
connotes10311453connotes
conns75024233conn_s
consol82614113consol
consort91319903consort
conto76027173conto_
contort91422343contort
contos84923233contos
convoy14348543convoy
coot67860383c__oot
coplot10518273coplot
cornet84436733cornet
cot510483223c___ot
count74932053coun_t
crannoge1144263crannoge
crannogs1143783crannogs
cranny114210273crann_y
cunner83915003cunner
cunt66243673c_un_t
cyano105512493cyano_
cygnet1237893cygnet
danio6319783danio_
danios7314603danios
daunt65929083daun_t
faggot1139053faggot
fagot9323403fa_got
faint85837063fain_t
fandom122110893fandom
fanion94514323fanion
fanjet16311393fanjet
fanned104117473fanned
fanner94218183fanner
fanny114816043fann_y
fano75831693fa_no_
fanon84619013fa_non
fanons96115213fanons
fanos85926503fa_nos
fantod102010033fantod
fantom112110803fantom
fanwort13310733fanwort
gainst74914693gainst
galiot72322593galiot
galoot72719163galoot
gannets83811443gannets
ganof95420363ga_nof
garnet73928413garnet
gaunt65430403gaun_t
gavot9321123ga_vot
haint85436323hain_t
hallot95426783hallot
handout11314103handout
hangout11411393hangout
hansom11219153hansom
hant75461593ha_n_t
harlot94422803harlot
haunt85229133haun_t
ingot61221063_ingot
jabot14321513ja_bot
jaunt125025273jaun_t
jennet134714953jennet
kainit10414483kainit
knot85630503__knot
lancet84223573lancet
lanner64920603lanner
linnet6419423linnet
maggot10311713maggot
magnet9320663magnet
magot8326393ma_got
manat76039993ma_nat
mango85724323mango_
mangos94319333mangos
manihot121112053manihot
manioc103914823manioc
manito8518693manito
manna75522543mann_a
mannan85413623mannan
mannas85019803mannas
manned94418643manned
manner84020513manner
mannite9312903mannite
mannose939243mannose
mano66536813ma_no_
manor78023933ma_nor
manos74933623ma_nos
marmot10318743marmot
mascot104016073mascot
matzot17710983matzot
minnow1135583minnow
nannie63713223nannie
nanny84813813nann_y
not39474663___not
paint75443693pain_t
pandit93820753pandit
panino8315683panino_
panne76623653pann_e
panned94123433panned
panner84224763panner
pannes85522853pannes
pant66061263pa_n_t
panto76129413panto_
pantos85222743pantos
parrot8320663parrot
pawnor11357243pawnor
pennon8310643pennon
pinot78737293_pinot
punnet83518843punnet
qanat144426843qa_nat
rainout7314393rainout
rancor8810373rancor
random92513553random
ransom82410943ransom
rant45864683ra_n_t
reknot10311733reknot
rennet64624853rennet
sabot7931783sa_bot
saint55147073sain_t
sandlot8311693sandlot
sanest64426693sanest
sannops936693sannops
sannup836563sannup
santo56227283santo_
santol64515243santol
santos64421833santos
scanned104110893scanned
scanner94411813scanner
scant79735073sca_n_t
sennet64224143sennet
sennit63117923sennit
snoot55030143_snoot
snot44745453__snot
sonnet65923503sonnet
taint55542283tain_t
tango66921173tango_
tangos74216303tangos
tanist6324593tanist
tannate71813523tannate
tanned75219953tanned
tanner63722283tanner
tannest72617853tannest
tannic82811473tannic
tannin62613923tannin
tannoys1055553tannoys
tanto55724943tanto_
tarot55943933ta_rot
taunt55532283taun_t
tinpot8312513tinpot
ungot61718063_ungot
unknot1037413unknot
vanned104614483vanned
vanner94215843vanner
vaunt85925313vaun_t
walnut939433walnut
wanion93213063wanion
wanned104318013wanned
wanner94019623wanner
wannest103915003wannest
want76156173wa_n_t
wanton94413813wanton
whatnot1344733whatnot
winnow1234593winnow

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.376475242.0
2DLD Change Limit1127164185.00022543.2
3Display Results4184180.1402985.7
 (SQL Overall)1786914185.51632395.0
 
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.