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

156 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
cowrote1228967(None) 
cowrite123612681cowrite
codrove1336422codrove
compote135616462compote
connote9311612connote
corrode101310572corrode
cowpoke1835102cowpoke
cowrie113814282cowr_ie
cowriter13238882cowriter
cowrites133011592cowrites
coyote11411782co_yote
rewrote1039122rewrote
towrope1245582towrope
wrote84717482__wrote
borate85026153bo_rate
bowpot13410073bowpot_
bowpots1446023bowpots
capote10315733c_apote
carate84734003c_arate
carrot8423123carrot_
carrots9714623carrots
carroty1248943carroty
carte75940423c_ar_te
cenote83715843c_enote
cerate84829463c_erate
cerite84724873c_erite
chayote1536493chayote
chrome133214813c_hrome
cirrate92413493cirrate
cirrose937473cirrose
citrate92216803citrate
coarse84813903coar_se
cocotte1138603cocotte
cocreate122611813cocreate
codrive1337653codrive
coelome1139693coelome
coerce10310403coer_ce
coesite9713623coesite
cognate10312203cognate
cohort1110720263cohort_
cohorts123411103cohorts
collate92919683collate
colone85425003co_lone
comate104124843co_mate
commode1438123commode
commove1635963commove
commute134310443commute
comose105016843co_mose
compete134716553compete
compone136517193compone
compose135716663compose
compotes144716513compotes
compute134513663compute
comrade12139213comrade
comte96125473co__mte
concrete12411083concrete
condole102914953condole
condone102616293condone
confute1239263confute
connate9315753connate
connoted1138863connoted
connotes10311453connotes
console92715983console
conte76633203co__nte
contrite10318543contrite
convoke16207173convoke
cooee74531023co__oee
coot67860383co__ot_
cooter85128613co__oter
cootie84223093co__otie
coots75636843co__ots
coplot10518273coplot_
coplots11511593coplots
coprolite1348623coprolite
corbie103618203co_rbie
cordate10315223cordate
cordite10315263cordite
core67263113co_r__e
cornet84436733co_rnet
cornute939643cornute
corody12149703co_rody
corona83817403co_rona
coronae94214893co_ronae
coronate103018213co_ronate
coronel94515223co_ronel
coroner94218203co_roner
coronet94227173co_ronet
corotate102813933co_rotate
corpse104013403co_rpse
corrade101111043corrade
corrie83621233co_rrie
corroded12147513corroded
corrodes111310333corrodes
corrody13136143corrody
corse75036183co_r_se
corset85636223co_rset
cortex15311473co_r_tex
corvee114320093co_rvee
corvet114626933co_rvet
costate94019273costate
cote66648733c___ote
courage10310993courage
courante1049953courante
course85117783cour_se
court75532773cour_t_
courted103514923cour_ted
courter94516483cour_ter
courts84216173cour_ts
cowage12310673cow_age
cowbane1437673cowbane
cowboy1637063cowbo_y
cowboyed1943373cowboyed
cowboys1735253cowboys
cowhage1636303cowhage
cowhide1636143cowhide
coworker1744683coworker
cowpat13312033cowpat_
cowpats1437713cowpats
cowpie133511513cow_pie
cowpokes1944573cowpokes
cowpox2035003cowpo_x
cowpoxes2244513cowpoxes
cowries124218013cowries
cowriters14317283cowriters
cowritten1443243cowritten
cowry135512483cowr__y
coyotes12410703co_yotes
crate76537403c__rate
crone75231333c__rone
crore74922873c__rore
croute84617273c__route
croze164719453c__roze
cuprite1159683cuprite
curate85226243c_urate
curite85222943c_urite
forte86131463fo_r_te
garote7717953_garote
garrote8510103garrote
horste94817413ho_rste
joyrode1853303joyrode
miswrote1346183miswrote
morose85116243mo_rose
norite63221133no_rite
orate55133303_o_rate
outwrote1137723outwrote
porose84818743po_rose
rewrite10311143rewrite
rote46249023___rote
skywrote1841803skywrote
torose64317693to_rose
torot56139943to_rot_
toroth95512963to_roth
torte55431703to_r_te
towropes1344953towropes
write85522833__write
wroth116815883__wroth

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.406440125.6
2DLD Change Limit1340271565.97022450.1
3Display Results1561560.0463391.3
 (SQL Overall)1786911566.42227824.8
 
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.