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

220 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
stays8602202(None) 
satays94411681satays
says75942101s_ays
shays116021431shays
slays85723681slays
spays105520511spays
stabs76221381stabs
stags66226741stags
stars55836571stars
stats55933361stats
stay78333721stay_
strays96417931strays
sways115518461sways
assays977902assays
ataps76414832ataps
ays67050292__ays
bays97143912_bays
brays106723112brays
cays95437672_cays
chays135319742chays
clays105521332clays
days87637132_days
drays95819772drays
essays965652essays
estrays10529402estrays
etas46432272eta_s
fays108535362_fays
flays116321052flays
frays116920102frays
gays87338022_gays
grays95621332grays
hays106138072_hays
jays146328342_jays
kays116032192_kays
lays76043252_lays
mays96940032_mays
nays75931592_nays
ofays11488922ofays
okays12609442okays
pays95940222_pays
plays106320772plays
prays105022432prays
quays174612042quays
rays77642352_rays
sabs66643742s_abs
sacs65739072s_acs
sags55948402s_ags
sals46851672s_als
sans45153362s_ans
saps65346372s_aps
sass45035622s_ass
satay84718462satay_
sates54949322sates
satis55633682satis
satyr848482satyr
satyrs937962satyrs
saws75839482s_aws
say67264762s_ay_
sayst85322002s_ayst
scabs94818642scabs
scads85419962scads
scags85520972scags
scams94423972scams
scans74625102scans
scars75433532scars
scats75930602scats
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
shads95124482shads
shags95123862shags
shahs115919512shahs
shams105829412shams
shaws116226262shaws
shay107133342shay_
sials54227242sials
sitars65417592sitars
skags104316072skags
skas85325712ska_s
skats94621542skats
slabs75322642slabs
slags66525902slags
slams74927902slams
slaps76025712slaps
slats55436902slats
slaws85222712slaws
slay76436382slay_
snags64421312snags
snaps74719562snaps
snaws86116362snaws
soaks95220292soaks
soaps75120712soaps
soars54732512soars
soyas84520912soyas
soys75233932s_oys
spaes76029972spaes
spams94922192spams
spans74528732spans
spars75431542spars
spas67036722spa_s
spats75031382spats
spay96631662spay_
splays114910872splays
sprays115913642sprays
stab67329932sta_b
stack114421692stack
stacks124317262stacks
stade64825302stade
stades74626242stades
staff113817712staff
staffs12349752staffs
stag57332002sta_g
stage65330192stage
stages75629492stages
stagy96618892stagy
staid66722082staid
staig65519642staig
staigs75414812staigs
stain55727942stain
stains64923652stains
stair54719942stair
stairs65416332stairs
stake95927532stake
stakes103927292stakes
stale55637102stale
stales65538292stales
stalk94518002stalk
stalks104614552stalks
stall54722352stall
stalls64019932stalls
stamp95217362stamp
stamps105614022stamps
stand65923282stand
stands75118052stands
stane55933002stane
stanes64933402stanes
stang66424682stang
stangs75018162stangs
stank95823302stank
stanks104917702stanks
stapes85028732stapes
staph104314652staph
staphs114411032staphs
star48037762sta_r
stare54440262stare
stares66038752stares
stark95425622stark
start55642312start
starts65423122starts
stases64225562stases
stash84916972stash
stasis63116872stasis
stat47352692sta_t
state56237332state
states64337082states
status65515212status
stave85324992stave
staves94525192staves
staw78627692sta_w
stayed104817272stayed
stayer94516482stayer
stayers103813632stayers
steads74116222steads
steaks104415852steaks
steals64020062steals
steams84916902steams
stems75219952stems
steps76619882steps
stets55423912stets
stews85519142stews
stey76224412stey_
sties55132982sties
stirs55921622stirs
stoas55126022stoas
stoats65117482stoats
stobs75718232stobs
stops74827282stops
stoss54316342stoss
stots54828552stots
stows86622702stows
straps87721782straps
strass67117222strass
straws98718672straws
stray88525572stray_
stroys95914602stroys
stubs75016072stubs
studs64415872studs
stums75320082stums
stuns54719492stuns
sty66227312st_y_
stye76218972st_ye
styes86316522styes
swabs105817272swabs
swags94921252swags
swans84625012swans
swaps104819202swaps
swats85726862swats
sway107128232sway_
tabs66842982_tabs
tads57143942_tads
tags55545232_tags
tams67247932_tams
tans46154822_tans
taos45541002_taos
taps66050672_taps
tars46763952_tars
tas38477102_ta_s
tass45640572_tass
tats46858132_tats
taus46342732_taus
tavs75630972_tavs
taws75641592_taws
toys78036342_toys
trays85623432trays
tsars56717112tsars
utas45924952uta_s
ways107737952_ways
yays105728912_yays

Search took 3 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.326548131.9
2DLD Change Limit538002201.61033416.1
3Display Results2202200.0633492.1
 (SQL Overall)1786912201.99989390.2
 
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.