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

321 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
skas8532571(None) 
kas77058581_kas
okas85225391okas
seas45755271seas
sikas94617021sikas
ska76925861ska_
skag96321511skag
skags104316071skags
skat87037891skat
skats94621531skats
skis84825281skis
skuas95611731skuas
spas67036721spas
aas310975392_aas
abas68642082abas
agas55938842agas
alas46358122alas
amas67746292amas
anas46649862anas
as211083072__as
askos95011772askos
asks85721212ask_s
baas66844672baas
bas58681752_bas
bias64738152bias
boas66150832boas
bras65746452bras
daks97130602daks
ekes86726602ekes
eras45441502eras
eskar9457452eskar
eskars10357592eskars
etas46432272etas
eyas76427432eyas
fas68262932_fas
gas48870252_gas
goas55239942goas
has67372652_has
ikat87626642ikat
ikats95311152ikats
isbas71010392isbas
ka69145082_ka_
kaas86531842kaas
kab97145852_kab
kabs107130842_kabs
kae76744542_kae
kaes85734062_kaes
kaf106845512_kaf
kafs116423742_kafs
kakas85117342kakas
kat77468292_kat
kats85944332_kats
kay106745542_kay
kays116032192_kays
keas86337092keas
kis78051472_kis
koas85635092koas
kos76944822_kos
kvas117015942kvas
las37281472_las
leas45954182leas
mas58175812_mas
moas65545342moas
oaks86527902oaks
obas65730932obas
ocas66729632ocas
odas57230262odas
oka76926802oka_
okay115917662okay
okays12609442okays
okes84936342okes
okras94410972okras
pas58775742_pas
peas65755062peas
pias66542552pias
pikas114218092pikas
psoas75012982psoas
pyas96225702pyas
ras37575392_ras
rias45540592rias
ryas77224612ryas
sab56563202s_ab
sabs66643742sabs
sac57452862s_ac
sacs65739072sacs
sad47459202s_ad
sae38365182s_ae
sag46163402s_ag
sagas66025882sagas
sags55948402sags
sake85244962sake
sakes95540752sakes
saki85628472saki
sakis95323662sakis
sal36462882s_al
sals46851672sals
sans45153352sans
sap56463232s_ap
saps65346372saps
sash77235302s_ash
sass45035622sass
sat36288482s_at
sau36356572s_au
saw68255352s_aw
saws75839482saws
sax107447642s_ax
say67264762s_ay
says75942102says
scab85926712scab
scabs94818642scabs
scad75725762scad
scads85419952scads
scag76626892scag
scags85520972scags
scam85932352scam
scams94423972scams
scan65530452scan
scans74625102scans
scar66434202scar
scars75433532scars
scat65848372scat
scats75930602scats
sea36161292sea_
seal45654372seal
seals54839692seals
seam66645972seam
seams75731662seams
sear47353842sear
sears54744912sears
seat47575562seat
seats54844342seats
secs65033892secs
sees45361052sees
segs54933882segs
seis45542392seis
sels46345982sels
sers45746652sers
sets45549502sets
sews75836022sews
sha69837782sha_
shad86230912shad
shads95124482shads
shag86430562shag
shags95123862shags
shah105627782shah
shahs115919512shahs
sham96436352sham
shams105829412shams
shat76456592shat
shaw108132552shaw
shaws116226262shaws
shay107133342shay
shays116021432shays
sheas86331792sheas
shes75734352shes
shwas116415102shwas
sial45938832sial
sials54227242sials
sibs65933532sibs
sics65234092sics
sika86021322sika_
sikes96236082sikes
simas75727552simas
sims65737172sims
sins46755272sins
sips65740102sips
sirs44338332sirs
sis37360542s_is
sits45050202sits
skald104210172skald
skalds11437832skalds
skank84415582skank
skanks94710832skanks
skate94721542skate
skates104219392skates
skean94415622skean
skeans104512912skeans
skee85431472skee
skees95023122skees
skeg95316162skeg
skegs105011232skegs
skep105219352skep
skeps115614252skeps
skew116218762skew
skews125413802skews
ski74925682sk_i
skid95720912skid
skids104615322skids
skies95026832skies
skim105322492skim
skims114517182skims
skin85927522skin
skins94723462skins
skip105421742skip
skips115616602skips
skit85437522skit
skits94721852skits
skoal93811452skoal
skoals10438232skoals
skosh12407262skosh
skua86113152skua
sky106420992sk_y
slab67133762slab
slabs75322642slabs
slag55934352slag
slags66525902slags
slam67737972slam
slams74927902slams
slap66434042slap
slaps76025712slaps
slash84719682slash
slat46959022slat
slats55436902slats
slaw77930712slaw
slaws85222712slaws
slay76436382slay
slays85723682slays
smash104814432smash
snag55827872snag
snags64421312snags
snap65727032snap
snaps74719562snaps
snash84815672snash
snaw78923072snaw
snaws86116362snaws
soak87227662soak
soaks95220292soaks
soap65831132soap
soaps75120712soaps
soar46838672soar
soars54732512soars
sobas74424252sobas
sobs64941752sobs
socas74026182socas
sodas64123542sodas
sods54940212sods
sofas85320712sofas
sojas124716392sojas
sokes95031422sokes
sols45448162sols
somas76030372somas
soms66239372soms
sons46049552sons
sops65244562sops
soras55041012soras
sos37761602s_os
sots45552442sots
sous46947212sous
sows75342492sows
soyas84520912soyas
soys75233932soys
spa55730812spa_
spae65034322spae
spaes76029972spaes
spam85930042spam
spams94922192spams
span65234662span
spans74528732spans
spar65433302spar
spars75431542spars
spasm94514172spasm
spat66548522spat
spats75031382spats
spay96631662spay
spays105520512spays
spaz155626162spaz
sris45434152sris
stab67329932stab
stabs76221382stabs
stag57332002stag
stags66226742stags
star48037762star
stars55836572stars
stash84916972stash
stat47352692stat
stats55933362stats
staw78627692staw
stay78333722stay
stays86022022stays
stoas55126022stoas
subas74724072subas
subs66037122subs
suds56135292suds
sues46247652sues
suks85927122suks
sums65837582sums
suns45841902suns
sups64834432sups
suqs134319652suqs
suras55336322suras
suss45229302suss
swab96825312swab
swabs105817272swabs
swag87526732swag
swags94921252swags
swam96329982swam
swan76631312swan
swans84625012swans
swap95925432swap
swaps104819202swaps
swash116316752swash
swat77244442swat
swats85726862swats
sway107128232sway
sways115518462sways
sykes124816862sykes
takas95520682takas
tas38477102_tas
teas45851492teas
tsks86410662tsk_s
twas76824082twas
ukase9428492ukase
ukes86122812ukes
upas68322382upas
utas45924952utas
vas67755772_vas
was68767562_was
wekas123911792wekas
yaks116025202yaks
yeas78638422yeas
zas126946832_zas

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 Filter178691298720.0802233637.5
2DLD Change Limit298723210.92032469.6
3Display Results3213210.0804012.5
 (SQL Overall)1786913211.080165454.6
 
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.