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

296 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
sloes5472887(None) 
aloes54933671aloes
floes85528141floes
shoes85429651shoes
slobs74419871slobs
sloe45534951sloe_
slogs64521841slogs
slopes84820451slopes
slops75026011slops
slots54830521slots
slows85323461slows
slues54527171slues
soles55547921soles
ales47067102al_es
almes75126542almes
aloe45540192aloe_
blobs95620032blobs
blocs95219652blocs
blogs85319232blogs
blokes123813882blokes
blots75626172blots
blows105423832blows
blues75127042blues
boles75448602boles
clods85320862clods
clogs85519552clogs
clones84526562clones
clons75228132clons
clops95924852clops
close76425222close
closes85425592closes
clots75627642clots
cloves114918822cloves
cloys104916942cloys
clozes174915562clozes
clues74623032clues
coles76055062coles
does56554472_does
doles67843752doles
elopes85918162elopes
elves85118742elves
flees85828752flees
flies85630712flies
flocs105519232flocs
floe76129772floe_
flogs95919962flogs
flops105920142flops
floss85118262floss
flows115822362flows
flues84626922flues
foes76543442_foes
froes86126692froes
glees65027592glees
globes94314542globes
globs85616402globs
gloms85219782gloms
glops85619552glops
gloss64319622gloss
gloves104115182gloves
glows95518032glows
glozes164313352glozes
glues65125682glues
goes55644092_goes
haloes94623862haloes
hoes75755732_hoes
holes84748652holes
isles54220562isl_es
joes116635892_joes
joles125230832joles
lees45455882_lees
les35663072_l_es
lies46454192_lies
lobes75331002_lobes
lobs66441082_lobs
lodes66436912_lodes
loess55714702_loess
loges66534202_loges
logs57343112_logs
loos49051122_loos
lopes76437342_lopes
lops66043352_lops
lores55045402_lores
lose45144582_lose
loses56742012_loses
loss45337962_loss
lots47652092_lots
loves85332012_loves
lowes85732462_lowes
lows75843012_lows
loxes125227472_loxes
lues45943552_lues
lyes75530832_lyes
moles74747922moles
noes45845392_noes
oboes75717712oboes
oes35866192__oes
oleos55419682oleos
oles46453472ol_es
plies74526512plies
plods85719292plods
plops95920332plops
plots75025672plots
plows105419902plows
ploys105816592ploys
poles75351002poles
roes45954132_roes
roles56747982roles
sabes76437462sabes
sades65239892sades
safes85226722safes
sages65339062sages
sakes95540752sakes
sales56055592sales
salols64017872salols
salons63823682salons
salves94221762salves
salvoes102811312salvoes
sanes55649072sanes
sates54949322sates
saves85838632saves
saxes125229342saxes
scones84521302scones
scopes104719592scopes
scops95820192scops
scores84725922scores
scots74025902scots
scows106617802scows
sees45361052s_ees
selles64426982selles
selves94119612selves
semes75731582semes
seres55448892seres
sexes126126222sexes
shes75734352s_hes
shies86136552shies
shmoes114612092shmoes
shoe75933432shoe_
shoed95723002shoed
shoer84722152shoer
shoers94518322shoers
shogs95319702shogs
shoos84226352shoos
shops104222892shops
shores94830402shores
shotes95321892shotes
shots84730832shots
shoves124919412shoves
shows115324572shows
sices75637272sices
sides65838362sides
sikes96236082sikes
siloed74615302siloed
silos56029422silo_s
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
skees95023122skees
skies95026832skies
slabs75322642slabs
slags66525902slags
slakes104021882slakes
slams74927902slams
slaps76025712slaps
slates64934062slates
slats55436902slats
slaves95023022slaves
slaws85222712slaws
slays85723682slays
sled55334372sl_ed
sleds64418852sleds
sleek94619042sleek
sleeks104512462sleeks
sleep74920182sleep
sleeps83913322sleeps
sleet55639132sleet
sleets64318872sleets
slew76228232sl_ew
slews86220352slews
slices84022852slices
slides73922182slides
slier54827242slier
sliest66621942sliest
slimes84722042slimes
slims75423652slims
slipes84921412slipes
slips76023722slips
slits56128852slits
slob66029422slo_b
slog56728272slo_g
sloid64619692sloid
sloids73712692sloids
slojd13378842slojd
slojds14345472slojds
sloop76118912sloop
sloops85513622sloops
slop66533872slo_p
slope75823562slope
sloped94216852sloped
sloper84615912sloper
slopers94213092slopers
slosh84514482slosh
sloshes103811802sloshes
slot46049822slo_t
sloth85019442sloth
sloths94911882sloths
sloven9389632sloven
slovens10316572slovens
slow77729492slo_w
slowed104617072slowed
slower94016152slower
slowest10168712slowest
sloyd9409682sloyd
sloyds10346292sloyds
slubs74719532slubs
slue45332192slue_
slued64220512slued
slugs64618562slugs
slums74623432slums
slurs54123372slurs
sluts54523982sluts
slyer85515122slyer
slyest93811362slyest
slypes114410482slypes
smogs85112162smogs
smokes124814342smokes
snobs74716152snobs
snogs66017492snogs
snores64324312snores
snots55225102snots
snows84719882snows
snyes85012752snyes
sobs64941752s_obs
sods54940212s_ods
sokes95031422sokes
sole46053672sole_
soled65835172soled
solei55624332solei
soleus64615612soleus
soloed74515742soloed
solons65120012solons
solos54830792solos
sols45448162s_ols
solus54726982solus
solves95018222solves
soms66239372s_oms
sones55444142sones
sons46049552s_ons
sooey84522432sooey
sooks94425452sooks
soots55536202soots
sops65244562s_ops
sores55454282sores
sos37761602s_o_s
sots45552442s_ots
sous46947212s_ous
sows75342492s_ows
soys75233932s_oys
spaes76029972spaes
spies76037622spies
splores91910942splores
spodes94817432spodes
spokes124417212spokes
spores84726612spores
spots74424102spots
spues75025382spues
sties55132982sties
stoas55126022stoas
stobs75718232stobs
stokes104821792stokes
stoles63927672stoles
stones65130032stones
stopes84525892stopes
stops74827282stops
stores65533642stores
stoss54316342stoss
stots54828542stots
stoves93818922stoves
stows86622702stows
styes86316522styes
sues46247652s_ues
supes75628302supes
swobs104910892swobs
swops105913972swops
swots85518422swots
syboes1139342syboes
syces106416462syces
sykes124816862sykes
toes46956442_toes
toles55147132toles
voes75432822_voes
voles86234042voles
woes76440662_woes

Search took 3 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 Limit538002962.11025497.6
3Display Results2962960.1102690.9
 (SQL Overall)1786912962.31377255.1
 
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.