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

195 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
snags6442131(None) 
nags55436021_nags
sags55948401s_ags
scags85520971scags
shags95123861shags
skags104316071skags
slags66525901slags
snag55827871snag_
snaps74719561snaps
snaws86116361snaws
snogs66017491snogs
snugs64913021snugs
stags66226741stags
swags94921251swags
ags47551662__ags
anas46649862ana_s
angas65827982angas
bags76645502_bags
bangs85627772bangs
brags85625102brags
clags85621122clags
crags85622572crags
dags66642602_dags
dangs75623202dangs
drags75521112drags
engs56121392en_gs
fags86939122_fags
fangs96224072fangs
flags95321282flags
frags96322172frags
gags66441062_gags
gangs76222572gangs
gnars66718852gnars
gnats65217712gnats
gnaws96311142gnaws
hags86740842_hags
hangs95726722hangs
jags126132792_jags
knaps115511172knaps
knars94416112knars
lags56546222_lags
mags75444532_mags
nabs66236192_nabs
nag46450812_nag_
nans46139402_nans
naos47429732_naos
naps66238582_naps
nays75931592_nays
negs55727362_negs
nogs56534612_nogs
pangs84628662pangs
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
sands65228582sands
sanes55649072sanes
sang55441232sang_
sanga66023792sanga
sangas75222652sangas
sangh95517452sangh
sanghs105312062sanghs
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
shads95124482shads
shag86430562shag_
shahs115919512shahs
shams105829412shams
shaws116226262shaws
shays116021432shays
shnaps1148082shnaps
shogs95319712shogs
sials54227242sials
sings65532702sings
skag96321512skag_
skas85325712ska_s
skats94621542skats
skegs105011232skegs
slabs75322642slabs
slag55934352slag_
slams74927902slams
slangs75615342slangs
slaps76025712slaps
slats55436902slats
slaws85222712slaws
slays85723682slays
slogs64521842slogs
slugs64618562slugs
smogs85112162smogs
snack114718062snack
snacks124514552snacks
snafu8412142snafu
snafus936742snafus
snaggy11488052snaggy
snail57020202snail
snails64816652snails
snake94821112snake
snakes103919602snakes
snaky125113912snaky
snap65727032sna_p
snare54429982snare
snares65329032snares
snarf86525422snarf
snarfs95113422snarfs
snark95419942snark
snarks104815732snarks
snarl54921082snarl
snarls64016872snarls
snash84815672snash
snath86419802snath
snaths95112912snaths
snaw78923072sna_w
sneaks104312492sneaks
sneaps84510862sneaps
sneds65715352sneds
snibs75613762snibs
snips75818012snips
snits54124832snits
snobs74716152snobs
snog55623632snog_
snots55225122snots
snows84719892snows
snubs75412552snubs
snug55218692snug_
snyes85012752snyes
soaks95220292soaks
soaps75120712soaps
soars54732512soars
sonars64818972sonars
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
syngas10368912syngas
tags55545232_tags
tangs65028342tangs
unais53420772unais
unaus53216572unaus
unsnags835462unsnags
vangs96319582vangs
wags86140552_wags
yags86632292_yags
yangs95618692yangs
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 Limit538001951.50035866.7
3Display Results1951950.0464239.1
 (SQL Overall)1786911951.85996122.1
 
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.