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

482 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
shes7573435(None) 
ashes86230611ashes
hes66654201_hes
sees45361051sees
she66837691she_
shea76031571shea
sheas86331791sheas
shed86536151shed
sheds96122701sheds
shew108030761shew
shews115924711shews
shies86136551shies
shoes85429651shoes
sues46247651sues
aces67645092aces
aches106132292aches
ages55844592ages
ahed89536252ahed
ahem97225362ahem
ahis76135382ahis
ahs68644822ah_s
ales47067102ales
anes45255932anes
apes66047432apes
ares45871022ares
ashed97829772ashed
ashen87818672ashen
asses55629282asses
ates45047922ates
aves76142602aves
awes76037552awes
axes117337852axes
ayes76543512ayes
bashes115631392bashes
bees65453382bees
bes56557432_bes
boshes114721882boshes
bushes115226112bushes
byes95230532byes
cashes114729882cashes
cees65941592cees
chef125125622chef
chefs136214662chefs
chess105016922chess
chest104926142chest
chew126622132chew
chews135418512chews
chez184519022chez
chis95933312chis
coshes115022782coshes
cues65438982cues
dashes106124982dashes
dees56356632dees
dies55653522dies
dishes104622652dishes
does56554472does
dues56045502dues
dyes85331892dyes
eches106322162eches
ekes86726602ekes
emes65434662emes
es29048222__es
eses45336102eses
esnes54817362esnes
esses56422972esses
eves76230462eves
ewes76328702ewes
exes116530812exes
eyes75837882eyes
fashes124524022fashes
fees76450602fees
fehs106522382fehs
fes66551672_fes
fishes125221342fishes
foes76543442foes
gaes56348032gaes
gashes105725152gashes
gees55647882gees
ghee85726112ghee
ghees95215552ghees
ghis85020162ghis
gies55641422gies
goes55644092goes
gushes104719032gushes
haes77651022haes
has67372652_has
hashes125024802hashes
he58151952_he_
heh96039622_heh
hehs106723962_hehs
hem86148732_hem
hems95534942_hems
hen67555272_hen
hens75642572_hens
hep86644142_hep
her66547812_her
hers75844872_hers
hest75950772_hest
het67674312_het
hets75547202_hets
hew97642722_hew
hews105631572_hews
hex137436172_hex
hey96741062_hey
hies74842832hies
his66359502_his
hoes75755732hoes
hos68364192_hos
hues75235232hues
hushes124718592hushes
ices66129642ices
ides57734232ides
ires45639282ires
isles54220562isles
jees115938542jees
joes116635892joes
joshes165114852joshes
kaes85734062kaes
khet116328622khet
khets124913432khets
khis117017982khis
kues86426772kues
kyes115124932kyes
lashes94831002lashes
lees45455882lees
les35663072_les
lies46454192lies
lues45943552lues
lushes94022742lushes
lyes75530832lyes
maes66948392maes
mashes115030002mashes
meshes115019442meshes
mhos95517772mhos
moshes115222872moshes
mushes114124562mushes
noes45845392noes
noshes96618232noshes
obes66036832obes
odes57243242odes
oes35866192_oes
ohed87825182ohed
ohms95514032ohms
ohs66232312oh_s
okes84936342okes
oles46453472oles
ones46146532ones
opes65942612opes
ores46056682ores
oses46641512oses
owes75137102owes
oxes116530722oxes
oyes74940132oyes
pashes115828392pashes
pees65257372pees
pehs95625762pehs
pes57259782_pes
phew128417112phew
phis95724902phis
pies66949602pies
pishes114722102pishes
pushes114621662pushes
pyes95528992pyes
rashes95330152rashes
rees45364192rees
res35565042_res
reshes94124362reshes
rhea75017432rhea
rheas84816952rheas
rhos76319062rhos
rhus75114052rhus
roes45954132roes
rues46044482rues
rushes94724362rushes
ryes75529352ryes
sabes76437462sabes
sabs66643742sabs
sacs65739072sacs
sades65239892sades
sadhes104715372sadhes
sae38365182sae_
safes85226722safes
sages65339062sages
sags55948402sags
sakes95540752sakes
sales56055592sales
sals46851672sals
sanes55649072sanes
sans45153352sans
saps65346372saps
sashes94728482sashes
sass45035622sass
sates54949322sates
saves85838632saves
saws75839482saws
saxes125229342saxes
says75942102says
sea36161292s_ea
seas45755272seas
sec55945322s_ec
secs65033892secs
see35772262s_ee
seed55549482seed
seeds64330062seeds
seek85935482seek
seeks94724642seeks
seel45042982seel
seels55632822seels
seem65438562seem
seems75525022seems
seen46943122seen
seep66540342seep
seeps74828752seeps
seer45547042seer
seers55136382seers
seg45544882s_eg
segs54933882segs
sei36048932s_ei
seis45542392seis
sel38253322s_el
sels46345982sels
semes75731582semes
sen36058522s_en
ser36752402s_er
seres55448892seres
sers45746652sers
set36681252s_et
sets45549502sets
sew66247262s_ew
sews75836022sews
sex107043222s_ex
sexes126126222sexes
sh56828522sh__
sha69837782sh_a
shad86230912shad
shades105924532shades
shads95124482shads
shag86430562shag
shags95123862shags
shah105627782shah
shahs115919512shahs
shakes135024592shakes
shales94731252shales
sham96436352sham
shames114726222shames
shams105829412shams
shapes115124942shapes
shares95236412shares
shat76456592shat
shaves125224932shaves
shaw108132552shaw
shaws116226262shaws
shay107133342shay
shays116021432shays
sheaf115424122sheaf
sheafs124912882sheafs
sheal84927702sheal
sheals94420642sheals
shear85424832shear
shears93820902shears
sheen85023312sheen
sheens95116992sheens
sheep105321522sheep
sheer84726892sheer
sheers94322402sheers
sheesh1237812sheesh
sheet84836952sheet
sheets93918492sheets
sheik122514652sheik
sheiks132510012sheiks
shelf115221112shelf
shell84424122shell
shells94319522shells
shend94719972shend
shends105313772shends
shent85933492shent
sheol84318362sheol
sheols94614152sheols
sherd96321152sherd
sherds105614722sherds
shewn115715702shewn
shh97121072sh_h
shied96125492shied
shiel811023772shiel
shiels95418922shiels
shier85428942shier
shiers94921752shiers
shiest95821522shiest
shim95827842shim
shims104422542shims
shin75634302shin
shines95028912shines
shins85131042shins
ship95228232ship
ships105123772ships
shires95225572shires
shist84829602shist
shit76745932shit
shits84731162shits
shiv105721162shiv
shives124921412shives
shivs115018802shivs
shlep104914832shlep
shleps114710332shleps
shmo95318092shmo
shmoes114612092shmoes
shod86225052shod
shoe75933432shoe
shoed95723002shoed
shoer84722152shoer
shoers94518322shoers
shog86025132shog
shogs95319702shogs
shoo75929882shoo
shoos84226352shoos
shop95629832shop
shops104222892shops
shores94830402shores
shot76150242shot
shotes95321892shotes
shots84730832shots
shoves124919412shoves
show106229182show
shows115324572shows
shred98125612shred
shreds105613052shreds
shrew119720162shrew
shrews129313912shrews
shri76021692shri
shris84221442shris
shul75823152shul
shuls85319712shuls
shun75122772shun
shuns85018142shuns
shush113812542shush
shut76137582shut
shutes93518212shutes
shuts85622472shuts
shwa106014962shwa
shwas116415102shwas
shy96728192sh_y
shyer114714782shyer
shyers124712202shyers
shyest125511832shyest
sibs65933532sibs
sices75637272sices
sics65234092sics
sides65838362sides
sikes96236082sikes
sims65737172sims
sines55954822sines
sins46755272sins
sipes76036952sipes
sips65740102sips
sires55945372sires
sirs44338332sirs
sis37360542s_is
sises55233832sises
sites56045432sites
sits45050202sits
sixes124526362sixes
sizes146727762sizes
skas85325712skas
skee85431472skee
skees95023122skees
skeg95316162skeg
skegs105011232skegs
skep105219352skep
skeps115614252skeps
skew116218762skew
skews125413802skews
skies95026832skies
skis84825282skis
sled55334372sled
sleds64418852sleds
slew76228232slew
slews86220352slews
sloes54728872sloes
slues54527172slues
smew95017732smew
smews104612292smews
sned56026052sned
sneds65715352sneds
snyes85012752snyes
sobs64941752sobs
sods54940212sods
sokes95031422sokes
soles55547922soles
sols45448162sols
soms66239372soms
sones55444142sones
sons46049552sons
sops65244562sops
sores55454282sores
sos37761602s_os
sots45552442sots
sous46947212sous
sows75342492sows
soys75233932soys
spaes76029972spaes
spas67036722spas
spec85821972spec
specs96916672specs
sped76031492sped
spew95421872spew
spews105015922spews
spies76037622spies
spues75025382spues
sris45434152sris
stem610628242stem
stems75219952stems
step67126292step
steps76619882steps
stet45947322stet
stets55423912stets
stew77525462stew
stews85519142stews
stey76224412stey
sties55132982sties
styes86316522styes
subs66037122subs
suds56135292suds
sue35651462sue_
sued56537932sued
suer45334032suer
suers55128482suers
suet46754822suet
suets55126102suets
suks85927122suks
sums65837582sums
suns45841902suns
supes75628302supes
sups64834432sups
suqs134319652suqs
suss45229302suss
syces106416462syces
sykes124816862sykes
tees45353582tees
the67436052the_
thee78039062thee
them97427042them
then78429692then
thens85921832thens
these86519012these
thesp105410312thesp
thew108226232thew
thews117416192thews
they107223752they
this76027382this
thus76721472thus
ties45248312ties
toes46956442toes
toshes94520102toshes
tres46542902tres
tushes94319472tushes
tyes76433372tyes
ukes86122812ukes
uses44931112uses
usher84517762usher
ushers94415532ushers
utes45930882utes
vees75439432vees
vies75238622vies
voes75432822voes
waes76048602waes
washes124425492washes
wees76249122wees
whee105429592whee
when105723042when
whens114618762whens
whet105133782whet
whets115019612whets
whew137618782whew
whews145114492whews
whey135018712whey
wheys145911552wheys
whys137011662whys
wishes124920952wishes
woes76440662woes
wyes105727502wyes
yes66250612_yes
zees136331892zees

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.0931921408.6
2DLD Change Limit298724820.94031778.7
3Display Results4824820.1233918.7
 (SQL Overall)1786914821.156154577.0
 
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.