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

115 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
cocooned133729(None) 
cocoon10312262cocoon__
cocoons11310562cocoon_s
cojoined1856292cojoined
cologned1237152cologned
condoned122612022condoned
cordoned12229612cordoned
cottoned1138032cottoned
crooned103813342c_rooned
acorned10238273_acorned
beckoned1735783beckoned
cannoned11118143cannoned
cantoned111411523cantoned
cartoned111312833cartoned
cartooned1246313cartooned
cloned94518803__cloned
clowned13447733c_lowned
cocaine111315173cocaine_
cocaines121314443cocaines
coccoid11299283cocco_id
cockaded1836393cockaded
cocked155022563coc__ked
cockered17710213cockered
cockeyed2096123cockeyed
cockled163710823coc_kled
cockney1835873coc_kney
cocoanut1246903cocoanut
coconut11511473coc_onut
cocooning1447023cocooning
cocotte1138603cocotte_
cocottes1238303cocottes
cocounsel1342513cocounsel
coffined1735993coffined
cofound1335513cofoun_d
cofounded1643463cofounded
cohosted1436133cohosted
coigned11418663co_igned
coined94523603__coined
cojones163512103co_jones
cologne1039363cologne_
colognes11310603colognes
colone85425003co_lone_
colonel94213283co_lonel
colones96124433co_lones
colored10313473co_lored
coloured1148313coloured
columned1334923columned
combined15269183combined
commoner142710633commoner
commoved1844763commoved
communed15338213communed
compone136517193compone_
composed154612063composed
concerned1438643concerned
concocted1346763concocted
condoled123110723condoled
condone102616293condone_
condoner112913413condoner
condones112817393condones
coned86040053__c_oned
confined14310403confined
conjoined1965463conjoined
conned95119703__conned
connoted1138863connoted
consoled112911453consoled
convened143412223convened
convoked18236163convoked
convoyed17225553convoyed
cooed84534343__coo_ed
cooeed95917863__cooeed
cooeyed1346893co_oeyed
cooked135921363__cooked
cooled95224593__cooled
cooped114821603__cooped
coopted123710763co_opted
corned95224523__corned
coronel94515223co_ronel
coroner94218203co_roner
coronet94227173co_ronet
coronoid1148943coronoid
corroded12147513corroded
cosigned1235723cosigned
cowboyed1943373cowboyed
cozened19349183co_zened
crayoned1435003crayoned
crooked143910943c_rooked
crooner93714043c_rooner
crowned133912433c_rowned
cuckooed1743303cuckooed
cyclone1437243cyclone_
cyclones1537483cyclones
doctored1245613doctored
doggoned1243883doggoned
locoed94312193loc_o_ed
locomoted1444103locomoted
locoweed1442833locoweed
marooned1138563marooned
mooned94216643__mooned
motioned1137453motioned
ochone11311293_ochone_
poisoned1136953poisoned
ratooned977103ratooned
reckoned1546953reckoned
recoined113614423recoined
reconned113610653reconned
recooked15268243recooked
scooped124611743_scooped
scooted103612283_scooted
scorned10229953_scorned
spooned103412443_spooned
swooned11368593_swooned
uncoined111813023uncoined
uncooked15269113uncooked
uncooled112710633uncooled
zooned164011083__zooned

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621157.18620339.8
3Display Results1151150.0631825.4
 (SQL Overall)1786911157.67223291.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.