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

291 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
shoes8542966(None) 
hoes75755731_hoes
shes75734351sh_es
shies86136551shies
shmoes114612101shmoes
shoe75933441shoe_
shoed95723011shoed
shoer84722161shoer
shoers94518331shoers
shogs95319711shogs
shoos84226361shoos
shops104222901shops
shores94830411shores
shotes95321911shotes
shots84730851shots
shoves124919421shoves
shows115324581shows
sloes54728871sloes
aloes54933672aloes
ashes86230612ash_es
chokes154917382chokes
chops125019872chops
chores114828022chores
chose105925402chose
choses115825132choses
chows135618202chows
dholes104914792dholes
dhows125911222dhows
does56554472_does
echoes114715522echoes
floes85528142floes
foes76543442_foes
froes86126692froes
ghees95215552ghees
goes55644092_goes
haes77651022_haes
hes66654202_h_es
hies74842832_hies
hobs97038982_hobs
hods87239862_hods
hoe67562722_hoe_
hoed87837982_hoed
hoer76533982_hoer
hoers85724922_hoers
hogs87139662_hogs
hokes126231642_hokes
holes84748652_holes
hols76946292_hols
homes106938822_homes
hones88144492_hones
hons77350782_hons
hopes105835642_hopes
hops97942632_hops
hos68364192_ho_s
hose76547242_hose
hoses85443182_hoses
hots78349332_hots
howes114730262_howes
hows106345602_hows
hoys107733932_hoys
hues75235232_hues
joes116635892_joes
mahoes11313102mahoes
mhos95517772mho_s
noes45845392_noes
oboes75717712oboes
oes35866192__oes
phones114121212phones
phons105221142phons
phots105418502phots
reshoes102316032reshoes
rhos76319062rho_s
roes45954142_roes
sabes76437462sabes
sades65239892sades
safes85226722safes
sages65339062sages
sakes95540752sakes
sales56055592sales
sanes55649072sanes
sates54949322sates
saves85838632saves
saxes125229342saxes
schmoes14308542schmoes
scones84521302scones
scopes104719592scopes
scops95820192scops
scores84725922scores
scots74025912scots
scows106617802scows
sees45361052s_ees
semes75731582semes
seres55448892seres
sexes126126222sexes
shades105924532shades
shads95124482shads
shags95123862shags
shahs115919512shahs
shakes135024592shakes
shakoes144510022shakoes
shales94731252shales
shames114726222shames
shams105829412shams
shapes115124952shapes
shares95236412shares
shaves125224932shaves
shaws116226262shaws
shays116021432shays
she66837692sh_e_
shea76031572sh_ea
sheas86331792sheas
shed86536152sh_ed
sheds96122702sheds
sheen85023312sheen
sheens95116992sheens
sheep105321522sheep
sheer84726892sheer
sheers94322402sheers
sheesh1237812sheesh
sheet84836962sheet
sheets93918502sheets
sheol84318372sheol
sheols94614162sheols
shew108030762sh_ew
shews115924712shews
shied96125492shied
shiel811023772shiel
shiels95418922shiels
shier85428942shier
shiers94921752shiers
shiest95821532shiest
shims104422552shims
shines95028912shines
shins85131042shins
ships105123772ships
shires95225572shires
shits84731172shits
shives124921412shives
shivs115018802shivs
shlep104914832shlep
shleps114710332shleps
shoal83920272shoal
shoals94215792shoals
shoat85633952shoat
shoats94117082shoats
shock144917032shock
shocks154414582shocks
shod86225062sho_d
shog86025142sho_g
shogi95014012shogi
shogis103810942shogis
shoji15419962shoji
shojis16348492shojis
shone83725982shone
shoo75929892sho_o
shooed103916082shooed
shook124920162shook
shooks134515632shooks
shool84523152shool
shools94919012shools
shoon84022012shoon
shoot84235912shoot
shoots94619362shoots
shop95629842sho_p
shoppes143411402shoppes
shore85432652shore
shored105723652shored
shorl84720252shorl
shorls94516202shorls
shorn85722182shorn
short85040532short
shorts95321742shorts
shot76150262sho_t
shote85526102shote
shott85332192shott
shotts93614702shotts
shout85433172shout
shouts94017722shouts
shove114421042shove
shoved134214282shoved
shovel124611322shovel
shovels13378392shovels
shover124515992shover
shovers134613002shovers
show106229192sho_w
showed135016972showed
shower124315112shower
showers134612682showers
shown115216482shown
showy145714012showy
shoyu1138912shoyu
shoyus1266002shoyus
shred98125612shred
shreds105613052shreds
shrew119720172shrew
shrews129313922shrews
shris84221452shris
shuls85319712shuls
shuns85018142shuns
shutes93518222shutes
shuts85622482shuts
shwas116415102shwas
shyer114714782shyer
shyers124712202shyers
shyest125511832shyest
sices75637272sices
sides65838362sides
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
skees95023122skees
skies95026832skies
slobs74419872slobs
sloe45534952sloe_
slogs64521842slogs
slopes84820452slopes
slops75026012slops
slots54830532slots
slows85323462slows
slues54527172slues
smogs85112162smogs
smokes124814342smokes
snobs74716152snobs
snogs66017492snogs
snores64324322snores
snots55225122snots
snows84719892snows
snyes85012752snyes
sobs64941752s_obs
sods54940212s_ods
sokes95031422sokes
soles55547922soles
sols45448162s_ols
soms66239372s_oms
sones55444142sones
sons46049552s_ons
sooey84522432sooey
sooks94425452sooks
soots55536212soots
sops65244562s_ops
sores55454282sores
sos37761602s_o_s
sots45552452s_ots
sous46947212s_ous
sows75342492s_ows
soys75233932s_oys
spaes76029972spaes
spies76037622spies
spodes94817432spodes
spokes124417212spokes
spores84726612spores
spots74424112spots
spues75025382spues
sties55132982sties
stoas55126022stoas
stobs75718232stobs
stokes104821792stokes
stoles63927672stoles
stones65130032stones
stopes84525892stopes
stops74827282stops
stores65533662stores
stoss54316342stoss
stots54828552stots
stoves93818922stoves
stows86622702stows
styes86316522styes
sues46247652s_ues
supes75628302supes
swobs104910892swobs
swops105913972swops
swots85518432swots
syboes1139342syboes
syces106416462syces
sykes124816862sykes
tholes94919782tholes
those85218142those
thous86017262thous
throes97518672throes
toes46956442_toes
voes75432822_voes
wholes124616772wholes
whops135013932whops
whores125617102whores
whose114914532whose
woes76440662_woes

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 Limit538002911.58034050.6
3Display Results2912910.0763828.9
 (SQL Overall)1786912911.96990752.2
 
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.