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

153 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
cowbane143767(None) 
cowbanes1537421cowbanes
combine133014722combine
corban10314692corban_
corbans11313172corbans
cowage12310672cow_age
cowbind1536612cowbind
cowhage1636302cowhage
cowhand1665932cowhand
cowman13910372cowman_
dogbane1135652dogbane
bane65250433___bane
borane84620213bo_rane
bowline123613113bowline
bowman13129853bowman_
browband1643883browband
bugbane1255863bugbane
cabana103913563c_abana
cabbage1446983cabbage
cane66653123c___ane
carbine112918643carbine
cetane8315283c_etane
chicane1489553chicane
cobalt10317393co_balt
cobble123615263co_bble
coble94823173co_b_le
cocaine111315173cocaine
cockade1638133cockade
codable12311663codable
codeine103815033codeine
cognate10312203cognate
cohobate1547013cohobate
cohune1189423co_hune
coigne94612193co_igne
coinage10310553coinage
collage102813763collage
collate92919683collate
cologne1039363cologne
colone85425003co_lone
comade114415323co_made
comae97128423co_ma_e
comake144413423co_make
comate104124843co_mate
combat12316753comba_t
combated1539823combated
combater1439383combater
combats13311683combats
combe116223543comb__e
combined15269183combined
combiner14259723combiner
combines142814623combines
combing143714733combing
command14399213command
commune13329363commune
company1619711143company
compare135814993compare
compone136517193compone
comrade12139213comrade
concave1439373concave
condone102616293condone
cone67256963co___ne
confine12315583confine
coniine9316803coniine
conine84528553co_nine
connate9315753connate
convene123314323convene
coolant9316463coolant
corbie103618203corb_ie
corbina111911453corbina
cordage11310063cordage
cordate10315223cordate
corkage1438373corkage
coronae94214893coronae
corrade101111043corrade
corsage1039803corsage
corvine122113643corvine
corybant1547573corybant
cosine83823513co_sine
costae85319683costa_e
costate94019273costate
cotan71521783co_tan_
cotans81317923co_tans
cottae84615703cotta_e
cottage104210573cottage
courage10310993courage
courant9317973courant
courante1049953courante
couvade1335063couvade
cowages13310943cow_ages
coward12411673cow_ard
cowbell1445223cowbell
cowbinds1634453cowbinds
cowbird1534433cowbird
cowboy1637063cowb_oy
cowboyed1943373cowboyed
cowboys1735253cowboys
cowhages1736113cowhages
cowhands1765263cowhands
cowhide1636143cowhide
cowing124526323cow_ing
cowinner1334753cowinner
cowling134017423cowling
cowmen13810923cowmen_
cowpat13312033cowpa_t
cowpats1437713cowpats
cowpie133511513cow_pie
cowpoke1835103cowpoke
cowrie113814283cow_rie
cowrite123612683cowrite
cowrote12289673cowrote
coxae146115183co_xa_e
crane75331603c__rane
crowbar1444273crowba_r
crowbars1544443crowbars
cubage1178273c_ubage
cutbank1545533cutbank
dogbanes1245433dogbanes
dogvane1243853dogvane
dowable13189453dowable
forbade13259103forbade
forbare122310513forbare
goban84414073go_ban_
gobang10376703go_bang
gobans94412043go_bans
gowan95415743gow_an_
gowaned1235763gow_aned
gowans105512293gow_ans
gowany13457493gow_any
henbane1237363henbane
hogmane1336343hogmane
jawbone19134443jawbone
lobate82915243lo_bate
lowball1275503lowball
lowland1134693lowland
montane91313623montane
nonbank1345903nonbank
octane81411633_octane
roband92310723ro_band
rowable121510303rowable
rowan85418733row_an_
rowans95715343row_ans
snowbank1743233snowbank
sorbate9311733sorbate
soutane7312063soutane
sowable121610753sowable
sowans94215893sow_ans
tolane64316583to_lane
towable121910113towable
towage1039833tow_age
towline102911543towline
towplane1345313towplane
urbane82211383_urbane
wane76344723__w_ane

Search took 7 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.420425454.8
2DLD Change Limit1340271535.75023309.0
3Display Results1531530.0463326.1
 (SQL Overall)1786911536.21628746.9
 
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.