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

160 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
skags10431607(None) 
sags55948401s_ags
scags85520971scags
shags95123861shags
skag96321511skag_
skas85325711ska_s
skats94621541skats
skegs105011231skegs
slags66525901slags
snags64421311snags
stags66226741stags
swags94921251swags
ags47551662__ags
bags76645502_bags
brags85625102brags
clags85621122clags
crags85622572crags
dags66642602_dags
drags75521112drags
eskars10357592eskars
fags86939122_fags
flags95321282flags
frags96322172frags
gags66441062_gags
hags86740842_hags
ikats95311152ikats
jags126132792_jags
kaas86531842_kaas
kabs107130842_kabs
kaes85734062_kaes
kafs116423742_kafs
kagu95418112_kagu
kagus105812032_kagus
kas77058582_ka_s
kats85944332_kats
kays116032192_kays
kegs95824022_kegs
lags56546222_lags
mags75444532_mags
nags55436022_nags
okas85225392oka_s
okays12609442okays
peags86122842peags
quags154613252quags
rags55448372_rags
sabs66643742s_abs
sacs65739072s_acs
sag46163402s_ag_
saga55331172s_aga
sagas66025882s_agas
sage55044592s_age
sages65339062s_ages
sago56332672s_ago
sagos66123872s_agos
sagy85327082s_agy
sakes95540752sakes
sakis95323672sakis
sals46851672s_als
sans45153362s_ans
saps65346372s_aps
sass45035622s_ass
saws75839482s_aws
says75942102s_ays
scabs94818642scabs
scads85419962scads
scag76626892scag_
scams94423972scams
scans74625102scans
scars75433532scars
scats75930602scats
scrags95713802scrags
seals54839702seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
segs54933882s_egs
shads95124482shads
shag86430562shag_
shahs115919512shahs
shams105829412shams
shaws116226262shaws
shays116021432shays
shogs95319712shogs
sials54227242sials
sikas94617022sika_s
sings65532702sings
ska76925862ska__
skald104210172skald
skalds11437832skalds
skank84415582skank
skanks94710832skanks
skat87037902ska_t
skate94721552skate
skates104219402skates
skeans104512912skeans
skees95023122skees
skeg95316162skeg_
skeps115614252skeps
skews125413802skews
skids104615332skids
skies95026832skies
skims114517192skims
skins94723462skins
skips115616602skips
skis84825292sk_is
skits94721862skits
skoals10438242skoals
skuas95611732skuas
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
stangs75018172stangs
stars55836572stars
stats55933362stats
stays86022022stays
swabs105817272swabs
swag87526732swag_
swage94919562swage
swages104417072swages
swans84625012swans
swaps104819202swaps
swats85726862swats
sways115518462sways
swigs96213662swigs
tags55545242_tags
wags86140552_wags
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 Limit538001601.40638264.6
3Display Results1601600.0463478.3
 (SQL Overall)1786911601.765101241.4
 
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.