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

180 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
cottony123725(None) 
cotton8312991cotton_
cottons9312191cottons
buttony1236172buttony
colony115417272co_lony
compony1613011912compony
cottoned1138032cottoned
muttony1235322muttony
astony9510523_astony
atony87218853__atony
betony114211583_betony
boston8513043boston_
bostons9312903bostons
botany1139263bo_tany
bottom1048723botto_m
bottomry1542043bottomry
bottoms1136993bottoms
bouton8311533bouton_
boutons9310783boutons
button8310273button_
buttons9310333buttons
canton85722993canton_
cantons95221203cantons
carton84522663carton_
cartons94122473cartons
cartoony13377403cartoony
cation83925503cation_
cations94524143cations
cattery123811603cattery
cattily123210853cattily
catting103922643catting
catty104520413catt__y
chiton112612393chiton_
chitons122611913chitons
ciphony1744973ciphony
citatory1347213citatory
citron83112983citron_
citrons92913223citrons
clotting113110643clotting
clotty11208263clott__y
coating103525313coating
coattend1134653coattend
cocoon10312263cocoon_
cocoons11310563cocoons
codon86522853co_don_
codons96119463co_dons
cogon89120903co_gon_
cogons96818113co_gons
coition9314313coition_
coitions10312853coitions
colon78630193co_lon_
colone85425003co_lone
coloni85619203co_loni
colons86028683co_lons
colotomy1545403colotomy
common12310803common_
commonly1744963commonly
commons13311043commons
company1619711143company
compone136517193compone
condone102616293condone
contend103511893contend
content94326153content
conto76027173conto__
contort91422343contort
contos84923233conto_s
contour939973contour
convoy14348543convo_y
cony96537833c___ony
cooey105828223co__oey
cooky145321363co__oky
cooly105525423co__oly
coon67248943co__on_
coons76737283co__ons
cordon95017293cordon_
cordons104415763cordons
corny106023273co__rny
corody12149703co_rody
corona83817403co_rona
corrody13136143corrody
cortin82423153cortin_
cortina91915973cortina
cortins92421333cortins
costing104323023costing
costly114012333cost_ly
cotan71521783co_tan_
cotans81317923co_tans
coting94629253co_ting
cotta75818573cott__a
cottae84615703cott_ae
cottage104210573cottage
cottagey14305233cottagey
cottar84613813cott_ar
cottars94412243cottars
cottas84615573cott_as
cotter84926673cott_er
cotters94323443cotters
cottier93814173cottier
cottoning1237343cottoning
coupon102810993coupon_
coupons112710563coupons
cowboy1637063cowbo_y
craton84517193craton_
cratons94316033cratons
crony105918673c__rony
croton84415453croton_
crotons93714373crotons
crouton947133crouton_
croutons1036753croutons
custody1334093custody
cutting103817493cutting
cutty105417223cutt__y
cyton101511463c_yton_
cytons111710183c_ytons
dittany1135653dittany
dottily1147283dottily
dotting93314483dotting
dotty94516103dott__y
ecotone938583eco_tone
gluttony1242513gluttony
gobony1236913go_bony
goony95519783go__ony
gotten73410113gotten_
hotting113116523hotting
jetton1338033jetton_
jettons1437273jettons
jotting152912773jotting
jotty155012603jott__y
loony86918963lo__ony
lotion65716523lotion_
lotions74614763lotions
lottery10389833lottery
lotting82917753lotting
lotto55217573lotto__
lottos64613103lotto_s
monotony1347073monotony
moony104818273mo__ony
motion85217553motion_
motions94215003motions
motto76119513motto__
mottoes93412193mottoes
mottos84615243motto_s
mouton8410853mouton_
moutons9410313moutons
mutton8510453mutton_
muttons949283muttons
notion64516583notion_
notions74014483notions
oniony9369703_oniony
ostomy1137833_ostomy
otto45220643_otto__
ottos54714323_otto_s
ponton83217643ponton_
pontons93315553pontons
potatory1348413potatory
potboy1397813potbo_y
potion84519573potion_
potions93417423potions
potstone1039423potstone
pottery123011073pottery
potting103720893potting
potto75320943potto__
pottos84615873potto_s
potty105621003pott__y
ratton64116123ratton_
rattons73815323rattons
rotatory1147213rotatory
rotten64115433rotten_
rottenly1144153rottenly
rotting82919683rotting
stony85818643__stony
syntony1344523syntony
tony75635153___tony
tortoni738033tortoni
tottery10388483tottery
totting82816843totting
wonton93410963wonton_
wontons103310533wontons
wotting112913843wotting
zootomy2154803zootomy

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.406440125.6
2DLD Change Limit1340271806.68620045.9
3Display Results1801800.0632857.1
 (SQL Overall)1786911807.15524974.3
 
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.