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 “optimist” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

399 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
optimist125687(None) 
opticist1248921opticist
optimise1255581optimise
optimism1445211optimism
optimists1345291optimists
intimist10410212intimist
opticists1346432opticists
optimes1148472optimes_
optimised1444312optimised
optimises1346082optimises
optimisms1555222optimisms
optimistic1654302optimistic
optimize2145502optimize
activist13109483activist
animist93815173_animist
atomist92915763_atomist
atticist10811343atticist
intimists1147493intimists
nativist11118683nativist
oghamist1444753oghamist
opiumism1442893opiumism
optician1247243optician
optics102810183opti_cs_
optima10106533optim__a
optimal1145783optim_al
optime1079353optim__e
optimising1544493optimising
optimized2344963optimized
optimizer2244123optimizer
optimizes2245423optimizes
optimum1343353optim_um
optimums1442563optimums
options93810603options_
otitis63612343o_titis_
outmost9511213out_most
palmist112814343_palmist
polemist12412363polemist
routinist949493routinist
satirist8313503satirist
totemist1049033totemist
uptimes1177553uptimes_
vorticist1448173vorticist
zootomist2045863zootomist
actinism12119884actinism
activism15117084activism
activists1497054activists
adoptionist1454974adoptionist
aftmost1244974aft_most
alarmist1049124alarmist
alpinist1059154alpinist
altoist7313394alt_oist
altruist857954altruist
anatomist11119264anatomist
animis84615944_animis_
animism113510214_animism
animists103010634_animists
antimask1446574antimask
antimine10714754antimine
antiriot8414584antiriot
antirust8411184antirust
aphorist13412514aphorist
apiarist10412064apiarist
apomict1349054ap_omict
aptest82917514apt__est
artiest73121994arti_est
artist64125544art__ist
atavist10311094_atavist
atheist10314064_atheist
atomise93013824_atomise
atomism112610964_atomism
atomists102610964_atomists
atticism1268534atticism
atticists1167944atticists
autist64324944aut__ist
baptist11311874bapt__ist
bemist105216964__bemist
betimes115114414betimes_
bigamist1347064bigamist
botanist10412034botanist
catmint11314464cat_mint
ceramist12310934ceramist
chemist143615004_chemist
chymist17268174_chymist
copyist1439054cop__yist
cosmist11311334_cosmist
cutinise1048764cutinise
delimit10311734delimi_t
delimits1137574delimits
digamist1248214digamist
ditheist1249494ditheist
dopiest103315994dop_i_est
dotiest83717454doti_est
dottiest92611394dotti_est
dynamist1445344dynamist
elitist7414914_elitist
emptiest1278104empti_est
entwist1048804ent_wist
epeeist938864ep_eeist
epitomise1345254epitomise
eroticist11712074eroticist
etatist7415034_etatist
ethicist1347894ethicist
euphemist16126474euphemist
exoticist1887994exoticist
extremist1896254extremist
fatalist11314974fatalist
feminist131911334feminist
fetishist1543714fetishist
footiest113514914footi_est
futurist1148284futurist
gnomist1049134_gnomist
goutiest93013884gouti_est
grimiest11299824_grimiest
haimish1537754_haimish
heimish1535464_heimish
homilist13410034homilist
hootiest113115644hooti_est
hoppiest152610734hoppi_est
hygieist1543494hygieist
imprimis1444254imprimis_
intimas9119584intimas_
intwist1038044int_wist
itemise997454_itemise
joltiest15249404jolti_est
lapidist1147844lapidist
legitimist1364254legitimist
limiest93716104__limiest
limit73126344__limi_t
limits82514144__limits
loftiest1139084lofti_est
loppiest122410114loppi_est
luminist10410564luminist
lutanist8410274lutanist
lutenist8610664lutenist
lutist64317554lut__ist
lyricist13718984lyricist
marimbist1543894marimbist
matiest92522454mati_est
maximise1944914maximise
metalist10519354metalist
metrist9317064met_rist
minimise1246864minimise
mist66154544____mist
mitiest93520054miti_est
mopiest113014294mop_i_est
mosaicist1346024mosaicist
motorist10314414motorist
nativism13116614nativism
nativists12116254nativists
naturist8410814naturist
nihilist1147164nihilist
nontheist1248324nontheist
northmost1454304northmost
oakiest112913924oaki_est
obiism1036364o_bi_ism
oboist8312684o__boist
obtest81213014obt__est
obtusest1044574obtusest
octrois938344octrois_
oculist9310884o_culist
odist6421914o___dist
oftenest1148864oftenest
oftest91212004oft__est
ofttimes1343124ofttimes_
oghamists1543034oghamists
oiliest72817684oili_est
oiticica1244084oiticica
ologist8313834o_logist
omit65337374o___mi_t
omits75018264o___mits
onanist7314634o_nanist
oologist9313494oologist
ootids71110354ooti_ds_
ooziest163411524oozi_est
opaquest1943224opaquest
opencast1244874opencast
openest9312914op_enest
ophidian1444364ophidian
ophites12310104ophites_
ophitic1439214ophiti_c
opines84820704op_ines_
opining10311754op_ining
opinion946794op_inion
opioid9310084op_ioi_d
opioids1036524op_ioids
opiumisms1542634opiumisms
opiums10307074op_iums_
oppilant1246024oppilant
opsins8411714opsi_ns_
optative1347654optative
optic93715184opt__i_c
optical1149864opti_cal
opticians1345544opticians
optimality1753354optimality
optimally1644564optimally
optimisation16193944optimisation
optimizers2343024optimizers
optimizing2445264optimizing
opting94514404opt__ing
option83612714opt__ion
optional1047644optional
optioned1146384optioned
optionee1046514optionee
optioning1246554optioning
optometrist1554444optometrist
opts68124744opt___s_
oralist7619634o_ralist
orbiest9312414orbi_est
organist9411544organist
orgiast837464orgi_ast
oribis838834o_ribis_
orpiment1247974orpiment
orthotist1246724orthotist
osteitis847024osteitis_
ostomies10310584ostomies
ostosis71310124ostosis_
otiose639404o_ti_ose
otiosity1155764o_tiosity
otitic83112684o_titi_c
otitises839164o_titises
otocyst1244834o_tocyst
outboast1048544outboast
outbuilt1046874outbuilt
outburst1046844outburst
outcast91013744out_cast
outermost1146134outermost
outfast101412124out_fast
outfeast11107504outfeast
outfish132210574out_fish
outfit93014954out_fi_t
outfits102210834out_fits
outhit92818474out_hi_t
outhits102213504out_hits
outings84014754outings_
outkiss1137784out_kiss
outlast71015444out_last
outpaint10311774outpaint
outpoint10311514outpoint
outpost9612444out_post
outraise8311934outraise
outsit63620894out_si_t
outsits73215254out_sits
outskirt1246644outskirt
outsmart10168924outsmart
outsmelt10138164outsmelt
outsmile1046974outsmile
outwait10411764outwai_t
outwaits1137494outwaits
outwish13289854out_wish
outwit93014594out_wi_t
outwits103110864out_wits
outwrit10411424outwri_t
overoptimist1963594overoptimist
oxidise1545044o_xidise
oximes15107424o_ximes_
oxims14107644o_xim_s_
pacifist1548094pacifist
palmiest123212034_palmiest
palmists12268814_palmists
papist102618754_p_apist
permit10321684_permi_t
permits11314004_permits
persist9315854_persist
pessimist1345274pessimist
pianist9615104_pianist
pietist9414034_pietist
pikis115116394_p_ikis_
pilis75825204_p_ilis_
pimas94725104_p_imas_
pimps114616984_p_imps_
piniest93121134_p_iniest
pipiest113114504_p_ipiest
pipit95224874_p_ipi_t
pipits104713064_p_ipits
pithiest132711444_pithiest
plenist9314334_plenist
plumiest122110294_plumiest
poeticism1548334poeticism
pogromist1445314pogromist
pokiest133314914poki_est
polemists1348604polemists
politest10312944politest
pollist9816604_pollist
poloist91016324_poloist
populist1248204populist
positivist1565684positivist
posturist11410444posturist
potamic13310854potami_c
potions93417424potions_
pottiest102815974pottiest
poutiest103016794pouti_est
poxiest163412254poxi_est
premise113818554_premise
premiss113513814_premiss
premixt183510664_premixt
priciest122112904_priciest
priest84125424_pri_est
primas104418104_primas_
primes104225264_primes_
primi95017404_primi__
primine113214824_primine
priming123417374_priming
primmest14226694_primmest
primos104514424_primos_
primps124711824_primps_
prims95425934_prim_s_
primsie1137544_primsie
primus103712174_primus_
priviest132310314_priviest
promise113415844_promise
protist9320224_protist
psalmist1276354psalmist
ptosis83611824_ptosis_
pugilist11136634pugilist
purist85525054_p_urist
retimes95020174retimes_
retiming113014194retiming
retwist1039484ret_wist
rhythmist2053344rhythmist
rimiest93215854__rimiest
rootiest83115594rooti_est
ropiest93317774rop_i_est
routinism1146574routinism
routinists1046094routinists
satanist8313374satanist
satirise8310684satirise
satirists958924satirists
semimoist1345614semimoist
semitist10413324semitist
septimes1238304septimes_
shitlist1148724shitlist
sitarist8315284sitarist
slimiest10310754_slimiest
sodomist1157634sodomist
sootiest84016754sooti_est
sophist12311574sop__hist
soppiest122511944soppi_est
spiciest122711614sp_iciest
spikiest14259544sp_ikiest
spiniest102813234sp_iniest
spiriest102513464sp_iriest
spirit83519924sp_iri_t
spiritist1148094spiritist
spirits94112624sp_irits
spriest92718654spri_est
spumiest1238214spumiest
statist7317724_statist
stimes85920574_stimes_
stimied10310624_stimied
stimies9316564_stimies
stylist102110284_stylist
surimis938844surimis_
tamest85721294__tamest
tamis76728734__tamis_
tanist6324614__tanist
tatamis939724tatamis_
theist9314764__theist
tidiest83514874__tidiest
tikis95615974__tikis_
times75630824__times_
timid84815734__timi_d
timidest1136934__timidest
timing93619304__timing
tiniest73020124__tiniest
tipis76019924__tipis_
titis56023814__titis_
titlist7312924__titlist
topmast1138124top__mast
topmost1148174top__most
toponymist1753314toponymist
totalist8315584totalist
totemism1245434totemism
totemists1146374totemists
tubist83013164__tubist
twist86820984__t_wist
typist1139824__typist
ultimas936364ultimas_
ultraist849634ultraist
untidiest1046034untidiest
untwist1047714unt_wist
upmost1068194up__most
upthrust1343714upthrust
upticks1535154upticks_
uptight13176034upti_ght
uptilt8410804upt__ilt
uptilts934734uptilts_
uptime1067674uptim__e
utilise749064_utilise
utmost878484_ut_most
utopist938694_utopist
vibist11610584__vibist
victimise1674134victimise
vitalist11313394vitalist
vorticism1646394vorticism
vorticists1546084vorticists
votarist111012164votarist
waitlist1147744waitlist
zootiest173311214zooti_est
zootomists2144434zootomists

Search took 28 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 Filter1786911616090.936190909.2
2DLD Change Limit16160939926.5166094.8
3Display Results3993990.1732306.4
 (SQL Overall)17869139927.6256468.5
 
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.