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 “stake” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

210 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
stake9592753(None) 
sake85244961s_ake
shake124726401shake
slake93724051slake
snake94821111snake
spake114322741spake
stade64825301stade
stage65330191stage
staked114621941staked
stakes103927291stakes
stale55637101stale
stane55933001stane
stare54440261stare
state56237331state
stave85324991stave
stoke94922511stoke
strake104017391strake
take84739261_take
awake125014782awake
bake105637512_bake
betake124512702betake
brake116025342brake
cake105439962_cake
crake114823522crake
drake104918302drake
estate64719762estate
etape74413702etape
fake115534942_fake
flake125119972flake
hake115637842_hake
intake10510862intake
jake155925772_jake
lake85741602_lake
latke94817092latke
make105537882_make
mistake131312612mistake
quake184114642quake
rake84841572_rake
retake104718532retake
sabe66140572s_abe
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
saker95132022s_aker
sakes95540752s_akes
saki85628472s_aki
sale44959702s_ale
same65245642s_ame
sane45954332s_ane
sate45556102s_ate
save75741362s_ave
scale74629142scale
scape96921842scape
scare75334462scare
setae56026222seta_e
shade95125582shade
shaken134113612shaken
shaker134319462shaker
shakes135024592shakes
shako125516082shako
shaky154616842shaky
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
shitake1455612shitake
sike87138782s_ike
skate94721542skate
slaked114318272slaked
slaker104219272slaker
slakes104021882slakes
slate55438282slate
slave84224032slave
smaze165012932smaze
smoke115015822smoke
snaked115017592snaked
snakes103919602snakes
snakey135011272snakey
snaky125113912snaky
snare54429982snare
soak87227662soak_
soaked114717592soaked
soaker105717532soaker
soaks95220292soaks
soave84219052soave
soke85436262s_oke
space95325672space
spade84423322spade
spae65034322spa_e
spale74929212spale
spare75135562spare
spate74731582spate
spike114922842spike
splake1259782splake
spoke114818662spoke
stab67329932sta_b
stable83921642stable
stabs76221382stabs
stack114421692stack
stacked143416122stacked
stacker134416262stacker
stacks124317262stacks
stacte82113912stacte
stades74626242stades
staff113817712staff
stag57332002sta_g
staged84521562staged
stager74821342stager
stages75629492stages
stagey105915582stagey
stags66226742stags
stagy96618892stagy
staid66722072staid
staig65519632staig
stain55727932stain
stair54719932stair
staled74728102staled
staler64025822staler
stales65538292stales
stalk94518002stalk
stalked123811172stalked
stalker113912252stalker
stalks104614552stalks
stalky13499302stalky
stall54722352stall
stamen84115942stamen
stamp95217362stamp
stance84316912stance
stand65923282stand
staned74824642staned
stanes64933402stanes
stang66424682stang
stank95823302stank
stanks104917702stanks
stapes85028732stapes
staph104314652staph
staple84415822staple
star48037762sta_r
stared75429872stared
starer64027362starer
stares66038752stares
stark95425622stark
starker114114692starker
stars55836572stars
start55642312start
starve94613742starve
stases64225562stases
stash84916972stash
stat47352692sta_t
stated75427832stated
stater64427552stater
states64337082states
stats55933362stats
statue66015322statue
staved103918052staved
staves94525192staves
staw78627692sta_w
stay78333722sta_y
stayed104817272stayed
stayer94516482stayer
stays86022022stays
steak95219802steak_
steaks104415852steaks
steek95418002steek
stele55026842stele
stere55328542stere
stile54931572stile
stime76521792stime
stipe76523372stipe
stoae55024262stoae
stoked114718292stoked
stoker104417622stoker
stokes104821792stokes
stole54928812stole
stone55431182stone
stope74727242stope
store56333812store
stove85220252stove
strafe95215972strafe
straked125415342straked
strakes114218072strakes
strike105619732strike
stroke105116172stroke
stupe75217752stupe
stye76218972st_ye
style85519362style
suave83519872suave
swage94919562swage
swale85221592swale
sware85828212sware
syke115420562s_yke
tace65342512_tace
tae38267052_ta_e
taka87623592_taka
taken94819142_taken
taker95229002_taker
takes94437792_takes
tale46154162_tale
tame66343662_tame
tape64538142_tape
tare45957622_tare
tate44748602_tate
tike85534482_tike
toke86738492_toke
tsade64311122tsade
tyke115720502_tyke
uptake1236962uptake
wake114935702_wake

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538002101.70331591.3
3Display Results2102100.0464565.2
 (SQL Overall)1786912101.84297009.2
 
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.