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

154 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
cottoned113803(None) 
bottomed1344662bottomed
buttoned1137502buttoned
cantoned111411522cantoned
cartoned111312832cartoned
cocooned1337292cocooned
condoned122612022condoned
cordoned12229612cordoned
cottered112511732cottered
cotton8312992cotton__
cottons9312192cotton_s
cottonseed1351672cottonseed
cottonweed1651662cottonweed
cottony1237252cotton_y
motioned1137452motioned
atoned75417543__atoned
attorned955353_attorned
attuned835173_attuned
battened11259573battened
botonee9311833bo_tonee
bottled104611233bott_led
bottomer1245103bottomer
buttoner1036973buttoner
caftaned1445093caftaned
cannoned11118133cannoned
captioned1445763captioned
cartooned1246313cartooned
catted95422473catt__ed
cautioned1245363cautioned
centones10313663centones
cloned94518803c__loned
clotted104011823clott__ed
coated94927033coat__ed
coattend1134643coatten_d
coattended1443103coattended
coffined1735993coffined
coigned11418663co_igned
coined94523603co__ined
cojoined1856293cojoined
cojones163512103co_jones
cologned1237153cologned
colone85425003co_lone_
colonel94213283co_lonel
colones96124433co_lones
colored10313473co_lored
columned1334923columned
combined15269183combined
commoner142710633commoner
commoved1844763commoved
communed15338203communed
compone136517193compone_
composed154612063composed
condoled123110713condoled
condone102616293condone_
condoner112913393condoner
condones112817393condones
coned86040053c___oned
confined14310403confined
conjoined1965463conjoined
conned95119703co__nned
connoted1138863connoted
consoled112911443consoled
contained12310893contained
contemned1446793contemned
contend103511893conten_d
contended1339273contended
contented12313043contented
continued1248483continued
contorted1239473contorted
contoured1237293contoured
contused1138443contused
convened143412223convened
convoked18236163convoked
convoyed17225553convoyed
cooed84534343co__o_ed
cooeed95917863co__oeed
cooked135921363co__oked
cooled95224583co__oled
cooped114821603co__oped
corned95224523co__rned
coronel94515223co_ronel
coroner94218203co_roner
coronet94227173co_ronet
corroded12147513corroded
cosigned1235723cosigned
costed95623113cost__ed
costumed1365033costumed
coted85033853co_t__ed
cottae84615703cott_ae_
cottage104210573cottage_
cottager11306803cottager
cottages113310493cottages
cottagey14305233cottagey
cotter84926673cott__er
cottier93814173cott_ier
cottoning1237343cottoning
cottonseeds1451143cottonseeds
cottonweeds1751143cottonweeds
cottonwood1651773cottonwood
cowboyed1943373cowboyed
cozened19349183co_zened
crayoned1435003crayoned
crooned103813343c_rooned
cuttled10319933cutt_led
dittoed936733ditto_ed
doctored1245613doctored
doggoned1243883doggoned
dotted84717523dott__ed
ecotone938583eco_tone_
ecotones1039493eco_tones
fattened12268283fattened
fortuned1285323fortuned
grottoed10234503grotto_ed
hotted104319933hott__ed
intoned8811983_intoned
jotted143615173jott__ed
kittened1334523kittened
kotowed1533773ko_towed
kowtowed1941953kowtowed
lotted74222403lott__ed
mittened1136363mittened
mooned94216643mo__oned
motioner1037593motioner
motored1039933mo_tored
mottled10409973mott_led
mottoes93412193motto_es
optioned1146373optioned
pattened11299393pattened
poisoned1136953poisoned
portioned1248333portioned
postponed1445903postponed
potholed1448393potholed
potstone1039423potstone_
potstones1149203potstones
potted94624013pott__ed
pottered112311663pottered
rationed9410093rationed
ratooned977103ratooned
rattened9218623rattened
rattooned1043843rattooned
rotted74524433rott__ed
rottener8216973rottener
softened1235663softened
sotted74121393sott__ed
stoned75923143__stoned
tattooed944573tattooed
toned65435343___toned
totted74319953tott__ed
tottered9208703tottered
unatoned939423unatoned
unstoned9311043unstoned
wantoned12117223wantoned
wotted104115713wott__ed
zooned164011083zo__oned

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 Filter1786911461620.296603685.8
2DLD Change Limit1461621548.43617326.0
3Display Results1541540.0632444.4
 (SQL Overall)1786911548.79520317.3
 
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.