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

232 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
poster8412917(None) 
coster84331291coster
foster94322221foster
paster85734371paster
pester84827591pester
porter84224411porter
poser75128771pos_er
posher115018161posher
posted93722491posted
postern93615611postern
posters93928011posters
potter83926981potter
pouter83923981pouter
powter114116031powter
roster64329081roster
zoster153715851zoster
aster55434892_aster
baster85333602baster
bister84922762bister
boaster94616432boaster
boater84622092boater
bolster93713422bolster
bolter83920752bolter
booster94314552booster
bosker123813652bosker
buster84726492buster
caster85232572caster
coaster94219042coaster
coater84329572coater
colter84625092colter
cooter85128612cooter
copter109822012copter
cosher114819902cosher
cosier84423762cosier
costar85518612costar
costed95623122costed
costers94128342costers
cotter84926672cotter
couter84930222couter
doser66228562dos_er
dosser74417972dosser
doter65428622do_ter
dotter74419342dotter
duster74919722duster
easter65027982easter
ester54727712_ester
faster94625772faster
fester94723512fester
footer94320772footer
fosters104220102fosters
gaster75027352gaster
goiter74116202goiter
hoister103714202hoister
holster103512212holster
hooter94123932hooter
hoser811529762hos_er
hosier94219612hosier
hosted105020342hosted
hostel93914152hostel
hostler103411022hostler
hotter94720082hotter
imposter12288162imposter
jester134319152jester
jolter133513092jolter
josher164312962josher
jostler14288222jostler
jotter134315632jotter
jouster143311042jouster
juster134617012juster
kosher134412972kosher
laster64830632laster
lister64527252lister
lobster9288852lobster
lofter94614722lofter
loiter64619172loiter
looter64222322looter
loser54728672los_er
lotter64025602lotter
luster64023672luster
master84831342master
mister84728562mister
mobster11299212mobster
moister94015372moister
molter84119422molter
monster93214602monster
mooter83921092mooter
mosher114719792mosher
mosser84618272mosser
moste75925082moste_
muster84724522muster
nester64124182nester
nosher94616362nosher
nosier63716332nosier
noter55025642no_ter
oater55433732_oater
ofter84116872_ofter
osier53518012_osier
ostler63312192_ostler
otter54423972_otter
ouster64223732ouster
outer55633302_outer
oxter123414092_oxter
oyster94111702oyster
palter84423262palter
passer84721032passer
paste74932952paste_
pasted94426902pasted
pastel85918712pastel
pastern94415062pastern
pasters94531732pasters
pastes85233912pastes
pastier94320382pastier
pastor84817482pastor
pater74740722p_ater
patter84628262patter
pelter83321622pelter
penster92811952penster
perter84422282perter
pesters93827092pesters
pestier94317402pestier
peter74427592p_eter
petter83924772petter
pewter114013672pewter
piaster93012882piaster
pisher114317752pisher
pisser84416382pisser
piste75824602piste_
pistes85325632pistes
plaster93318692plaster
plater84427692plater
plotter94113662plotter
pointer93814932pointer
poiser84217242poiser
poker115122882po_ker
pokier124914632pokier
polder94019252polder
poler74431792po_ler
politer92417072politer
poller83921852poller
pollster1037102pollster
ponder94521692ponder
pontes83627852pontes
poofter1237162poofter
pooler83819842pooler
poorer82613992poorer
popper93615962popper
porker124917542porker
ported94223242ported
porters93722702porters
pose66441732pos_e_
posed85828412pos_ed
posers84223972pos_ers
poses74642762pos_es
poseur8419402poseur
posies84431432posies
posited10511492posited
posse74722272posse_
posses85128802posses
posset84923252posset
post67953362post__
postal84317532postal
posteen93512622posteen
posterns102713722posterns
postie84123962postie
posties93128812posties
postin83521032postin
postmen113110422postmen
postop10511942postop
posts75228782post_s
posture9313252posture
posturer1038922posturer
postwar1236902postwar
pother113818852pother
potted94624012potted
potters94024342potters
pottery123011072pottery
pottier93516492pottier
potzer174411212potzer
poulter93712012poulter
pourer84516042pourer
pouted94021392pouted
pouters94221872pouters
poutier93215322poutier
powder123611902powder
power105325952po_wer
powters124015662powters
poxier153812112poxier
prater84825352prater
prester93519622prester
proser84223462pros_er
prosier93817492prosier
prosper114012192prosper
punster92911102punster
punter84320022punter
pusher114318282pusher
putter83921442putter
raster64731442raster
rester63832432rester
roaster74116662roaster
roister73516202roister
rooster74415172rooster
rooter64926032rooter
rosier64221272rosier
rosters73727552rosters
rotter64325462rotter
rouster73517082rouster
router65025842router
royster103110532royster
sister64421582sister
softer94015312softer
sorter64425092sorter
souter64225922souter
sporter93616552sporter
spotter94514882spotter
spouter94213222spouter
taster64930572taster
tester64227152tester
toaster74414462toaster
tooter64420802tooter
tosser64215662tosser
toter55932132to_ter
totter65021462totter
touter63821032touter
ulster63712102ulster
vaster94521022vaster
voter85121052vo_ter
waster95228942waster
wester94222892wester
xyster16366802xyster
yester93417982yester
zester153617792zester
zosters163015412zosters

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.343520965.0
2DLD Change Limit825512322.22037185.1
3Display Results2322320.0763052.6
 (SQL Overall)1786912322.63967711.6
 
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.