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

191 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
swags9492125(None) 
sags55948401s_ags
scags85520971scags
shags95123861shags
skags104316071skags
slags66525901slags
snags64421311snags
stags66226741stags
swabs105817271swabs
swag87526731swag_
swage94919561swage
swages104417071swages
swans84625011swans
swaps104819201swaps
swats85726861swats
sways115518461sways
swigs96213661swigs
wags86140551_wags
ags47551662__ags
bags76645502_bags
brags85625102brags
clags85621122clags
crags85622572crags
dags66642602_dags
drags75521112drags
fags86939122_fags
flags95321282flags
frags96322162frags
gags66441062_gags
hags86740842_hags
jags126132792_jags
lags56546222_lags
mags75444532_mags
nags55436022_nags
peags86122842peags
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
scrags95713802scrags
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
segs54933882s_egs
sewage10310732sewage
sewages1139752sewages
sewans95215902sewans
sewars94018622sewars
shads95124482shads
shag86430562shag_
shahs115919512shahs
shams105829412shams
shaws116226262shaws
shays116021432shays
shogs95319712shogs
shwas116415102shwa_s
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
sowans94215892sowans
sowars94318012sowars
spaes76029972spaes
spams94922192spams
spans74528732spans
spars75431542spars
spas67036722spa_s
spats75031382spats
spays105520512spays
sprags95715822sprags
stabs76221382stabs
stag57332002stag_
stage65330192stage
stages75629492stages
stagy96618892stagy
staigs75414812staigs
stangs75018162stangs
stars55836572stars
stats55933362stats
stays86022022stays
swab96825312swa_b
swaged114212252swaged
swager104013612swager
swagers114211022swagers
swail86217162swail
swails94913122swails
swain84919052swain
swains94513952swains
swale85221592swale
swales93920762swales
swam96329982swa_m
swami105614522swami
swamis114212292swamis
swamp125015322swamp
swamps135910262swamps
swamy136714402swamy
swan76631312swa_n
swang95519722swang
swank125318232swank
swanks134811562swanks
swap95925432swa_p
sward94221462sward
swards105415132swards
sware85828212sware
swarf115324652swarf
swarfs125612062swarfs
swarm106218832swarm
swarms116112172swarms
swart86234642swart
swash116316752swash
swat77244442swa_t
swath115920382swath
swaths125312642swaths
sway107128232swa_y
swears94114072swears
sweats94814612sweats
swig85818022swig_
swims105514142swims
swings104714452swings
swiss86712902swiss
swobs104910892swobs
swops105913972swops
swots85518432swots
tags55545232_tags
twaes86513662twaes
twangs10358092twangs
twas76824082twa_s
twats86616602twats
twigs96911172twigs
wabs97337232_wabs
wads87343142_wads
waes76048602_waes
wag76451752_wag_
wage84834082_wage
wages95330932_wages
wans76452272_wans
waps96642082_waps
wars78659802_wars
was68767562_wa_s
wats77555882_wats
waws106834902_waws
ways107737952_ways
wigs84931252_wigs
wogs86531402_wogs
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.0931921408.6
2DLD Change Limit538001911.67332157.8
3Display Results1911910.0464152.2
 (SQL Overall)1786911911.81298615.3
 
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.