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

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

277 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
peanuts93699(None) 
peanut8318181peanut_
beauts86015282bea_uts
pants76536922p_an_ts
peans75437642pean__s
peats76140192pea__ts
pedants10310112pedan_ts
penults937122pe_nults
pignuts1035612pignuts
planets93914082planets
plants84921802plan_ts
abuts75417073__abuts
alants67722023alan_ts
ants47243473__an_ts
anus47131113__anu_s
aunts55227633__aunts
beanies93821093beanies
beanos85516513bean_os
beans75734693bean__s
beasts84519723bea_sts
beats76042243bea__ts
beaus75127113bea_u_s
beaut75135213bea_ut_
beauty115410163bea_uty
beknots1335083beknots
bennets94712163bennets
bents76033693be_n_ts
besmuts1134683besmuts
bezants1877343bezan_ts
brants85723053bran_ts
breadnuts1243143breadnuts
cants77036943_can_ts
cantus85117763_cantus
cents74730333ce_n_ts
chants115020393chan_ts
chaunts1267083chaunts
cleanups1242203cleanups
cobnuts1135353cobnuts
daunts75014083_daunts
dauts67822243_da_uts
deans66131393dean__s
debuts93911753de_buts
decants103514443decan_ts
dents65031803de_n_ts
donuts7410583_donuts
easts57530323_ea_sts
eats47054873_ea__ts
enacts84012973_enacts
ennuis636473_ennuis
epacts105010393epa_cts
fanums1137263_fanums
feasts95116093fea_sts
feats86432753fea__ts
feints94813873fein_ts
flaunts1056133flaunts
gamuts958783_gamuts
gelants82611443gelan_ts
genets75716663ge_nets
gents65729613ge_n_ts
genus65319833ge_nu_s
ghauts10447783gha_uts
giants74713503gian_ts
grants73722473gran_ts
hants86335403_han_ts
haunts95614393_haunts
hearts96218943hea_rts
heats85838403hea__ts
hents87330743he_n_ts
hognuts1134183hognuts
jaunts137511883_jaunts
jeans126022113jean__s
jennets14517633jennets
krauts10418513kra_uts
leagues837943leagues
leaners73718173leaners
leanest7415863leanest
leans55536253lean__s
leant56737783lean_t_
leasts64616413lea_sts
levants1037723levan_ts
manats84623463_manats
manus75924933_manu_s
mauts75927193_ma_uts
meaners94415243meaners
meanest9315703meanest
meanies93620743meanies
means75831233mean__s
meant76537213mean_t_
meats75034053mea__ts
meatus85112923meatu_s
menus75822843me_nu_s
neats55931903nea__ts
nuts45032673___nuts
oceanauts1141773oceanauts
operants1039483operan_ts
pacts95125803p_a_cts
paeans85118263paean__s
pageants1136693pagean_ts
paints85921833p_aints
palets85122313p_alets
pandas95521963p_andas
pandits103914213p_andits
panels84716523p_anels
panes76148693p_an_es
panfuls1237173p_anfuls
pangas99921113p_angas
pangs84628673p_an_gs
panics103815363p_anics
pannes85522853p_annes
pans65855733p_an__s
pant66061263p_an_t_
panto76129413p_an_to
pantos85222743p_antos
panty105929303p_an_ty
parts77743373p_a_rts
pasts75936503p_a_sts
pats66460853p_a__ts
payouts1247303payouts
peaces106324083pea_ces
peaches144120053peaches
peacoats1247833peacoats
peages94321853pea_ges
peags86122843pea__gs
peahens12307573peahens
peaks114825623pea__ks
peals75235493pea__ls
pean66147173pean___
pearls84715393pea_rls
pears75138613pea__rs
peart76440753pea_rt_
peas65755063pea___s
peasants1038263peasants
peases85229473pea_ses
peat65967933pea__t_
peaty105725693pea__ty
peaveys15324063peaveys
peavies122213403peavies
pecans101515833pecan__s
pedant9319493pedan_t_
peens76428193peen__s
peepuls1134923peepuls
peewits12105873peewits
peins76128063pein__s
pekans121710553pekan__s
pellets94014783pellets
pelmets11309693pelmets
pelts76128813pe__lts
penalty1267743penalty
penances12312443penances
penangs10268373penangs
penates93321603penates
pendants1139093pendan_ts
pends85527193pe_n_ds
penes75839223pe_n_es
pengos94612413pe_ngos
penis75129323pe_n_is
pennants1037063pennants
pennate93314033pennate
penners93414183penners
pennies94218813pennies
pennis84315743pe_nnis
pennons939713pennons
pens65649643pe_n__s
pent66559073pe_n_t_
penult8314653pe_nult
penury1148103pe_nury
peones83821043peon_es
peonies93620153peonies
peons75327183peon__s
peplums13145503peplums
peplus10138343peplu_s
percuss1137163percuss
perdues103511333perdues
perdus93711273perdu_s
peritus9311803peritus
permits11314003permits
permute1138793permute
permutes1238713permutes
pernods1038483pernods
pests75933273pe__sts
petasus946363petasu_s
petnaps1145033petnaps
pets66248333pe___ts
petuntse1042473petuntse
pewits112810683pe_wits
phuts104613503p__huts
pianist9615103pianist
pianists1049013pianists
pianos84315933pian_os
pians75126963pian__s
pignus937953pignu_s
pignut9311573pignut_
pigouts1037593pigouts
pinots85920273p_inots
pints75936223p_in_ts
pinups1037413p_inups
placets113911223placets
plagues103311063plagues
plaints94012053plaints
plaits83816473pla_its
planate9314573planate
planers94517943planers
planes85028083plan_es
planet84228353planet_
planks124116753plan_ks
plans75731273plan__s
plant75437113plan_t_
planula935773planula
plaques18317893plaques
plats75531373pla__ts
pleats85218593plea__ts
plenums1136533plenums
points85618533poin_ts
pouts75530323p__outs
prahus11458243prahu_s
prances113618773prances
prangs94816233pran_gs
pranks124814723pran_ks
prats76333393pra__ts
praus74621753pra_u_s
preacts113211363prea_cts
preadults1244283preadults
precuts111710473precuts
prints84320103prin_ts
prunus8399363prunu_s
punnets9409263punnets
punts75828003p_un_ts
putouts937083putouts
puts65641753p___uts
qanats154112813_qanats
quants153614143quan_ts
rants55935343_ran_ts
reacts83616603rea_cts
readouts938903readouts
rebuts84015193re_buts
recants93217093recan_ts
recuts83817373re_cuts
redouts81411663redouts
reknits1137073reknits
reknots1136783reknots
rennets75212633rennets
rents55935183re_n_ts
scants85219723scan_ts
seances93015343seances
seats54844343sea__ts
secants93413893secan_ts
sennets73712583sennets
sennits73811283sennits
setouts74110333setouts
slants64819083slan_ts
speans85417143spean__s
taunts65715663_taunts
tauts56125513_ta_uts
teacups1133963teacups
teapots939053teapots
teats55636813tea__ts
telnets738373telnets
tenants7311013tenants
tenets65518953te_nets
tents56434213te_n_ts
tenues63816443te_nues
tenuis64213083te_nuis
tenuti638973te_nuti
tenuto648743te_nuto
tenutos736623te_nutos
tetanus737933tetanu_s
vaunts95212623_vaunts
vents86125933ve_n_ts
venues95115203ve_nues
venus84918903ve_nu_s
walnuts1033843walnuts
wants87932213_wan_ts
weaners104613833weaners
weans85326743wean__s
yeans86624883yean__s
yeasts96413053yea_sts
zealots1636763zealots

Search took 8 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 Filter1786911340270.440406115.9
2DLD Change Limit1340272776.65320145.3
3Display Results2772770.0962885.4
 (SQL Overall)1786912777.18924856.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.