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

239 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
stane5593300(None) 
sane45954341s_ane
stade64825301stade
stage65330191stage
stake95927531stake
stale55637101stale
stance84316911stance
stand65923281stand
staned74824641staned
stanes64933401stanes
stang66424691stang
stank95823301stank
stare54440261stare
state56237331state
stave85324991stave
stone55431181stone
alane56135612alane
ane37866952__ane
atone56527982atone
bane65250432_bane
butane8313652butane
cane66653122_cane
cetane8315282cetane
crane75331602crane
estate64719762estate
etape74413702etape
ethane94613242ethane
fane75343572_fane
gane55145302_gane
inane52820342inane
jane115031482_jane
kane85133982_kane
lane45153332_lane
liane54720662liane
mane65052032_mane
octane81411632octane
pane64950292_pane
plane74929142plane
sabe66140572s_abe
sade55544482s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sale44959702s_ale
same65245642s_ame
sand55338472s_and
saned65636272s_aned
saner54334322s_aner
sanes55649072s_anes
sang55441242s_ang
sank85236832s_ank
sans45153362s_ans
satang75711562satang
sate45556102s_ate
save75741362s_ave
scale74629142scale
scan65530452scan_
scans74625102scans
scant79735072scant
scape96921842scape
scare75334462scare
scene77220572scene
scone74621832scone
seance83716692seance
seine55732872seine
sene46848052s_ene
setae56026222seta_e
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shank125422192shank
shape105125112shape
share86437082share
shave114425892shave
shine85533092shine
shone83725982shone
silane62718052silane
sine46560632s_ine
skank84415582skank
skate94721552skate
skeane104611372skeane
skene96118122skene
slake93724052slake
slang66324022slang
slank95822772slank
slant55238702slant
slate55438282slate
slave84224032slave
smaze165012932smaze
snake94821112snake
snare54429982snare
soave84219052soave
sone46649982s_one
soutane7312062soutane
space95325672space
spade84423322spade
spae65034322spa_e
spake114322742spake
spale74929212spale
span65234662span_
spang84919732spang
spank115919572spank
spans74528732spans
spare75135562spare
spate74731582spate
spine76534422spine
stab67329932sta_b
stable83921642stable
stabs76221382stabs
stack114421692stack
stacte82113912stacte
stades74626242stades
staff113817712staff
stag57332002sta_g
staged84521562staged
stager74821342stager
stages75629492stages
stagey105915582stagey
stags66226742stags
stagy96618892stagy
staid66722082staid
staig65519642staig
stain55727942stain
stained84215342stained
stainer73614922stainer
stains64923652stains
stair54719942stair
staked114621942staked
stakes103927292stakes
staled74728102staled
staler64025822staler
stales65538292stales
stalk94518002stalk
stall54722352stall
stamen84115942stamen
stamp95217362stamp
stances93715962stances
stanch113812372stanch
standee83514512standee
stander84316162stander
stands75118052stands
stanged94113852stanged
stangs75018172stangs
stanine73417072stanine
stanks104917702stanks
stanol6310722stanol
stanza1537072stanza
stapes85028732stapes
staph104314652staph
staple84415822staple
star48037762sta_r
stared75429872stared
starer64027362starer
stares66038752stares
stark95425622stark
stars55836572stars
start55642312start
starve94613742starve
stases64225562stases
stash84916972stash
stat47352692sta_t
stated75427832stated
stater64427562stater
states64337082states
stats55933362stats
statue66015322statue
staved103918052staved
staves94525192staves
staw78627692sta_w
stay78333722sta_y
stayed104817272stayed
stayer94516482stayer
stays86022022stays
stele55026842stele
steno54716862steno
stent55634512stent
stere55328542stere
stile54931572stile
stime76521802stime
sting65330242sting
stink95122502stink
stint57037662stint
stipe76523372stipe
stoae55024262stoae
stoke94922512stoke
stole54928812stole
stoned75923142stoned
stoner65823202stoner
stones65130032stones
stoney96217352stoney
stony85818642stony
stope74727242stope
store56333812store
stove85220252stove
strafe95215982strafe
strake104017392strake
strand74514822strand
strang75718312strang
strange85416342strange
stun45623452stun_
stung65417152stung
stunk94616292stunk
stuns54719492stuns
stunt55328172stunt
stupe75217752stupe
stye76218972st_ye
style85519362style
suave83519872suave
swage94919562swage
swale85221592swale
swan76631312swan_
swang95519722swang
swank125318232swank
swans84625012swans
sware85828212sware
swine85625302swine
syne75725762s_yne
tace65342512_tace
tae38267052_ta_e
take84739262_take
tale46154162_tale
tame66343662_tame
tan37167582_tan_
tang56138692_tang
tank85134032_tank
tans46154832_tans
tape64538152_tape
tare45957622_tare
tate44748602_tate
thane86122532thane
tine45855142_tine
tone46953742_tone
tsade64311122tsade
tune45635862_tune
tyne76325052_tyne
vane75534692_vane
wane76344722_wane

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.296603685.8
2DLD Change Limit538002391.54634799.5
3Display Results2392390.0763144.7
 (SQL Overall)1786912391.91893165.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.