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

283 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
posts7522878(None) 
costs77231141costs
hosts85526701hosts
mosts76028541mosts
pasts75936501pasts
pests75933271pests
poets76024441poets
ports75934591ports
poses74642761poses
posits85718711posits
post67953361post_
pots66452361po_ts
pouts75530321pouts
basts75936932basts
bests75932612bests
boasts85017922boasts
boats75635152boats
bolts76232112bolts
boosts86115012boosts
boots75837972boots
borts76735452borts
bosks115218852bosks
boss65938342bos_s
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
busts75227692busts
casts77237792casts
cists76624532cists
coasts85719142coasts
coats75635002coats
colts76633292colts
coots75636842coots
coses76949492coses
cosets85824402cosets
coss66143492cos_s
cost68057942cost_
costa75523732costa
cots68054842co_ts
cysts105912772cysts
doats65224882doats
doits66223672doits
dolts65626312dolts
doses65938502doses
doss56235042dos_s
dost57248352dost_
dots55647662do_ts
dusts65923562dusts
easts57530322easts
eposes84418782eposes
fasts86429682fasts
fests85828042fests
fists85527542fists
foists95413982foists
fonts86124752fonts
foots85528282foots
forts86034452forts
foss76431642fos_s
frosts94214622frosts
gasts66628632gasts
gests66028812gests
ghosts10489272ghosts
gists66026192gists
glosts74513812glosts
goats65527302goats
gouts64826172gouts
gusts65722792gusts
hests85829932hests
hists86328372hists
hoists95516022hoists
holts85627912holts
hoots84830252hoots
horsts95817512horsts
hoses85443172hoses
host77852832host_
hosta85917832hosta
hostas94515822hostas
hots78349332ho_ts
imposts11269002imposts
jests125922452jests
joists134711032joists
jolts125018882jolts
joss115925592jos_s
jots116336142jo_ts
jousts135011272jousts
justs124918262justs
kists95822112kists
koss85224812kos_s
lasts57731262lasts
lists56628692lists
lofts85518362lofts
loots55431422loots
loses56742012loses
loss45337962los_s
lost47951492lost_
lots47652092lo_ts
louts56330272louts
lusts55022802lusts
masts77035762masts
mists76633902mists
moats75827642moats
molts76032092molts
moots75831662moots
morts75533562morts
mosks116117002mosks
moss67641032mos_s
most66554202most_
moste75925082moste
mots66853162mo_ts
motts76527002motts
musts75527442musts
nests55728002nests
noses55435642noses
nowts86915862nowts
oasts56529182oasts
oats46554212_oats
oots46446442_oots
opts68124742_opts
orts46538332_orts
oses46641512_oses
ousts55225702ousts
outs45746962_outs
pacts95125802pacts
pants76536922pants
parts77743372parts
pases75346502pases
pass65239952pas_s
past65959012past_
pasta76624532pasta
pastas85422872pastas
paste74932952paste
pastes85233912pastes
pastis84924322pastis
pasty105725052pasty
pats66460852p_ats
peats76140192peats
pelts76128812pelts
pesos77221622pesos
pest65555292pest_
pesto75723722pesto
pestos84719082pestos
pesty106421712pesty
pets66248332p_ets
phots105418502phots
phuts104613502phuts
pints75936222pints
pisos76021062pisos
piss65033332pis_s
piste75824602piste
pistes85325632pistes
pits66348742p_its
plats75531372plats
plots75025672plots
pocks135022962pocks
pods76540152po_ds
poems95715552poems
poet65552902poet_
points85618532points
pois66539042po_is
poises84226542poises
pokes116133012pokes
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562po_ls
polys105718762polys
pomes94833932pomes
pomos95321582pomos
pomps115316192pomps
poms87037742po_ms
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602po_ns
pontes83627852pontes
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poos65949112po_os
popes95933812popes
pops86340952po_ps
pores75849032pores
porks115124142porks
porns75527342porns
port66059632port_
pose66441732pos_e
posed85828412posed
poser75128772poser
posers84223972posers
posh95427322pos_h
posies84431432posies
posit75833332posit
posse74722272posse
posses85128802posses
possets94212772possets
postal84317532postal
postals93716372postals
posted93722492posted
poster84129172poster
posters93928012posters
postie84123962postie
posties93128812posties
postin83521032postin
postins93721202postins
postop10511942postop
postops11311712postops
posy96028422pos_y
pot58078432po_t_
potsy105815612potsy
potto75320942potto
pottos84615872pottos
potty105621002potty
poufs105616062poufs
poults84613482poults
pours74623182pours
pout65752552pout_
pouty107018812pouty
pows95537662po_ws
poxes145325722poxes
prats76333392prats
prests84021262prests
proses84733472proses
prosos85718552prosos
pross76529402pros_s
prost75434102prost_
psis68120342p_sis
psoas75012982psoas
psst66118402psst_
pst57932512p_st_
ptoses83514672ptoses
ptosis83611822ptosis
punts75828002punts
puses75532202puses
puss64830132pus_s
puts65641752p_uts
putts75719272putts
pyoses114314302pyoses
pyosis114012122pyosis
rests54935872rests
riposts9279402riposts
roasts64915412roasts
roosts64916322roosts
roots55933672roots
roses56445772roses
rosets65819952rosets
rots46454092ro_ts
rousts617016722rousts
routs57133412routs
rusts55026992rusts
softs85019232softs
soots55536212soots
sorts54536662sorts
sots45552452so_ts
sports84619182sports
spots74424112spo_ts
spouts85115112spouts
tests56530192tests
toasts65914992toasts
tofts84919242tofts
toits55327472toits
toots55331872toots
torts56138122torts
toss45637972tos_s
tost48351922tost_
tots46654122to_ts
touts54830392touts
vasts86423772vasts
vests85325982vests
volts85421292volts
wasts87433672wasts
wests85727002wests
wists86728522wists
wonts87621542wonts
worsts96014332worsts
worts88631182worts
wost76544362wost_
wots76342892wo_ts
xysts15558122xysts
zests145419742zests

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 Filter178691538000.0931921408.6
2DLD Change Limit538002832.59320748.2
3Display Results2832830.0763723.7
 (SQL Overall)1786912832.76264696.2
 
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.