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

538 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
pates7604789(None) 
ates45047921_ates
bates75846341bates
cates75951871cates
dates65639151dates
fates85139231fates
gates65939501gates
hates86742571hates
mates75251361mates
nates55238331nates
paces96741111paces
pages85235071pages
pales75753801pales
panes76148691panes
pares77164481pares
pases75346501pases
pastes85233911pastes
pate65350461pate_
pated85237841pated
paten74827341paten
patens84820861patens
pater74740721pater
paters84935821paters
paths105521381paths
pats66460851pat_s
paves104833921paves
paxes144928421paxes
plates85432241plates
prates84633161prates
rates55352011rates
sates54949321sates
spates85028171spates
tates55444981tates
abates85825032abates
aces67645092_aces
agates76121332agates
ages55844592_ages
alates64833962alates
ales47067102_ales
anes45255932_anes
antes56334322antes
apes66047432_apes
apres75426402apres
apses76823912apses
apter76120202apter
aptest82917512aptest
ares45871022_ares
ate37059242_ate_
aves76142602_aves
awes76037552_awes
axes117337852_axes
ayes76543512_ayes
babes95834112babes
bakes117035372bakes
bales76250082bales
banes74945582banes
bares75457132bares
bases75644352bases
bastes85330382bastes
bate66552422bate_
bated85935532bated
bathes116524832bathes
baths105922922baths
bats66962332bat_s
batts76727562batts
bites75641172bites
butes714535872butes
bytes105217492bytes
cades85440732cades
cafes106426922cafes
cages85936012cages
cakes116037672cakes
cames97047312cames
canes75350372canes
capes95441922capes
cares77369182cares
cartes86239472cartes
cases75048382cases
castes85631862castes
cate66254592cate_
cater74840702cater
caters85336492caters
cats66356342cat_s
caves105639702caves
cetes75731102cetes
cites74435582cites
cotes76347842cotes
crates85736052crates
cutes79438312cutes
daces85030682daces
dales66439742dales
dames85435852dames
dares66146702dares
date56443322date_
dated75530992dated
dater65332312dater
daters74827362daters
datos65222782datos
dazes155024142dazes
dites66339152dites
dotes65836692dotes
eases56041612eases
eaten55323052eaten
eater54639842eater
eaters65535942eaters
eats47054872eat_s
eaves85231992eaves
elates65032362elates
enates64026422enates
faces106439432faces
fades94932862fades
fakes126032482fakes
fames105735922fames
fanes84639892fanes
fares85852872fares
fate75444282fate_
fated95632132fated
fats76252502fat_s
faves115331422faves
faxes155726652faxes
fazes175527212fazes
fetes85630142fetes
gaes56348032ga_es
gages74529972gages
gales65442482gales
games86238552games
gapes86030822gapes
gases65633992gases
gate55746572gate_
gated75329772gated
gater64533642gater
gaters74728632gaters
gats56753442gat_s
gazes155425912gazes
gites65630182gites
grates75429882grates
hades96035112hades
haes77651022ha_es
haets86525122haets
hajes155420942hajes
hakes126034302hakes
hales85449842hales
hames106138702hames
hares86255542hares
hastes95727072hastes
hate78450172hate_
hated95734022hated
hater85034752hater
haters94930392haters
hats76858252hat_s
haves116034872haves
hazes174928322hazes
jades135222112jades
jakes165023642jakes
janes124928122janes
japes146322822japes
jatos125116822jatos
jetes124922842jetes
jutes125125132jutes
kaes85734062ka_es
kales95730982kales
kames115024692kames
kanes95529372kanes
katas95922092katas
kats85944332kat_s
kites95432542kites
kytes125012912kytes
laces76141762laces
lades65141272lades
lakes95737652lakes
lames75445542lames
lanes54946792lanes
lares54852632lares
lases54944762lases
late47560482late_
lated65240672lated
laten54328342laten
latens64620212latens
later54843922later
latest63822702latest
latex124717112latex
lathes95127492lathes
laths86022402laths
latkes104715872latkes
lats45962702lat_s
lattes65324202lattes
laves86039152laves
laxes125430092laxes
lazes145129572lazes
lutes55836662lutes
mabes96331532mabes
maces97139962maces
maes66948392ma_es
mages85036022mages
makes115336852makes
males75049792males
manes76648952manes
mantes84430782mantes
mares76457632mares
mate65154212mate_
mated85537782mated
mater74438862mater
maters85032382maters
matey107022662matey
mateys115610942mateys
maths105624022maths
matres84522232matres
mats65460282mat_s
mattes85624532mattes
matts76829182matts
maxes145629532maxes
mazes165632172mazes
metes74736212metes
mites75141802mites
motes75944002motes
mutes75033782mutes
nabes75427092nabes
names74833362names
napes74828462napes
nares55544152nares
naves87030382naves
nites55736342nites
notes55034582notes
oases55330982oases
oaten55222402oaten
oater55433732oater
oaters65029782oaters
oaths86117312oaths
oats46554212oat_s
oaves84925612oaves
opiates9312142opiates
orates64328612orates
pacas96029402pacas
pace86345772pace_
paced106931682paced
pacer96131612pacer
pacers105124542pacers
pacey126720282pacey
packs135528932packs
pacs85842182pa_cs
pacts95125802pacts
padis86227142padis
padles95221112padles
padres95016982padres
pads76742952pa_ds
page76036102page_
paged95926782paged
pager84728202pager
pagers94423252pagers
paiks114719852paiks
pails75833062pails
pains75138282pains
pairs75325832pairs
paise75028332paise
palates93624932palates
pale66055012pale_
palea75028662palea
paled85538722paled
paler75436932paler
palest83926222palest
palet74650802palet
palets85122312palets
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pa_ls
palter84423262palter
palters94021682palters
pams85641762pa_ms
pane64950282pane_
paned85437182paned
panel76023622panel
panels84716522panels
pangs84628662pangs
pannes85522852pannes
pans65855722pa_ns
panted95024822panted
panties94230932panties
pantos85222742pantos
pants76536922pants
papas94927492papas
paper95128662paper
papers105125322papers
paps86443452pa_ps
paras76143042paras
pards85634332pards
pare66760842pare_
pared86946762pared
pareo74632602pareo
pareos87023772pareos
parer75839902parer
parers85530742parers
pareu74928742pareu
pareus85420742pareus
parges94529542parges
paries84742512paries
paris75145942paris
parks116134462parks
parles86334392parles
parrs75928672parrs
pars67560792pa_rs
parse75236992parse
parses85534702parses
parted94228682parted
parties93230862parties
parts77743372parts
pas58775742pa__s
pase65346862pase_
paseo77022512paseo
paseos88015812paseos
pashes115828392pashes
pass65239952pa_ss
passe75525692passe
passes86030472passes
pastas85422872pastas
paste74932952paste_
pasted94426902pasted
pastel85918712pastel
pastels95215182pastels
paster85734372paster
pasters94531732pasters
pasties94529812pasties
pastis84924322pastis
pasts75936502pasts
pat58089462pat__
patch125221222patch
patches143320382patches
patent84524922patent
patents94815202patents
path99134912pat_h
pathos115516692pathos
patin76832852patin
patines95225762patines
patins87528782patins
patio74426352patio
patios85221782patios
patly105020582patly
patness92912282patness
patois84319362patois
patsies93919482patsies
patsy105717202patsy
patted94724682patted
pattee84323382pattee
patten84418192patten
pattens95414922pattens
patter84628262patter
patters94825192patters
patties93425142patties
patty104723612patty
paty95234562pat_y
patzer173111642patzer
patzers184210572patzers
pause75021832pause
pauses84621472pauses
pave96133892pave_
paved115525262paved
paver104225832paver
pavers115021822pavers
pavis106422732pavis
pawed115725612pawed
pawer104422972pawer
pawers114818782pawers
pawls105617662pawls
pawns108818132pawns
paws96038182pa_ws
payed115925932payed
payee105524722payee
payees114812902payees
payer105125722payer
payers114621822payers
pays95940222pa_ys
peaces106324082peaces
peages94321842peages
peases85229472peases
peats76140192peat_s
pedes85327282pedes
pees65257372p_ees
pekes114623562pekes
peles75738082peles
penates93321592penates
penes75839222penes
peres76246642peres
pes57259782p__es
peter74427592peter
peters86624592peters
pets66248332pet_s
phages125213512phages
phases114618402phases
pies66949602p_ies
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pirates93020322pirates
pistes85325632pistes
pitas77427672pitas
piths105817542piths
pities83828082pities
pits66348742pit_s
pixes144323172pixes
places104323702places
plages94520152plages
planes85028082planes
plate74635112plate_
plated95225772plated
platen84518202platen
platens94213982platens
plater84427692plater
platers93924082platers
platies93722542platies
plats75531372plat_s
platys11459852platys
plies74526512plies
poets76024442poets
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
pontes83627852pontes
popes95933812popes
pores75849032pores
poses74642762poses
pots66452362pot_s
poxes145325722poxes
prases84429022prases
prate75135982prate_
prated94924922prated
prater84825352prater
praters94921642praters
prats76333392prat_s
praxes156215182praxes
prees75937172prees
pries74339532pries
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pules74538812pules
pupates113311432pupates
puses75532202puses
puts65641752put_s
putts75719272putts
putzes174212522putzes
pyes95528992p_yes
pyres105523882pyres
pyxes175911402pyxes
qats135331342qat_s
races74943242races
rages64539442rages
rajes125022782rajes
rakes94440352rakes
rales54947492rales
rapes75740722rapes
rares55247442rares
rases55447212rases
rate45458762rate_
rated65441382rated
ratel54224882ratel
ratels64518212ratels
rater54943282rater
raters63936572raters
ratos55528762ratos
rats46260372rat_s
raves85441972raves
raxes124729392raxes
razes145032702razes
rites54442552rites
rotes56143902rotes
sabes76437462sabes
sades65239892sades
safes85226722safes
sages65339062sages
sakes95540752sakes
sales56055592sales
sanes55649072sanes
sate45556102sate_
sated66238532sated
satem76021452satem
satis55633672satis
sautes63924912sautes
saves85838632saves
saxes125229342saxes
sites56045432sites
skates104219392skates
slates64934062slates
spaces104722632spaces
spades94222582spades
spaes76029972spa_es
spales84728102spales
spares84834552spares
spate74731582spate_
spathes125116532spathes
spats75031382spat_s
spites84127332spites
states64337082states
tabes76033922tabes
taces76237802taces
tajes124920692tajes
takes94437792takes
tales55451372tales
tames75242012tames
tapes75838602tapes
tares57456562tares
tastes64126422tastes
tate44748602tate_
tater54138612tater
taters64932192taters
tats46858132tat_s
taxes124730822taxes
totes55139682totes
upases84112902upases
updates10329792updates
uprates93814862uprates
urates65027762urates
utes45930882_utes
vales85434262vales
vanes85130972vanes
vases84626262vases
vats76841742vat_s
vatus86114642vatus
votes84627082votes
wades95634142wades
waes76048602wa_es
wages95330932wages
wakes126633652wakes
wales86142832wales
wames106432802wames
wanes85040882wanes
wares88250582wares
wastes96224882wastes
water84733312water
waters95030622waters
wats77555882wat_s
watts86923092watts
waves115633922waves
waxes155825502waxes
wites85536962wites
wytes114113432wytes
zaxes215113822zaxes

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 Filter178691538000.0961861364.6
2DLD Change Limit538005383.10617321.3
3Display Results5385380.2961817.6
 (SQL Overall)1786915383.49851083.8
 
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.