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

285 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
paster8573437(None) 
aster55434891_aster
baster85333591baster
caster85232571caster
easter65027981easter
faster94625771faster
gaster75027351gaster
laster64830631laster
master84831341master
palter84423261palter
passer84721031passer
paste74932951paste_
pasted94426901pasted
pastel85918711pastel
pastern94415061pastern
pasters94531731pasters
pastes85233911pastes
pastier94320381pastier
pastor84817481pastor
pater74740721pa_ter
patter84628261patter
pester84827591pester
piaster93012881piaster
plaster93318691plaster
poster84129171poster
raster64731441raster
taster64930571taster
vaster94521021vaster
waster95228941waster
after85719792_after
alter54828502_alter
apter76120202_apter
asker96418782_asker
asper75520432_asper
astern64815812_astern
asters65631602_asters
astir55517092_astir
baiter84422552baiter
banter84825332banter
barter85525372barter
baser74828922bas_er
basher115123812basher
baste74829982baste_
basted95227232basted
basters94930302basters
bastes85330382bastes
batter84928872batter
bister84922762bister
blaster94017302blaster
boaster94616432boaster
buster84726492buster
canter85230112canter
carter84932272carter
caste75932362caste_
casters94729902casters
castes85631862castes
castor84418532castor
cater74840722ca_ter
chaster124718502chaster
coaster94219042coaster
coster84331292coster
dabster1036702dabster
dafter104813342dafter
darter75320362darter
dasher104318982dasher
dater65332312da_ter
diaster82813312diaster
duster74919722duster
easier64218462easier
eastern74412532eastern
easters75125682easters
eater54639842ea_ter
ester54727712_ester
falter94519052falter
fasted105320952fasted
fasten95114892fasten
fatter94523212fatter
feaster10812982feaster
fester94723512fester
foster94322222foster
gagster9317632gagster
gaiter73819502gaiter
garter74420512garter
gasher104320372gasher
gasper94515542gasper
gasser75017772gasser
gasted84821582gasted
gasters85624292gasters
gater64533652ga_ter
hafter124815882hafter
halter94420882halter
hamster12810422hamster
haste85927862haste_
hasted105125282hasted
hasten95718562hasten
hastes95727072hastes
hastier103916622hastier
hater85034752ha_ter
hatter94724872hatter
jasper154610382jasper
jester134319152jester
juster134617012juster
kasher134915032kasher
lamster9109912lamster
laser54633322las_er
lasher94824532lasher
lasted74323602lasted
lasters75627692lasters
later54843922la_ter
latter65027892latter
lister64527252lister
luster64023672luster
maser75029972mas_er
masher114123202masher
masker124416102masker
masted94025802masted
masters94628922masters
mastery124214322mastery
mater74438862ma_ter
matter84325342matter
mister84728562mister
muster84724522muster
nastier74115292nastier
natter64420742natter
nester64124182nester
oater55433732oa_ter
ouster64223732ouster
oyster94111702oyster
pacer96131612pa_cer
pacier105018682pacier
packer144223402packer
padder103415492padder
pager84728202pa_ger
painter93814562painter
paler75436932pa_ler
palier85023562palier
palmer105816542palmer
palters94021682palters
pamper124316662pamper
pander93725522pander
panier84425502panier
panner84224762panner
panted95024822panted
panther12611442panther
panzer174213232panzer
paper95128662pa_per
parer75839902pa_rer
parker124121372parker
parser84822372parser
parted94228682parted
partier93520712partier
partner92811392partner
partyer12337872partyer
pase65346862pas_e_
paseo77022512pas_eo
pases75346502pas_es
pashed125923142pashed
pashes115828392pashes
passe75525692passe_
passed94320942passed
passee84522022passee
passel85117002passel
passers94717752passers
passes86030472passes
past65959012past__
pasta76624532past_a
pastas85422872pastas
pastels95215182pastels
pasterns104112622pasterns
pasteup1134982pasteup
pastie85525522pastie
pasties94529812pasties
pastil85018322pastil
pastis84924322pastis
pastors94119002pastors
pastry114913032pastry
pasts75936502past_s
pasture9311462pasture
pasturer1037522pasturer
pasty105725052past_y
pate65350462pa_te_
pated85237842pa_ted
paten74827342pa_ten
paters84935832pa_ters
pates76047892pa_tes
patted94724682patted
pattee84323382pattee
patten84418192patten
pattern93712052pattern
patters94825192patters
patzer173111642patzer
pauper103511942pauper
pauser84415962pauser
paver104225832pa_ver
pawer104422972pa_wer
pawner114212922pawner
payer105125722pa_yer
pearter9412742pearter
pelter83321622pelter
penster92811952penster
perter84422282perter
pesters93827092pesters
pestier94317402pestier
peter74427592p_eter
petter83924772petter
pewter114013672pewter
phatter123810202phatter
piasters102912812piasters
piastre9307892piastre
pilaster1038162pilaster
pinaster1037112pinaster
pisher114317752pisher
pisser84416382pisser
piste75824602piste_
pistes85325632pistes
plaister1068012plaister
plaiter93615392plaiter
planter94017802planter
plasher124215032plasher
plasters103518132plasters
plastery13279702plastery
plater84427692plater
platter93917412platter
porter84224412porter
poser75128772pos_er
posher115018162posher
posted93722492posted
postern93615612postern
posters93928012posters
potter83926982potter
pouter83923982pouter
powter114116032powter
prater84825352prater
prester93519622prester
psalter9247812psalter
punster92911102punster
punter84320022punter
pusher114318282pusher
putter83921442putter
rafter94517582rafter
ranter63826822ranter
raser55633412ras_er
rasher95024122rasher
rasper83917332rasper
rasters74629022rasters
rater54943282ra_ter
ratter64326312ratter
rester63832432rester
roaster74116662roaster
roster64329082roster
salter64325082salter
sister64421582sister
spatter94016522spatter
tapster9299272tapster
tarter64023562tarter
taste55127232taste_
tasted74123972tasted
tasters74225642tasters
tastes64126422tastes
tastier711817092tastier
tater54138612ta_ter
tatter64024572tatter
tauter64318022tauter
tester64227152tester
toaster74414462toaster
ulster63712102ulster
vastier103613202vastier
wafter124114612wafter
waister103812382waister
waiter94321252waiter
wanter94423052wanter
washer124720392washer
waste86125052waste_
wasted104423022wasted
wasters104026592wasters
wastery134610992wastery
wastes96224882wastes
water84733312wa_ter
watter93221982watter
wester94222892wester
xyster16366802xyster
yatter94116212yatter
yester93417982yester
zester153617792zester
zoster153715852zoster

Search took 3 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.1101624463.6
2DLD Change Limit825512852.25036689.3
3Display Results2852850.0933064.5
 (SQL Overall)1786912852.45372845.9
 
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.