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

233 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
stags6622674(None) 
sags55948401s_ags
scags85520971scags
shags95123861shags
skags104316071skags
slags66525901slags
snags64421311snags
stabs76221381stabs
stag57332001stag_
stage65330191stage
stages75629491stages
stagy96618891stagy
staigs75414811staigs
stangs75018161stangs
stars55836571stars
stats55933361stats
stays86022021stays
swags94921251swags
tags55545231_tags
ags47551662__ags
ataps76414832ataps
bags76645502_bags
brags85625102brags
clags85621122clags
crags85622572crags
dags66642592_dags
drags75521112drags
etas46432272eta_s
fags86939122_fags
flags95321282flags
frags96322162frags
gags66441062_gags
hags86740842_hags
jags126132792_jags
lags56546222_lags
mags75444522_mags
nags55436022_nags
peags86122842peags
quags154613252quags
rags55448372_rags
retags73414302retags
sabs66643742s_abs
sacs65739072s_acs
sag46163402s_ag_
saga55331172s_aga
sagas66025882s_agas
sage55044592s_age
sages65339062s_ages
sago56332672s_ago
sagos66123872s_agos
sagy85327082s_agy
sals46851672s_als
sans45153352s_ans
saps65346372s_aps
sass45035622s_ass
satangs8479712satangs
satays94411682satays
sates54949322sates
satis55633672satis
saws75839482s_aws
says75942102s_ays
scabs94818642scabs
scads85419952scads
scag76626892scag_
scams94423972scams
scans74625102scans
scars75433532scars
scats75930602scats
scrags95713802scrags
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
segs54933882s_egs
shads95124482shads
shag86430562shag_
shahs115919512shahs
shams105829412shams
shaws116226262shaws
shays116021432shays
shogs95319702shogs
sials54227242sials
sings65532702sings
sitars65417592sitars
skag96321512skag_
skas85325712ska_s
skats94621532skats
skegs105011232skegs
slabs75322642slabs
slag55934352slag_
slams74927902slams
slangs75615342slangs
slaps76025712slaps
slats55436902slats
slaws85222712slaws
slays85723682slays
slogs64521842slogs
slugs64618562slugs
smogs85112162smogs
snag55827872snag_
snaps74719562snaps
snaws86116362snaws
snogs66017492snogs
snugs64913022snugs
soaks95220292soaks
soaps75120712soaps
soars54732512soars
songs67725552songs
spaes76029972spaes
spams94922192spams
spans74528732spans
spars75431542spars
spas67036722spa_s
spats75031382spats
spays105520512spays
sprags95715822sprags
stab67329932sta_b
stack114421692stack
stacks124317262stacks
stade64825302stade
stades74626242stades
staff113817712staff
staffs12349752staffs
staged84521562staged
stager74821342stager
stagers84116672stagers
stagey105915582stagey
staggy115510392staggy
staid66722072staid
staig65519632staig
stain55727932stain
stains64923652stains
stair54719932stair
stairs65416332stairs
stake95927532stake
stakes103927292stakes
stalags838642stalags
stale55637102stale
stales65538292stales
stalk94518002stalk
stalks104614552stalks
stall54722352stall
stalls64019922stalls
stamp95217362stamp
stamps105614022stamps
stand65923282stand
stands75118052stands
stane55933002stane
stanes64933402stanes
stang66424682stang
stank95823302stank
stanks104917702stanks
stapes85028732stapes
staph104314652staph
staphs114411032staphs
star48037762sta_r
stare54440262stare
stares66038752stares
stark95425622stark
start55642312start
starts65423122starts
stases64225562stases
stash84916972stash
stasis63116872stasis
stat47352692sta_t
state56237332state
states64337082states
status65515212status
stave85324992stave
staves94525192staves
staw78627692sta_w
stay78333722sta_y
steads74116222steads
steaks104415852steaks
steals64020062steals
steams84916902steams
stems75219952stems
steps76619882steps
stets55423912stets
stews85519142stews
sties55132982sties
stings76220182stings
stirs55921612stirs
stoas55126022stoas
stoats65117482stoats
stobs75718232stobs
stogy95414082stogy
stops74827282stops
stoss54316342stoss
stots54828542stots
stows86622702stows
straps87721782straps
strass67117222strass
straws98718672straws
strays96417932strays
stubs75016072stubs
studs64415872studs
stums75320082stums
stuns54719492stuns
styes86316522styes
swabs105817272swabs
swag87526732swag_
swage94919562swage
swages104417072swages
swans84625012swans
swaps104819202swaps
swats85726862swats
sways115518462sways
swigs96213662swigs
tabs66842982_tabs
tads57143942_tads
tag47259492_tag_
tams67247932_tams
tangs65028342_tangs
tans46154812_tans
taos45541002_taos
taps66050672_taps
tars46763952_tars
tas38477102_ta_s
tass45640572_tass
tats46858132_tats
taus46342732_taus
tavs75630972_tavs
taws75641592_taws
tegs56031492_tegs
togs57242432_togs
tsars56717102tsars
tugs56231672_tugs
utas45924952uta_s
wags86140552_wags
yags86632292_yags
zags146826682_zags

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.0931921408.6
2DLD Change Limit538002331.87628678.0
3Display Results2332330.0763065.8
 (SQL Overall)1786912332.04587379.5
 
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.