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

117 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
cowsheds173474(None) 
cowshed1637771cowshed_
coalsheds1542862coalsheds
coshed124217542co_shed_
coshers123618172co_shers
coshes115022782co_she_s
cowherds1735422cow_herds
snowsheds1642852snowsheds
airsheds12274963airsheds
bobsleds13304383bobsleds
boshes114721883bo_she_s
bowheads1745373bow_heads
bowsed125715973bows_ed_
bowses115718863bows_e_s
bowshots1645093bowshots
cashed125124353c_ashed_
cashes114729883c_ashe_s
cashews15428603c_ashews
choushes1637623choushe_s
chowsed16478603chows_ed_
chowses155611283chows_e_s
clashed133614013clashed_
clashers134213993clashers
clashes124017283clashe_s
coached153313843coached_
coachers154312293coachers
coaches144018693coache_s
coalshed1435013coalshed_
coasted104015943coasted_
coasters104317303coasters
coeds85920163co___eds
coheads13289233co__heads
cohoshes1635873cohoshe_s
cokeheads1944473cokeheads
coleseeds1244323coleseeds
coloreds1138093coloreds
conches144019813conche_s
cooches143515833cooche_s
copses104922473cops_e_s
corses84433463cors_e_s
corsets94819803cors_ets
corslets1038273corslets
cosecs105015213co_s_ecs
coses76949493co_s_e_s
cosets85824403co_s_ets
coseys115215813co_s_eys
cosher114819903co_she_r
cosied94819883co_sied_
cosies84932153co_sie_s
cosmids1237633co_smids
cossets95014283co_ssets
costed95623113co_sted_
costers94128303co_sters
couched154115793couched_
couchers153513843couchers
couches144020463couche_s
coughed143310903coughed_
coughers14399953coughers
cowages13310933cowage_s
cowards1339613cow_ards
cowbinds1634453cowbinds
cowbirds1644043cowbirds
cowed115637843cow__ed_
cowered133214643cowered_
cowers114625533cow__ers
cowfishes2045723cowfishe_s
cowhands1765263cowhands
cowherb1735103cow_herb
cowherbs1833543cow_herbs
cowherd1636953cow_herd
cowhide1636133cow_hide
cowhides1735993cow_hides
cowled125218383cow_led_
cowpeas1437273cow_peas
cowpies143314283cowpie_s
cowries124218013cowrie_s
cowskins1745263cowskins
cowslips1543613cowslips
crashed134214203crashed_
crashers134013223crashers
crashes124618403crashe_s
crossheads1643243crossheads
crowsteps1642523crowsteps
crushed134111963crushed_
crushers134010083crushers
crushes124215133crushe_s
cuishes122810823cuishe_s
dogsleds1142913dogsleds
dowsed115015013dows_ed_
dowsers115013523dows_ers
dowses105718303dows_e_s
hogsheads1773663hogsheads
joshed174610903jo_shed_
joshers174111593jo_shers
joshes165114853jo_she_s
koshers144811803ko_shers
moshed124517493mo_shed_
moshers124017843mo_shers
moshes115222873mo_she_s
nonskeds1343923nonskeds
noshed104413503no_shed_
noshers103614323no_shers
noshes96618233no_she_s
potsherds1544013potsherds
sheds96122703___sheds
snowshed1534413snowshed_
toolsheds1342323toolsheds
toshes94520103to_she_s
towheads1544813tow_heads
towhees13277793tow_hees
unwasheds16233103unwasheds
woodsheds1742943woodsheds
woolsheds1642553woolsheds
wooshed14167403wooshed_
wooshes13169883wooshe_s
worsteds1234483worsteds
wowsers13488753wows_ers

Search took 10 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.1731032896.0
2DLD Change Limit1461621179.01616211.4
3Display Results1171170.0931258.1
 (SQL Overall)1786911179.28219251.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.