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

441 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
cottons931219(None) 
cotton8312991cotton_
cottony1237251cottony
bostons9312892bostons
bottoms1136982bottoms
boutons9310782boutons
buttons9310332buttons
cantons95221202cantons
cartons94122472cartons
cations94524142cations
chitons122611912chitons
citrons92913222citrons
cocoons11310562cocoons
codons96119462co_dons
cogons96818112co_gons
coitions10312842coitions
colons86028672co_lons
commons13311042commons
contos84923232conto_s
coons76737282co__ons
cordons104415762cordons
cortins92421312cortins
cotans81317922co_tans
cottars94412232cottars
cottas84615572cott_as
cotters94323432cotters
cottoned1138032cottoned
coupons112710552coupons
cratons94316032cratons
crotons93714372crotons
croutons1036722croutons
cytons111710182c_ytons
jettons1437272jettons
lotions74614762lotions
lottos64613102lotto_s
motions94215002motions
mottoes93412192mottoes
mottos84615242motto_s
moutons9410312moutons
muttons949282muttons
notions74014482notions
ottos54714322_otto_s
pontons93315542pontons
potions93417412potions
pottos84615872potto_s
rattons73815322rattons
wontons103310532wontons
actions94218513actions
amotions1069843amotions
attorns738433_attorns
batons85519423_batons
battens95313263battens
betons84919553_betons
bettors93312473bettors
biotrons1037233biotrons
bolsons969473bolsons
bonbons1139333bonbons
boons75031913bo__ons
borons85520543bo_rons
bosons85016653bo_sons
boston8513043boston_
bottles94216273bottles
bottom1048713botto_m
botts75224863bott__s
bouton8311533bouton_
burtons9310853burtons
button8310273button_
buttony1236173buttony
caftans12179443caftans
camions113916133camions
cannons94412883cannons
canons85522063c_anons
canton85722993canton_
cantors94620753cantors
cantos84826973canto_s
canyons124511593canyons
capons104119503c_apons
captans111612053captans
captions123813213captions
captors113914983captors
carbons115418943carbons
cardons104519933cardons
carton84522663carton_
cartoons104012803cartoons
castors94919433castors
cation83925503cation_
catkins133012563catkins
catlins93818843catlins
catties94023053catties
catting103922643catting
cautions103313163cautions
centones10313663centones
centos85920463cento_s
cestos84718093cesto_s
chitins122713793chitins
chiton112612393chiton_
chorions13310653chorions
chortens13308793chortens
chotts113610983chott__s
cions75222853c__ions
cistrons102710623cistrons
citations11312493citations
citators10310233citators
citrins92614363citrins
citron83112983citron_
citrous93112983citrous
citterns10318113citterns
claxons1635803claxons
clons75228133c__lons
clotting113110643clotting
coactions1349733coactions
coactors1239453coactors
coatees93816533coatees
coaters93525773coaters
coating103525303coating
coatings113811843coatings
coatis85122593coat_is
coats75634993coat__s
coattend1134643coattend
coattends1243913coattends
cocains111313923cocains
coccous1038993coccous
cochins141413093cochins
cocoas104915743co_coas
cocoon10312263cocoon_
cocos95624693co_co_s
codeins103715483codeins
codens94821013co_dens
codlins104116243codlins
codon86522853co_don_
coeloms1139063coeloms
coffins153110193coffins
cogitos1037613cogito_s
cogon89120903co_gon_
cohogs125810273co_hogs
cohos105921853co_ho_s
coigns94410063co_igns
coins75834553co__ins
coition9314313coition_
coitus8511893coit_us
cojoins1638993cojoins
cojones163512103co_jones
colins85229043co_lins
collins93419833collins
collops112611753collops
cologs96517353co_logs
colon78630193co_lon_
colone85425003co_lone
colones96124423co_lones
coloni85619203co_loni
colonus94413433co_lonus
colony115417263co_lony
colors86622373co_lors
colters93522433colters
colts76633293colt__s
columns1136473columns
combos125316613combo_s
common12310803common_
comous10816493co_mous
compone136517193compone
compony1613011913compony
compos124818803compo_s
comtes106222813comt_es
conations111318893conations
condoes104319203condoes
condoms124214083condoms
condone102616293condone
condones112817393condones
condors104018553condors
condos94322333condo_s
congoes103617303congoes
congos94219883congo_s
congous103615073congous
conins84327233co_nins
conjoins1738133conjoins
conns75024233co__nns
cons66057693c___ons
consols92914073consols
contains10316533contains
contemns1237403contemns
contend103511893contend
contends112810573contends
content94326153content
contents104018213contents
contes84432913cont_es
conto76027173conto__
contort91422343contort
contorts101112633contorts
contour939963contour
contours1039613contours
contras93015603contras
controls10311393controls
convoys15267023convoys
coofs105924713co__ofs
cooks115429143co__oks
cooktops1644063cooktops
cools75632633co__ols
coon67248943co__on_
coops96229643co__ops
cooptions13107733cooptions
coos67456493co__o_s
cooters94525713cooters
cooties93725733cooties
coots75636843co__ots
copatrons1346333copatrons
copens106119963co_pens
copious11311963copious
coplots11511593coplots
copters113621273copters
corbans11313173corbans
cordon95017293cordon_
cormous11312343cormous
corns76034763co__rns
corona83817403co_rona
coronas93916903co_ronas
cortin82423143cortin_
cortina91915963cortina
cortinas102212423cortinas
cosigns1047513cosigns
cosmos10311753cosmo_s
costars94217993costars
costers94128303costers
costing104323023costing
costs77231143cost__s
cotan71521783co_tan_
cotes76347843co_t_es
cothurns1344503cothurns
cotillons1144633cotillons
coting94629253co_ting
cots68054843co_t__s
cotta75818573cott__a
cottae84615703cott_ae
cottage104210573cottage
cottages113310493cottages
cottar84613813cott_ar
cotter84926673cott_er
cottier93814173cottier
cottiers10399153cottiers
cottoning1237343cottoning
cottonseed1351673cottonseed
cotypes1437943cotypes
coupon102810993coupon_
cousins9516003cousins
couters93827283couters
couths115715393cout_hs
covens114919263co_vens
covetous1347093covetous
covins114618063co_vins
cowboys1735253cowboys
coydogs1434493coydogs
coyotes12410703coyotes
coypous14248803coypous
cozens176314923co_zens
craton84517193craton_
crayons12439233crayons
crepons1139313crepons
cretins93216423cretins
croons85418423c_roons
croton84415453croton_
crouton947133crouton_
cryotrons1444743cryotrons
customs11348253customs
custos84014313custo_s
cutdowns1443343cutdowns
cutins83919983c_utins
cutters94218953cutters
cutties93118843cutties
cutting103817493cutting
cuttings11277613cuttings
cuttles93613923cuttles
cyton101511463c_yton_
daltons8310403daltons
dattos74311903datto_s
dittos74111973ditto_s
doblons1037043doblons
dobsons1036203dobsons
doctors1039983doctors
donjons1536733donjons
dotations101411623dotations
dottels8327783dottels
dotters83715973dotters
dotting93314483dotting
dottles83912283dottles
ecotone938583eco_tone
ecotones1039493eco_tones
emotions10610283emotions
fattens105111713fattens
foetors1039753foetors
foisons1047613foisons
frontons1136503frontons
futons93911513_futons
gluttons944273gluttons
godsons966663godsons
goons65326773go__ons
gorgons938853gorgons
gotten73410113gotten_
grottoes9276753grottoes
grottos8337333grotto_s
guncottons1351463guncottons
hotdogs1234453hotdogs
hotrods1148283hotrods
hotties103016953hotties
hotting113116513hotting
introns73515023introns
jetons134512613_jetons
jetton1338033jetton_
jotters143413803jotters
jotting152912773jotting
jottings16275193jottings
kations114013663kations
kittens11347583kittens
kotos95717693ko_to_s
kotows13446513ko_tows
kowtows1742753kowtows
lattens75014673lattens
lattins74115483lattins
leptons91910413leptons
logions86211293logions
logons79818173lo_gons
loons55731723lo__ons
lotion65716523lotion_
lotos54724633lo_to_s
lotters73921063lotters
lottes65322753lott_es
lotting82917753lotting
lotto55217573lotto__
matrons93517633matrons
mattins93316143mattins
meltons9410923meltons
mittens9349883mittens
moons75331003mo__ons
morions94014633morions
morons84919543mo_rons
motion85217553motion_
motmots1166133motmots
motors84616593mo_tors
mottes85523693mott_es
mottles93415803mottles
motto76119513motto__
motts76527003mott__s
mouton8410853mouton_
mutons84314363_mutons
mutton8510453mutton_
muttony1235323muttony
nations74720563nations
natrons73215663natrons
nektons1136393nektons
newtons1036803newtons
nitons64614903_nitons
noons54125283no__ons
nostocs947533nostocs
notations91512973notations
notion64516583notion_
octagons1144493octagons
octans81411143_octans
octrois938333octrois
odeons739023_odeons
onions64016433_onions
options93810593options
orlons6411013_orlons
ottars64112223_ottars
otters64021513_otters
otto45220643_otto__
ottomans1044493_ottomans
partons94620513partons
patrons93818103patrons
pattens95414923pattens
photons123814413photons
phytons15319063phytons
pistons93016373pistons
pitons85319043_pitons
plutons938343plutons
poisons9310343poisons
pompons1338543pompons
ponton83217643ponton_
pontoons10279303pontoons
poons75430963po__ons
portions10514393portions
postins93721203postins
postops11311703postops
potations111615063potations
potatoes1039943potatoes
potboys1475263potboys
poteens92910883poteens
pothos114214693potho_s
potion84519573potion_
potstone1039423potstone
potstones1149203potstones
potteens10256793potteens
potters94024343potters
potties93723543potties
potting103720893potting
pottles93816983pottles
potto75320943potto__
protons93118003protons
putons83515153_putons
pythons1537363pythons
rations74123433rations
ratoons73815473ratoons
rattans73411953rattans
rattens74213403rattens
ratton64116123ratton_
rattoons8327513rattoons
rhytons13295883rhytons
ronions73313343ronions
ronyons10258423ronyons
rotations91613843rotations
rotators8310183rotators
rotors64917933ro_tors
rotos56027883ro_to_s
rotten64115433rotten_
rotters74421393rotters
rottes64524833rott_es
rotting82919683rotting
scotties1039733scotties
setons64620173_setons
sextons143710413sextons
softens10347623softens
solions7513733solions
solitons849573solitons
solons65120003so_lons
sotols63714453so_tols
stolons73410233stolons
stotins73213863stotins
tattoos738643tattoos
testons7313553testons
tons46553053___tons
toons55027533__toons
tortoni738033tortoni
tortonis848733tortonis
totters74618733totters
totting82816843totting
toyons95512123to_yons
tritons73814883tritons
voudons1135313voudons
wantons103713013wantons
wittols1035733wittols
wonton93410963wonton_
wotting112913843wotting
youpons12265983youpons
zoons144919693zo__ons

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.1701051123.5
2DLD Change Limit1340274417.97016816.4
3Display Results4414410.3261352.8
 (SQL Overall)1786914418.46621106.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.