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

414 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
canyons12451159(None) 
anyons94513501_anyons
cannons94412881cannons
canons85522061can_ons
cantons95221201cantons
canyon114512031canyon_
anions64123032_anions
anyon85615222_anyon_
anyone94612732_anyone
banyans1237912banyans
baryons121010472baryons
camions113916132camions
cancans11311872cancans
candors104216762candors
cannon84514442cannon_
canoes84725882can_oes
canon74725302can_on_
cansos84915382canso_s
canton85722992canton_
cantors94620752cantors
cantos84826972canto_s
canzona1836072canzona
canzonas1935382canzonas
canzone1858812canzone
canzones1939152canzones
canzoni1836152canzoni
capons104119502ca_pons
carbons115418942carbons
cardons104519942cardons
carryons1337102carryons
cartons94122472cartons
cations94524142cations
chansons1337472chansons
crayons12439232crayons
fanions103713072fanions
fanons96115212fan_ons
pinyons12299002pinyons
rayons94113342ra_yons
ronyons10258432ronyons
wanions104011372wanions
wantons103713012wantons
abandons1145353abandons
actions94218513actions
aeons57624653_a_eons
agons66423783_a_gons
amnions93710913amnions
ancon75718233_ancon_
ancone83916953_ancone
ancones93116343_ancones
anion55028813_anion_
annona648873_annona
annonas738793_annonas
annoys967523_annoys
anoas57226493_an_oas
anon46134853_an_on_
aprons8316993_aprons
argons75018203_argons
arsons63917213_arsons
avions94114393_avions
axions134713483_axions
axons125517933_a_xons
ayins85321613_a_yins
azlons154110423_azlons
azons146518253_a_zons
baboons113211083baboons
bacons104917583ba_cons
ballons93916963ballons
bancos104713893banco_s
bandogs1138363bandogs
banians9312033banians
banjoes16317313banjoes
banjos15378893banjo_s
banns75321233ban__ns
banyan1139483banyan_
barons85025383ba_rons
baryon111211613baryon_
barytons1345573barytons
basions94213953basions
batons85519423ba_tons
bayous11411153ba_yous
bonbons1139333bonbons
bunions92210473bunions
cabezons2144553cabezons
cabins104418923ca_bins
cabobs124311893ca_bobs
cacaos104616183cacao_s
cachous14312583cachous
caftans12179443caftans
cahoots1238473cahoots
cahows14399123ca_hows
caimans113811783caimans
cains75334303ca__ins
cairns85313303ca_irns
caissons1036283caissons
cajon144513903ca_jon_
cajones163311333ca_jones
caldrons1138063caldrons
calkins133814873calkins
callans94518473callans
callous93516603callous
calos74431903ca_lo_s
calyces14428803calyces
calyxes19426233calyxes
calzone1848623calzone
calzones1948763calzones
cameos105818003cameo_s
camion103917193camion_
camos95927613ca_mo_s
campions143511293campions
campong14318123campong
campongs15356123campongs
campos125217953campo_s
canakins142010463canakins
canals84421673can_als
canapes111213083canapes
canards10311203canards
cancan10314103cancan_
cancels114113313cancels
cancers114018583cancers
canchas143212403canchas
candent10417363candent
candids113812693candids
candies104125613candies
candles104422343candles
candor94516423cando_r
candour104210243candour
candours11408643candours
candying15188993candying
caners84629203can_ers
canes75350373can__es
canfuls1248423canfuls
cangues10611823cangues
canids95118133can_ids
canikins14219163canikins
canine83826703can_ine
canines93724033canines
caning94128633can_ing
cankers134418753cankers
canna75919333can__na
cannas84518403can_nas
cannelons1145213cannelons
cannels93413363cannels
canners93822663canners
canning103620143canning
cannings113710343cannings
cannoli937263cannoli
cannolis1037863cannolis
cannoned11118143cannoned
cannonry1343293cannonry
cannot83616773canno_t
canny105817693can__ny
canoe75627253can_o_e
canoed94618963can_oed
canoer85121073can_oer
canoers94318373canoers
canola8313623can_ola
canolas9313993canolas
canoness1039393can_oness
canonic11312933can_onic
canonise10511093can_onise
canonist10513533can_onist
canonry1235923can_onry
canopy1337733can_opy
canorous10310193canorous
cans65050853ca___ns
canso75019403canso__
cantals93919573cantals
cantdogs1244043cantdogs
canteens1038573canteens
canters94827733canters
canthus1248713canthus
cantina93417253cantina
cantinas102713783cantinas
canting104725903canting
cantles94721413cantles
canto74931013canto__
cantonal1038903cantonal
cantoned111411523cantoned
cantor85621523canto_r
cants77036943can__ts
cantus85117763can_tus
canulas9312863canulas
canvas113813333can_vas
canvass12376873canvass
canyoneer1443413canyoneer
canyoneers1542943canyoneers
canyoning1536873canyoning
canyonings1642873canyonings
canzonet19410583canzonet
canzonets2044483canzonets
caplins113515993caplins
capon95221873ca_pon_
capos94826073ca_po_s
captans111612053captans
captions123813223captions
captors113914983captors
carbon104919043carbon_
carbos105122263carbo_s
carboys144711783carboys
cardon94120853cardon_
cardoons113411943cardoons
careens94514703careens
cargoes104415223cargoes
cargos94619183cargo_s
carhops14329703carhops
carious93320283carious
carlins93921933carlins
carns75937563ca__rns
carobs104818103ca_robs
carols85124983ca_rols
caroms105619573ca_roms
carrions10312453carrions
carroms11512403carroms
carrots9714623carrots
carryon1237033carryon_
carton84522663carton_
cartoons104012803cartoons
caryotins14248043caryotins
caseins93115053caseins
caseous9312513caseous
caserns94711223caserns
cashoos12310793cashoos
casinos93512833casinos
castors94919443castors
cation83925503cation_
catkins133012563catkins
catlins93818843catlins
cautions103313183cautions
caverns124510253caverns
caymans14349513caymans
cays95437673ca_y__s
censors93611843censors
centones10313663centones
centos85920463cento_s
chanfrons1744623chanfrons
chanoyus1643923chanoyus
chanson1238043chanson_
chantors133710263chantors
chitons122611913chitons
cineols9128853cineols
cions75222853c__ions
citrons92913223citrons
clangors11417003clangors
clarions10310493clarions
classons1037703classons
claxons1635803claxons
clons75228133c__lons
cocoons11310563cocoons
codons96119463c_odons
cogons96818113c_ogons
colons86028683c_olons
commons13311043commons
condoes104319203condoes
condoms124214083condoms
condone102616293condone
condones112817393condones
condors104018573condors
condos94322333condo_s
congoes103617303congoes
congos94219883congo_s
congous103615083congous
conins84327243con_ins
conjoins1738133conjoins
conns75024233con__ns
cons66057693c___ons
consols92914073consols
contos84923233conto_s
convoys15267023convoys
coons76737283c__oons
cordons104415763cordons
cottons9312193cottons
coupons112710563coupons
crampons1436643crampons
crankous1435973crankous
crannogs1143783crannogs
cratons94316033cratons
crayon114110003crayon_
crepons1139323crepons
croons85418423c_roons
crotons93714373crotons
cyanins122910013cyan_ins
cyans105714813c__yans
cytons111710183c_ytons
dacrons103211033dacrons
daemons10269233daemons
dahoons1137753dahoons
daikons12186693daikons
daimons10249323daimons
daltons8310403daltons
damsons1038013damsons
danios7314603danio_s
donjons1536733donjons
falcons1239123falcons
fandoms13229473fandoms
fanion94514323fanion_
fanon84619013fan_on_
fanos85926503fan_o_s
fantods11177623fantods
fantoms12189153fantoms
gabions102410053gabions
gaboons10289903gaboons
gallons83015953gallons
gammons1237973gammons
ganofs104010293gan_ofs
garcons102411643garcons
garrons82713463garrons
gascons10289103gascons
hadrons113314303hadrons
hagdons1258523hagdons
halcyons1644023halcyons
halons95720713ha_lons
hansoms12238523hansoms
inions64417003_inions
jargons1558203jargons
kanbans1337723kanbans
kaons95014853ka__ons
kations114013663kations
kayoes134710823ka_yoes
kayos127714703ka_yo_s
ladrons83813193ladrons
lagoons839253lagoons
lardons83914493lardons
layins93817653la_yins
macons104017243ma_cons
macrons113514893macrons
mammons1048513mammons
mangoes104316133mangoes
mangos94319343mango_s
maniocs113611443maniocs
mannans93611523mannans
manors84420883man_ors
manos74933623man_o_s
mansions1069793mansions
maroons92615553maroons
marrons93216973marrons
mascons113411583mascons
masons83916513ma_sons
matrons93517633matrons
mayors115714193ma_yors
mayos105521933ma_yo_s
minions93314623minions
minyans1237263minyans
nandins8312003nandins
nankins1159053nankins
nasions73112383nasions
nations74720563nations
natrons73215663natrons
neons55818683__neons
ninons64913773nin_ons
noons54125283__noons
nylons9267973__nylons
onions64016433_onions
paeons83915523pa_eons
pangens103112073pangens
pantos85222743panto_s
pardons103817623pardons
parsons93516873parsons
partons94620513partons
patrons93818103patrons
payors114312643pa_yors
pennons939713pennons
pinions93413603pinions
pinons86019943pin_ons
pinyon11459763pinyon_
pontons93315553pontons
racons84319343ra_cons
racoons93912433racoons
radons74118533ra_dons
ramsons939563ramsons
rancors9811373rancors
randans8313213randans
randoms102112433randoms
ransoms92410163ransoms
rations74123433rations
ratoons73815473ratoons
rattons73815323rattons
rayon83815703ra_yon_
ronions73313343ronions
ronyon9309133ronyon_
sabayons1343963sabayons
salmons93713263salmons
salons63823693sa_lons
saloons74415323saloons
sanious7514103sanious
sannops936693sannops
santols73513323santols
santos64421833santo_s
scansions1145323scansions
tachyons1644623tachyons
talions7314113talions
talons64019443ta_lons
tampons112711563tampons
tangos74216323tango_s
tannins72813223tannins
tannoys1055553tannoys
tardyons1244613tardyons
tarpons92612213tarpons
tauons63412673ta_uons
taxons134211503ta_xons
tendons8311473tendons
tenons62916603ten_ons
toyons95512133_toyons
unions64216753_unions
waggons1235503waggons
wagons103911213wa_gons
wangans1149503wangans
wanguns1135023wanguns
wanion93213063wanion_
wanton94413813wanton_
wontons103310533wontons
xenons132710483xen_ons
yapons114411773ya_pons
yaupons12345683yaupons
zayins18409713za_yins

Search took 8 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 Limit1340274146.97019229.1
3Display Results4144140.1402957.1
 (SQL Overall)1786914147.50023825.5
 
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.