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

300 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
spaes7602997(None) 
spaces104722631spaces
spades94222581spades
spae65034321spae_
spaed85522271spaed
spales84728101spales
spams94922191spams
spans74528731spans
spares84834551spares
spars75431541spars
spas67036721spa_s
spates85028171spates
spats75031381spats
spays105520511spays
spies76037621spies
spues75025381spues
apes66047432ap_es
apres75426402apres
apses76823912apses
braes75735052braes
capes95441922capes
epees75219832epees
espies83716802espies
gaes56348032_gaes
gapes86030822gapes
haes77651022_haes
japes146322822japes
kaes85734062_kaes
maes66948402_maes
napes74828462napes
opahs105411982opahs
opals75718352opals
opes65942612op_es
paces96741112_paces
pacs85842182_pacs
pads76742952_pads
pages85235072_pages
pales75753802_pales
pals66951352_pals
pams85641762_pams
panes76148692_panes
pans65855732_pans
paps86443452_paps
pares77164482_pares
pars67560792_pars
pas58775742_pa_s
pase65346862_pase
pases75346502_pases
pass65239952_pass
pates76047892_pates
pats66460852_pats
paves104833922_paves
paws96038182_paws
paxes144928422_paxes
pays95940222_pays
peas65755062_peas
pees65257372_pees
pes57259782_p_es
pies66949602_pies
pyes95528992_pyes
rapes75740722rapes
sabes76437462sabes
sabs66643742s_abs
sacs65739072s_acs
sades65239892sades
sae38365182s_ae_
safes85226722safes
sages65339062sages
sags55948402s_ags
sakes95540752sakes
sales56055592sales
sals46851672s_als
sanes55649072sanes
sans45153362s_ans
saps65346372s_aps
sass45035622s_ass
sates54949322sates
saves85838632saves
saws75839482s_aws
saxes125229342saxes
says75942102s_ays
scabs94818642scabs
scads85419962scads
scags85520972scags
scales84529312scales
scams94423972scams
scans74625102scans
scapes105122262scapes
scares85033002scares
scars75433532scars
scats75930602scats
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
sees45361052s_ees
semes75731582semes
sepals85217372sepals
sepses84515882sepses
seres55448892seres
sexes126126222sexes
shades105924532shades
shads95124482shads
shags95123862shags
shahs115919512shahs
shakes135024592shakes
shales94731252shales
shames114726222shames
shams105829412shams
shapes115124942shapes
shares95236412shares
shaves125224932shaves
shaws116226262shaws
shays116021432shays
sheas86331792sheas
shes75734352s_hes
shies86136552shies
shoes85429662shoes
sials54227242sials
sices75637272sices
sides65838362sides
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
skags104316072skags
skas85325712ska_s
skates104219402skates
skats94621542skats
skees95023122skees
skies95026832skies
slabs75322642slabs
slags66525902slags
slakes104021882slakes
slams74927902slams
slaps76025712slaps
slates64934062slates
slats55436902slats
slaves95023022slaves
slaws85222712slaws
slays85723682slays
sloes54728872sloes
slues54527172slues
smazes174311662smazes
snags64421312snags
snakes103919602snakes
snaps74719562snaps
snares65329032snares
snaws86116362snaws
snyes85012752snyes
soaks95220292soaks
soaps75120712soaps
soars54732512soars
soaves94218672soaves
sokes95031422sokes
soles55547922soles
sones55444142sones
sores55454282sores
spa55730812spa__
space95325672space
spaced114517252spaced
spacer104917792spacer
spacers113813872spacers
spacey136212532spacey
spacy125415622spacy
spade84423322spade
spaded103816752spaded
spader94317132spader
spaders104214472spaders
spado83713702spado
spahee11313442spahee
spahees1238262spahees
spahi10311142spahi
spahis11310382spahis
spail74921552spail
spails84817822spails
spait75631602spait
spaits85017472spaits
spake114322742spake
spale74929212spale
spall74919302spall
spalls84217342spalls
spam85930042spa_m
span65234662spa_n
spang84919732spang
spank115919572spank
spanks124514122spanks
spar65433302spa_r
spare75135562spare
spared95427492spared
sparer84524962sparer
sparers94519612sparers
sparest94616422sparest
sparges104016342sparges
spark114920892spark
sparks124616362sparks
sparse84516342sparse
spasm94514172spasm
spasms10418972spasms
spat66548522spa_t
spate74731582spate
spathes125116532spathes
spavies123012942spavies
spawn107811712spawn
spawns11577922spawns
spay96631662spa_y
spayed124213612spayed
spaz155626162spa_z
spazz155811132spazz
spazzes1735262spazzes
speak114618672speak
speaks125114582speaks
spean74620512spean
speans85417142speans
spear75821062spear
spears84019472spears
spec85821972sp_ec
specs96916672specs
sped76031492sp_ed
speed85526622speed
speeds94316052speeds
speel74420762speel
speels85116392speels
speer74623902speer
speers85019952speers
spew95421872sp_ew
spews105015922spews
spices104326032spices
spics94123242spics
spied85427712spied
spiel74623912spiel
spiels85317952spiels
spier75728032spier
spiers84421742spiers
spikes124520712spikes
spiks114117472spiks
spiles84227912spiles
spines85132032spines
spins75327982spins
spires84628112spires
spites84127332spites
spits74429552spits
spivs105114242spivs
splakes1349672splakes
splats84817302splats
splays114910872splays
spodes94817432spodes
spokes124417212spokes
spores84726612spores
spots74424112spots
sprags95715822sprags
sprats85819932sprats
sprays115913642sprays
spree74830862spree
sprees85620642sprees
sprues84515762sprues
spuds85113672spuds
spue66025522spue_
spued84918472spued
spumes1021314882spumes
spurs74621522spurs
stabs76221382stabs
stades74626242stades
stages75629492stages
stags66226742stags
stakes103927292stakes
stales65538292stales
stanes64933402stanes
stapes85028732stapes
stares66038752stares
stars55836572stars
stases64225562stases
states64337082states
stats55933362stats
staves94525192staves
stays86022022stays
sties55132982sties
styes86316522styes
sues46247652s_ues
supes75628302supes
swabs105817272swabs
swages104417072swages
swags94921252swags
swales93920762swales
swans84625012swans
swaps104819202swaps
swats85726862swats
sways115518462sways
syces106416462syces
sykes124816862sykes
tapes75838602tapes
twaes86513662twaes
upas68322382upa_s
upases84112902upases
waes76048602_waes

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.296603685.8
2DLD Change Limit538003001.56334421.0
3Display Results3003000.0763947.4
 (SQL Overall)1786913001.93592346.8
 
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.