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

175 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
styes8631652(None) 
snyes85012751snyes
sties55132981sties
stye76218971stye_
styed95815481styed
styles94418651styles
tyes76433371_tyes
abyes105518532abyes
ates45047922at_es
ayes76543512_ayes
byes95230532_byes
bytes105217492bytes
dyes85331892_dyes
eyes75837882_eyes
istles62814982istles
kyes115124932_kyes
kytes125012912kytes
lyes75530832_lyes
oyes74940132_oyes
pyes95528992_pyes
ryes75529352_ryes
sabes76437462sabes
sades65239892sades
safes85226722safes
sages65339062sages
sakes95540752sakes
sales56055592sales
sanes55649072sanes
sates54949322sates
satyrs937962satyrs
saves85838632saves
saxes125229342saxes
sayed96127142sayed
sayeds10469252sayeds
sayer84926552sayer
sayers94221592sayers
sayest94217742sayest
says75942102say_s
sees45361052s_ees
semes75731582semes
seres55448892seres
sexes126126222sexes
shes75734352s_hes
shies86136552shies
shoes85429662shoes
shyer114714782shyer
shyers124712202shyers
shyest125511832shyest
sices75637272sices
sides65838362sides
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
skees95023122skees
skies95026832skies
skyed13529922skyed
skyey15537222skyey
sloes54728872sloes
slues54527172slues
slyer85515122slyer
slyest93811362slyest
slypes114410482slypes
snye77115492snye_
sokes95031422sokes
soles55547922soles
sones55444142sones
sores55454282sores
soyas84520912soyas
soys75233932soy_s
spaes76029972spaes
spies76037622spies
spues75025382spues
stabs76221382stabs
stades74626242stades
stages75629492stages
stags66226742stags
stakes103927292stakes
stales65538292stales
stanes64933402stanes
stapes85028732stapes
stares66038752stares
stars55836572stars
stases64225562stases
states64337082states
stats55933362stats
staves94525192staves
stayed104817272stayed
stayer94516482stayer
stayers103813632stayers
stays86022022stays
steed66024942steed
steeds73814882steeds
steek95418002steek
steeks103613702steeks
steel55721992steel
steels64117982steels
steep76020702steep
steeps85215192steeps
steer55423862steer
steers63820982steers
steles63725662steles
stem610628252st_em
stems75219952stems
step67126292st_ep
steps76619882steps
steres63929532steres
stet45947322st_et
stets55423912stets
stew77525462st_ew
stews85519142stews
stey76224412st_ey
stied65723032stied
stiles64328772stiles
stimes85920572stimes
stipes84524052stipes
stirs55921622stirs
stoas55126022stoas
stobs75718232stobs
stokes104821792stokes
stoles63927672stoles
stones65130032stones
stopes84525892stopes
stops74827282stops
stores65533662stores
stoss54316342stoss
stots54828552stots
stoves93818922stoves
stows86622702stows
strep77120852strep
streps86218062streps
stress66616672stress
strew89220662strew
strews96817102strews
stubs75016072stubs
studs64415872studs
stums75320082stums
stuns54719492stuns
stupes84116952stupes
sty66227312sty__
style85519362style
styled105613102styled
styler94013302styler
stylers10359352stylers
stylet94018572stylet
stylets10369212stylets
styli83911172styli
stylus9397462stylus
stymies1239212stymies
stymy13358292stymy
sues46247652s_ues
supes75628302supes
syces106416462syces
sykes124816862sykes
tees45353582_tees
ties45248312_ties
toes46956442_toes
tres46542902_tres
tye65837442_tye_
tyee75131422_tyee
tyees86019452_tyees
tyer75323392_tyer
tyers86220052_tyers
tykes125817062_tykes
tynes85920302_tynes
types105721062_types
tyres84725232_tyres
utes45930882ut_es
wyes105727502_wyes
wytes114113432wytes
yes66250612__yes

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 Limit538001751.56034487.2
3Display Results1751750.0463804.3
 (SQL Overall)1786911751.91993116.7
 
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.