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

247 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
shags9512386(None) 
hags86740841_hags
sags55948401s_ags
scags85520971scags
shads95124481shads
shag86430561shag_
shahs115919511shahs
shams105829411shams
shaws116226261shaws
shays116021431shays
shogs95319711shogs
skags104316071skags
slags66525901slags
snags64421311snags
stags66226741stags
swags94921251swags
ags47551662__ags
bags76645502_bags
bhangs12449662bhangs
brags85625102brags
chads116122232chads
chais107530312chais
chams126028502chams
changs125215372changs
chaos105622862chaos
chaps125326062chaps
chars105936642chars
chats105730092chats
chaws135022462chaws
chays135319742chays
chugs115511942chugs
clags85621122clags
crags85622572crags
dags66642602_dags
dhaks13479702dhaks
dhals95415442dhals
drags75521112drags
fags86939122_fags
flags95321282flags
frags96322172frags
gags66441062_gags
ghats95818612ghats
haes77651022_haes
hag77255742_hag_
hahs108333362_hahs
hams96446132_hams
hangs95726722_hangs
haps96443462_haps
has67372652_ha_s
hats76858252_hats
haws106439442_haws
hays106138072_hays
hogs87139662_hogs
hugs86129752_hugs
jags126132792_jags
khafs15648842khafs
khans124615172khans
khats125316012khats
lags56546222_lags
mags75444532_mags
nags55436022_nags
peags86122842peags
phage115113672phage
phages125213512phages
pshaws14435702pshaws
quags154613252quags
rags55448372_rags
sabs66643742s_abs
sacs65739072s_acs
sag46163402s_ag_
saga55331172s_aga
sagas66025882s_agas
sage55044592s_age
sages65339062s_ages
sago56332672s_ago
sagos66123872s_agos
sagy85327082s_agy
sals46851672s_als
sans45153362s_ans
saps65346372s_aps
sass45035622s_ass
saws75839482s_aws
says75942102s_ays
scabs94818642scabs
scads85419962scads
scag76626892scag_
scams94423972scams
scans74625102scans
scars75433532scars
scats75930602scats
schavs1436492schavs
scrags95713802scrags
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
segs54933882s_egs
sha69837782sha__
shack145321752shack
shacks154817562shacks
shad86230912sha_d
shade95125582shade
shades105924532shades
shady125416512shady
shaft115725272shaft
shafts125411442shafts
shaggy14478042shaggy
shah105627782sha_h
shake124726402shake
shakes135024592shakes
shako125516092shako
shakos134912192shakos
shaky154616842shaky
shale85332832shale
shales94731252shales
shall85024052shall
shalt85534492shalt
shaly114322862shaly
sham96436362sha_m
shamas113717942shamas
shame105726702shame
shames114726222shames
shamos114216982shamos
shamus114112812shamus
shank125422192shank
shanks135315582shanks
shape105125112shape
shapes115124952shapes
shard96125962shard
shards104319172shards
share86437082share
shares95236412shares
shark126225022shark
sharks135019722sharks
sharn84823702sharn
sharns95516982sharns
sharp104922532sharp
sharps115516082sharps
shat76456602sha_t
shaugh13287432shaugh
shaughs14245282shaughs
shaul85418102shaul
shauls94913112shauls
shave114425892shave
shaves125224932shaves
shaw108132552sha_w
shawl116217572shawl
shawls125411972shawls
shawm135316152shawm
shawms14579562shawms
shawn116417612shawn
shay107133342sha_y
sheafs124912882sheafs
sheals94420642sheals
shears93820902shears
sheas86331792sheas
sheds96122702sheds
shes75734352sh_es
shews115924712shews
shies86136552shies
shims104422552shims
shins85131042shins
ships105123772ships
shits84731172shits
shivs115018802shivs
shnaps1148082shnaps
shoals94215792shoals
shoats94117082shoats
shoes85429662shoes
shog86025142shog_
shogi95014012shogi
shogis103810942shogis
shoos84226362shoos
shops104222902shops
shots84730852shots
shows115324582shows
shris84221452shris
shrugs10469162shrugs
shuls85319712shuls
shuns85018142shuns
shuts85622482shuts
shwas116415102shwas
sials54227242sials
sings65532702sings
skag96321512skag_
skas85325712ska_s
skats94621542skats
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
stabs76221382stabs
stag57332002stag_
stage65330192stage
stages75629492stages
stagy96618892stagy
staigs75414812staigs
stangs75018162stangs
stars55836572stars
stats55933362stats
stays86022022stays
swabs105817272swabs
swag87526732swag_
swage94919562swage
swages104417072swages
swans84625012swans
swaps104819202swaps
swats85726862swats
sways115518462sways
swigs96213662swigs
tags55545232_tags
thaws116515462thaws
thugs95611992thugs
wags86140552_wags
whams135515642whams
whangs13439722whangs
whaps135115162whaps
whats117718992whats
whigs125612642whigs
yags86632292_yags
zags146826682_zags

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.313570897.8
2DLD Change Limit538002471.39038705.0
3Display Results2472470.0633920.6
 (SQL Overall)1786912471.766101184.0
 
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.