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

278 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
stare5444026(None) 
scare75334461scare
share86437081share
snare54429981snare
spare75135561spare
stade64825301stade
stage65330191stage
stake95927531stake
stale55637101stale
stane55933001stane
star48037761star_
stared75429871stared
starer64027361starer
stares66038751stares
stark95425621stark
stars55836571stars
start55642311start
starve94613741starve
state56237331state
stave85324991stave
stere55328541stere
store56333811store
sware85828211sware
tare45957621_tare
are37874572__are
aware86420022aware
bare65460522_bare
blare75826232blare
care66968372_care
chare105231982chare
dare55848862_dare
estate64719762estate
etape74413702etape
fare76354462_fare
flare84823632flare
glare65222952glare
hare76255732_hare
mare64759322_mare
pare66760842_pare
quare143920542quare
rare45348432_rare
sabe66140572s_abe
sabre74821502sabre
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sale44959702s_ale
same65245642s_ame
sane45954332s_ane
sard55344242s_ard
saree55044662s_aree
sarge65531132s_arge
sari45444042s_ari
sark84938972s_ark
satara6315532satara
sate45556102s_ate
satire63218002satire
save75741362s_ave
scale74629142scale
scape96921842scape
scar66434202scar_
scarce104013632scarce
scared95227292scared
scarer84524602scarer
scares85033002scares
scarey115016982scarey
scarf105427142scarf
scarp95724102scarp
scars75433532scars
scart76139772scart
scary105222592scary
score75526732score
sear47353842sear_
seared75232842seared
searer65432022searer
sears54744912sears
sere46153472s_ere
setae56026222seta_e
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
shard96125962shard
shared105829062shared
sharer95025482sharer
shares95236412shares
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shave114425892shave
shire84727132shire
shore85432642shore
sire46150412s_ire
sitar54820542sitar_
sitars65417592sitars
skate94721542skate
slake93724052slake
slate55438282slate
slave84224032slave
smarm95517602smarm
smart75834092smart
smaze165012932smaze
snake94821112snake
snared74824552snared
snarer64620842snarer
snares65329032snares
snarf86525422snarf
snark95419942snark
snarl54921082snarl
snore55424952snore
soar46838672soar_
soared74324292soared
soarer64522242soarer
soars54732512soars
soave84219052soave
sore47059532s_ore
space95325672space
spade84423322spade
spae65034322spa_e
spake114322742spake
spale74929212spale
spar65433302spar_
spared95427482spared
sparer84524962sparer
spares84834552spares
sparge94216042sparge
spark114920892spark
spars75431542spars
sparse84516342sparse
spate74731582spate
spire75828692spire
spore75428592spore
square154513352square
stab67329932sta_b
stable83921642stable
stabs76221382stabs
stack114421692stack
stacte82113912stacte
stades74626242stades
staff113817712staff
stag57332002sta_g
staged84521562staged
stager74821342stager
stages75629492stages
stagey105915582stagey
stags66226742stags
stagy96618892stagy
staid66722072staid
staig65519632staig
stain55727932stain
stair54719932stair
stairs65416332stairs
staked114621942staked
stakes103927292stakes
staled74728102staled
staler64025822staler
stales65538292stales
stalk94518002stalk
stall54722352stall
stamen84115942stamen
stamp95217362stamp
stance84316912stance
stand65923282stand
staned74824642staned
stanes64933402stanes
stang66424682stang
stank95823302stank
stapes85028732stapes
staph104314652staph
staple84415822staple
starch113013202starch
starers74522312starers
starets73515922starets
starker114114692starker
starlet71620122starlet
starred85013452starred
starry94911672starry
started84217322started
starter73817872starter
startle72511122startle
starts65423122starts
starved114911572starved
starver104611992starver
starves104614552starves
stases64225562stases
stash84916972stash
stat47352692sta_t
stated75427832stated
stater64427552stater
states64337082states
stats55933362stats
statue66015322statue
stature74410672stature
staved103918052staved
staves94525192staves
staw78627692sta_w
stay78333722sta_y
stayed104817272stayed
stayer94516482stayer
stays86022022stays
steer55423862steer
stele55026842stele
stereo65317912stereo
steres63929532steres
stern55319122stern
stile54931572stile
stime76521792stime
stipe76523372stipe
stir45723242stir_
stirk95717412stirk
stirp76815502stirp
stirs55921612stirs
stoae55024262stoae
stoke94922512stoke
stole54928812stole
stone55431182stone
stope74727242stope
stored75524212stored
storer64721672storer
stores65533642stores
storey95217612storey
stork96819692stork
storm76520372storm
story86723032story
stoure64814942stoure
stove85220252stove
strafe95215972strafe
strake104017392strake
strap77925262strap
straw813321292straw
stray88525572stray
strep77120852st_rep
strew89220652st_rew
stupe75217752stupe
sturt56028962sturt
stye76218972st_ye
style85519362style
suave83519872suave
sucre75019102sucre
sure45447412s_ure
suture6313202suture
swage94919562swage
swale85221592swale
sward94221462sward
swarf115324652swarf
swarm106218832swarm
swart86234642swart
swore84920812swore
tace65342512_tace
tae38267052_ta_e
take84739262_take
tale46154162_tale
tame66343662_tame
tape64538142_tape
tar37570692_tar_
tared69340052_tared
tares57456562_tares
targe65227092_targe
tarn46842722_tarn
taro46846912_taro
tarp66936412_tarp
tarre55825632_tarre
tars46763952_tars
tart47566182_tart
tate44748602_tate
tire46143352_tire
tore47359322_tore
tsade64311122tsade
tsar47819802tsar_
tsars56717102tsars
tyre75428252_tyre
upstare9158682upstare
urare56322552urare
ware76254722_ware
yare75636942_yare

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 Limit538002781.65632487.9
3Display Results2782780.0763657.9
 (SQL Overall)1786912781.82597912.9
 
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.