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

213 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
spates8502817(None) 
pates76047891_pates
sates54949321s_ates
skates104219401skates
slates64934061slates
spaces104722631spaces
spades94222581spades
spaes76029971spa_es
spales84728101spales
spares84834551spares
spate74731581spate_
spathes125116531spathes
spats75031381spat_s
spites84127331spites
states64337081states
abates85825042abates
agates76121342agates
alates64833972alates
ates45047922__ates
bates75846342_bates
cates75951892_cates
crates85736062crates
dates65639152_dates
elates65032362elates
enates64026432enates
estates74520182estates
fates85139232_fates
gates65939512_gates
grates75429892grates
hates86742572_hates
mates75251362_mates
nates55238332_nates
opiates9312142opiates
orates64328612orates
paces96741112_paces
pages85235072_pages
pales75753802_pales
panes76148692_panes
pares77164482_pares
pases75346502_pases
pastes85233912_pastes
pate65350462_pate_
pated85237842_pated
paten74827342_paten
patens84820862_patens
pater74740732_pater
paters84935842_paters
paths105521382_paths
pats66460852_pat_s
paves104833922_paves
paxes144928422_paxes
plates85432242plates
prates84633162prates
pupates113311432pupates
rates55352012_rates
sabes76437462s_abes
sades65239892s_ades
safes85226722s_afes
sages65339062s_ages
sakes95540752s_akes
sales56055592s_ales
sanes55649072s_anes
sapotes9313942sapotes
sate45556102s_ate_
sated66238532s_ated
satem76021462s_atem
satis55633682s_atis
sautes63924912sautes
savates10312952savates
saves85838632s_aves
saxes125229342s_axes
scales84529312scales
scapes105122262scapes
scares85033002scares
scathes124515712scathes
scats75930602scat_s
scatts85914662scatts
scutes85219192scutes
seated75131062seated
seater64534162seater
seaters74028942seaters
seats54844342seat_s
sedates83418042sedates
senates73322612senates
shades105924532shades
shakes135024592shakes
shales94731252shales
shames114726222shames
shapes115124952shapes
shares95236412shares
shaves125224932shaves
shotes95321912shotes
shutes93518222shutes
sites56045432s_ites
sixtes133612402sixtes
skate94721552skate_
skated114414882skated
skater105015492skater
skaters113512962skaters
skats94621542skat_s
skites104418042skites
slakes104021882slakes
slate55438282slate_
slated75028312slated
slater64429182slater
slaters73123732slaters
slatey95417062slatey
slats55436902slat_s
slaves95023022slaves
smazes174311662smazes
smites83921922smites
snakes103919602snakes
snares65329032snares
snathes104816492snathes
snaths95112912snaths
soaves94218672soaves
solates73523852solates
sopites93817172sopites
space95325672space_
spaced114517252spaced
spacer104917792spacer
spacers113813872spacers
spacey136212532spacey
spade84423322spade_
spaded103816752spaded
spader94317132spader
spaders104214472spaders
spae65034322spa_e_
spaed85522272spa_ed
spahee11313442spahee
spahees1238262spahees
spahis11310382spahis
spails84817822spails
spaits85017472spaits
spake114322742spake_
spale74929212spale_
spalls84217342spalls
spams94922192spa_ms
spanks124514122spanks
spans74528732spa_ns
spare75135562spare_
spared95427492spared
sparer84524962sparer
sparers94519612sparers
sparest94616432sparest
sparges104016342sparges
sparks124616362sparks
spars75431542spa_rs
sparse84516342sparse
spas67036722spa__s
spasms10418972spasms
spat66548522spat__
spathe115115692spathe
spathed134013182spathed
spatted104014142spatted
spatter94016522spatter
spatters103914702spatters
spatzles1935302spatzles
spavies123012952spavies
spawns11577922spawns
spayed124213612spayed
spays105520512spa_ys
spazzes1735262spazzes
spices104326032spices
spies76037622sp_ies
spikes124520712spikes
spiles84227912spiles
spines85132032spines
spires84628112spires
spite75430662spite_
spited94820442spited
spits74429552spit_s
spitzes1849182spitzes
splakes1349672splakes
splats84817302splat_s
spodes94817432spodes
spokes124417212spokes
spores84726612spores
spots74424112spot_s
sprats85819932sprat_s
sprees85620642sprees
sprites94220332sprites
sprues84515762sprues
spues75025382sp_ues
spumes1021314882spumes
stactes91914632stactes
stades74626242stades
stages75629492stages
stakes103927292stakes
stales65538292stales
stanes64933402stanes
stapes85028732stapes
stares66038752stares
stases64225562stases
state56237332state_
stated75427832stated
stater64427562stater
staters73922342staters
stats55933362stat_s
statues74614902statues
status65515212status
staves94525192staves
suites63727402suites
swages104417072swages
swales93920762swales
swathes134115512swathes
swaths125312642swaths
swats85726862swat_s
tates55444982_tates
upases84112902upases
updates10329792updates
uprates93814862uprates
urates65027762urates

Search took 4 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 Filter178691825510.360496363.9
2DLD Change Limit825512133.51623478.7
3Display Results2132130.0633381.0
 (SQL Overall)1786912133.93945364.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.