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

101 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
cowpoke183510(None) 
cowpokes1944571cowpokes
compone136517192compone
compose135716662compose
compote135616462compote
convoke16207172convoke
cowpie133511512cowp_ie
cowpox2035002cowpo_x
cowpoxes2244512cowpoxes
cowrote12289672cowrote
mopoke1436632mo_poke
slowpoke1742352slowpoke
awoke124912003_aw_oke
bespoke15468113bespoke
bowlike16349473bowlike
bowpot13410073bowpo_t
bowpots1446023bowpots
capote10315733c_apote
choke145118023c__hoke
clodpole1343603clodpole
codrove1336423codrove
coelome1139693coelome
coke107038383c___oke
colone85425003co_lone
comake144413423co_make
commode1438123commode
commove1635963commove
comose105016843co_mose
compare135814993compare
compere134616623compere
compete134716553compete
compile13312443compile
compo115318573compo__
compony1613011913compony
comport133616843comport
compos124818803compo_s
composed154612063composed
composer145012953composer
composes145017113composes
compost134515353compost
compotes144716513compotes
compute134513663compute
condole102914953condole
condone102616293condone
connote9311613connote
console92715983console
convoked18236163convoked
convoker17226903convoker
convokes17247703convokes
cooee74531023co__oee
cook107236933co__ok_
cooked135921363co__oked
cooker124722453co__oker
cookey155414333co__okey
cookie123716043co__okie
cooks115429143co__oks
cooky145321363co__oky
cope86847383co_p__e
copout10418783co_pout
coppice1537483coppice
copse95623923co_p_se
cornpone1246933cornpone
corpora1139353corpora
corpse104013403corp_se
corrode101310573corrode
coupe96023483coup__e
couple104415963coup_le
coupon102810993coupo_n
coupons112710563coupons
cowage12310673cow_age
cowbane1437673cowbane
cowboy1637063cowbo_y
cowboyed1943373cowboyed
cowboys1735253cowboys
cowhage1636303cowhage
cowhide1636143cowhide
coworker1744683coworker
cowpat13312033cowp_at
cowpats1437713cowpats
cowpea1337643cowp_ea
cowpeas1437273cowpeas
cowpies143314283cowpies
cowplop1643363cowplop
cowplops1743173cowplops
cowrie113814283cow_rie
cowrite123612683cowrite
coyote11411783co_yote
coypou13268403coypo_u
coypous14248813coypous
hoopoe11911233hoopo_e
mopokes1536693mo_pokes
oospore939013oospore
oppose1039193_oppose
poke105335363___poke
respoke134311283respoke
rewoke1339521223rew_oke
slowpokes1842243slowpokes
spoke114818663__spoke
towrope1245583towrope
unspoke1336573unspoke
woke115527963__w_oke

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.423422437.4
2DLD Change Limit1340271016.00022337.8
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.46927622.7
 
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.