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

283 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
sloe4553495(None) 
aloe45540191aloe
floe76129771floe
shoe75933431shoe
slob66029421slob
sloes54728871sloes
slog56728271slog
slop66533871slop
slope75823561slope
slot46049821slot
slow77729491slow
slue45332191slue
sole46053671sole
alae45643752alae
ale36572342al_e
alee46652322alee
alme65832162alme
aloes54933672aloes
alone55732962alone
alow75328592alow
aslope839012aslope
blae66134642blae
blob86027092blob
bloc85023272bloc
blog75723822blog
bloke114316632bloke
blot65842322blot
blow95827192blow
blue65328462blue
bole66448692bole
clod76124612clod
clog76123242clog
clon66232482clon
clone75728162clone
clop86929892clop
close76425222close
clot66542422clot
clove105619442clove
cloy96623832cloy
cloze165517542cloze
clue65324532clue
cole66956112cole
doe47361952_doe
dole56550002dole
elope75219342elope
else45923082else
flee76238792flee
floc95922122floc
floes85528142floes
flog85523892flog
flop96925452flop
flow105924922flow
flue75329852flue
foe66350812_foe
froe75329992froe
glee55239062glee
glob76623392glob
globe84917012globe
glom75424382glom
glop76724632glop
glove94516292glove
glow85222522glow
gloze154815982gloze
glue55628492glue
hoe67562722_hoe
hole77553392hole
isle45121702isl_e
joe106642352_joe
jole117233822jole
lee36068142_lee
lie38264522_lie
lo28053442_lo_
lob57154462_lob
lobe65535362_lobe
lode56240112_lode
log46252682_log
loge56837192_loge
lone45849132_lone
loo38359822_loo
lop58255312_lop
lope65941922_lope
lore45850352_lore
lose45144582_lose
lot38179262_lot
love75234762_love
low66051872_low
lowe75435312_lowe
lox108240962_lox
lye66533412_lye
mole66251832mole
oboe66822942oboe
oe28473062__oe
ole37155212ol_e
oleo46630482oleo
plie65127392plie
plod76723272plod
plop86625742plop
plot66141232plot
plow95923232plow
ploy96123602ploy
pole65951302pole
roe36861072_roe
role45851822role
sabe66140572sabe
sade55544472sade
sae38365182s_ae
safe75930952safe
sage55044592sage
sake85244962sake
sale44959702sale
salol55222142salol
salon55228552salon
salve85022132salve
same65245642same
sane45954332sane
sate45556102sate
save75741362save
scone74621832scone
scop85925522scop
scope94821482scope
score75526732score
scot66242602scot
scow96021422scow
see35772262s_ee
selle54428312selle
seme65836652seme
sene46848052sene
sere46153472sere
she66837692s_he
shod86225052shod
shoed95723002shoed
shoer84722152shoer
shoes85429652shoes
shog86025132shog
shone83725972shone
shoo75929882shoo
shop95629832shop
shore85432642shore
shot76150242shot
shote85526082shote
shove114421032shove
show106229182show
sice65545592sice
side55444482side
sike87138782sike
silo46037912silo_
siloed74615302siloed
silos56029422silos
sine46560622sine
sipe67341042sipe
sire46150412sire
site47052412site
size135630962size
skee85431472skee
slab67133762slab
slag55934352slag
slake93724052slake
slam67737972slam
slap66434042slap
slat46959022slat
slate55438282slate
slave84224032slave
slaw77930712slaw
slay76436382slay
sled55334372sled
sleek94619042sleek
sleep74920182sleep
sleet55639132sleet
slew76228232slew
slice74925822slice
slid55828982slid
slide64725412slide
slier54827242slier
slim66631952slim
slime74925752slime
slip67031732slip
slipe75626132slipe
slit46250102slit
slobs74419872slobs
slogs64521842slogs
sloid64619692sloid
slojd13378842slojd
sloop76118912sloop
sloped94216852sloped
sloper84615912sloper
slopes84820452slopes
slops75026012slops
slosh84514482slosh
sloth85019442sloth
slots54830522slots
sloven9389632sloven
slowed104617072slowed
slower94016152slower
slows85323462slows
sloyd9409682sloyd
slub65428032slub
slued64220512slued
slues54527172slues
slug55124642slug
slum65430512slum
slur45525152slur
slut45040592slut
sly66228562sl_y
slyer85515122slyer
slype105112362slype
smog76317412smog
smoke115015822smoke
smote75820272smote
snob65825592snob
snog55623632snog
snore55424952snore
snot44745442snot
snow76324792snow
snye77115492snye
so28855442s_o_
sob57857942s_ob
sod46053702s_od
soke85436262soke
sol37256622s_ol
sola45541862sola
sold54837412sold
soled65835172soled
solei55624332solei
soles55547922soles
soli46637002soli
solo45538942solo
soloed74515742soloed
solon55026132solon
solos54830792solos
sols45448162sols
solve85618942solve
som59153802s_om
some66040382some
son37761952s_on
sone46649982sone
sooey84522432sooey
sook84933392sook
soon46240502soon
soot45761052soot
sop57557862s_op
sore47059532sore
sos37761602s_os
sot310384292s_ot
sou37853692s_ou
sow66554762s_ow
sox106444192s_ox
soy67851452s_oy
spae65034322spae
splore81611302splore
spode84617702spode
spoke114818662spoke
spore75428592spore
spot65540682spot
spue66025522spue
stoa45425912stoa
stoae55024262stoae
stob66724612stob
stoke94922512stoke
stole54928812stole
stone55431182stone
stop66532032stop
stope74727242stope
store56333812store
stot46347322stot
stove85220252stove
stow77325742stow
stye76218972stye
sue35651462s_ue
supe65932762supe
sure45447412sure
swob95218632swob
swop95120502swop
swore84920812swore
swot75134652swot
syce95820282syce
syke115420562syke
syne75725762syne
toe310166852_toe
tole46052902tole
voe67739052_voe
vole75236982vole
woe66651242_woe
zlote143912942zlote

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 Filter178691298720.0762351197.4
2DLD Change Limit298722831.90615672.6
3Display Results2832830.1232300.8
 (SQL Overall)1786912832.10584888.8
 
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.