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

377 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
peanut831818(None) 
peanuts936991peanuts
beaut75135212bea_ut
leant56737782lean_t
meant76537212mean_t
pant66061262p_an_t
pean66147172pean__
peans75437642pean_s
peart76440752pea_rt
peat65967932pea__t
pedant9319492pedan_t
pent66559072pe_n_t
penult8314652pe_nult
pignut9311572pignut
planet84228352planet
plant75437112plan_t
abut66834953__abut
alant55742293alan_t
ant37270793__an_t
anus47131113__anus
aunt46553653__aunt
avant86224663avan_t
avaunt959603avaunt
bean66443863bean__
beaned95621473beaned
beanie83618593beanie
beano75421553bean_o
beanos85516513beanos
beans75734693bean_s
beast76338643bea_st
beat66168303bea__t
beau66137273bea_u_
beaus75127113bea_us
beauts86015283bea_uts
beauty115410163bea_uty
beaux146513213bea_ux
beknot1239763beknot
bennet84823363bennet
bent67759913be_n_t
besmut10310653besmut
bezant17814543bezan_t
brant74742173bran_t
breadnut1144883breadnut
canst74932213_canst
cant66362033_can_t
caput9823983_caput
cent67451013ce_n_t
centu76119413ce_ntu
chant105932693chan_t
chaunt11613493chaunt
cleanup1144083cleanup
cobnut10311323cobnut
daunt65929083_daunt
daut56443563_da_ut
dealt65234283dea_lt
dean56039483dean__
deaned84620453deaned
deans66131393dean_s
debut86024143de_but
decant93524223decan_t
dent57158413de_n_t
devout10712993devout
donut6324513_donut
east46659103_ea_st
eat36989053_ea__t
eau37450943_ea_u_
eaux116618423_ea_ux
enact73525363_enact
ennui537523_ennui
enuf7323843_e_nuf
epact94921533epa_ct
fanum10313443_fanum
feast85932723fea_st
feat76458223fea__t
feint84732253fein_t
flaunt9712913flaunt
gamut8322983_gamut
gaunt65430403_gaunt
gelant72821673gelan_t
genet66038683ge_net
gent56954393ge_n_t
genu55929073ge_nu_
genua64614153ge_nua
genus65319833ge_nus
ghaut95919433gha_ut
giant65430593gian_t
grant64840023gran_t
granum9310913granum
hant75461593_han_t
haunt85229133_haunt
haut75949733_ha_ut
heart85440743hea_rt
heat77061423hea__t
hent76656383he_n_t
hognut1039413hognut
jaunt125025273_jaunt
jean116629283jean__
jeaned143813463jeaned
jeans126022113jean_s
jennet134714953jennet
kaput11717063_kaput
kent86846963ke_n_t
kraut95221403kra_ut
league758743league
lean46345243lean__
leaned73422543leaned
leaner64022193leaner
leanest7415863leanest
leanly93811503leanly
leans55536253lean_s
leapt75027473lea_pt
learnt64019253learnt
least56134883lea_st
lent46360533le_n_t
levant9314493levan_t
manat76039993_manat
manus75924933_manus
maut65448453_ma_ut
mean65538093mean__
meaner84617843meaner
meanest9315703meanest
meanie83718393meanie
meanly115412043meanly
means75831233mean_s
meany104620483mean_y
meat66359603mea__t
meatus85112923meatus
menu65130233me_nu_
menus75822843me_nus
neat46356783nea__t
nut36651963___nut
oceanaut1043763oceanaut
operant9317223operan_t
pact86648723p_a_ct
paean77222723paean__
paeans85118263paean_s
pageant10312783pagean_t
paint75443693p_aint
palet74650803p_alet
pan58466453p_an__
panda85022613p_anda
pandit93820753p_andit
pandy115021173p_andy
pane64950293p_an_e
paned85437183p_aned
panel76023623p_anel
panes76148693p_anes
panful1179743p_anful
pang75336293p_an_g
panga85323533p_anga
pangs84628663p_angs
panic93923903p_anic
panne76623653p_anne
pans65855733p_an_s
pansy105717973p_ansy
panto76129413p_anto
pants76536923p_ants
panty105929303p_anty
part65967463p_a_rt
past65959013p_a_st
pat58089463p_a__t
payout11714653payout
pea56657243pea___
peace95026083pea_ce
peaced115818913peaced
peaces106324083peaces
peach125422493pea_ch
peachy164510843peachy
peacoat11412913peacoat
peag75431343pea__g
peage84723563pea_ge
peages94321843peages
peags86122843pea_gs
peahen113410133peahen
peak106535203pea__k
peaked136117403peaked
peaks114825623pea_ks
peaky145718153pea_ky
peal68648103pea__l
pealed95322803pealed
peals75235493pea_ls
pear69745233pea__r
pearl75324463pea_rl
pearls84715393pearls
pearly116414843pearly
pears75138613pea_rs
peas65755063pea__s
peasant9314923peasant
pease75231113pea_se
peasen84815963peasen
peases85229473peases
peats76140193pea_ts
peaty105725693pea_ty
peavey14398793peavey
peavy135014843pea_vy
pecan91919033pecan__
pecans101515833pecan_s
peccant13311733peccan_t
pedants10310113pedants
peen65938083peen__
peened94318153peened
peens76428193peen_s
peepul1035783peepul
peewit111110903peewit
pein65834943pein__
peined94918843peined
peins76128063pein_s
pekan111613973pekan__
pekans121710553pekan_s
pellet83326553pellet
pelmet103419243pelmet
pelt67651083pe__lt
pen56558843pe_n__
penal75228373pe_nal
penalty1267743penalty
penance11313443penance
penang92511113penang
penangs10268373penangs
pence94924453pe_nce
pend75934533pe_n_d
pendant10314853pendan_t
pends85527193pe_nds
penes75839223pe_nes
pengo84317593pe_ngo
penis75129323pe_nis
penna74520203pe_nna
pennae84314033pennae
pennant9312493pennant
pennate93314033pennate
penne75423853pe_nne
penned94217613penned
penner84616663penner
penni74617903pe_nni
pennia84412973pennia
pennis84315743pennis
pennon8310643pennon
penny105119453pe_nny
pens65649643pe_n_s
penults937123pe_nults
penury1148103pe_nury
peon65635243peon__
peones83821043peones
peons75327183peon_s
peony105717563peon_y
peplum12156823peplum
peplus10138343peplus
perdu84216273perdu_
perdue93912633perdue
perdus93711273perdus
permit10321683permit
permute1138793permute
pernio8513143pernio
pernod9310453pernod
pert66759323pe__rt
pest65555293pe__st
pet56477303pe___t
petasus946363petasus
petit74332653pe_tit
petnap1037423petnap
pewit104622793pe_wit
phat95837863pha__t
phut96925973p__hut
pian66136093pian__
pianic103714123pianic
pianist9615103pianist
piano76118713pian_o
pianos84315933pianos
pians75126963pian_s
pignus937953pignus
pignuts1035613pignuts
pigout9314613pigout
pinot78737293p_inot
pint66963173p_in_t
pinup9612883p_inup
placet103923673placet
plague93610853plague
plaguy12386413plaguy
plaint85323203plaint
plait75631573pla_it
plan65833943plan__
planar84212713planar
planate9314573planate
planch133711443planch
plane74929143plan_e
planed94420913planed
planer84122653planer
planes85028083planes
planets93914083planets
plank115221143plan_k
planks124116753planks
plans75731273plan_s
plants84921803plants
planula935773planula
plaque17317643plaque
plat66048873pla__t
pleat74734473plea__t
plenum1039503plenum
pliant83918823plian_t
point75338733poin_t
pout65752553p__out
prahu105013973prahu_
prahus11458243prahus
prance104318573prance
prang84820323pran_g
prangs94816233prangs
prank115019453pran_k
pranks124814723pranks
prat65952043pra__t
prau66529473pra_u_
praus74621753pra_us
preact103220393prea_ct
preadult1146973preadult
preanal9310713preanal
precut102016533precut
print74837463prin_t
prunus8399363prunus
punnet83518843punnet
punt65747203p_un_t
put55759073p___ut
putout8315113putout
qanat144426843_qanat
quant143624813quan_t
rant45864683_ran_t
react74634333rea_ct
readout8615513readout
rebut75927383re_but
recant83228683recan_t
recut74729243re_cut
redout71820253redout
regnum957163regnum
reknit10312533reknit
reknot10311733reknot
rennet64624853rennet
rent46661243re_n_t
riant55833153rian_t
scant79735073scan_t
seance83716683seance
seat47575563sea__t
secant84023293secan_t
sejant133114483sejan_t
sennet64224143sennet
sennit63117923sennit
sent46963013se_n_t
setout64719463setout
slant55238703slan_t
spean74620513spean__
speaned103411523speaned
speans85417143spean_s
spent75532833spe_n_t
taunt55532283_taunt
taut47048963_ta_ut
teacup1036253teacup
teapot8416763teapot
teat45963633tea__t
telnet6518833telnet
tenant6322473tenant
tenet55542213te_net
tent46159863te_n_t
tenuti638973te_nuti
tenuto648743te_nuto
tetanus737933tetanus
vaunt85925313_vaunt
vent76049053ve_n_t
venue84918213ve_nue
venus84918903ve_nus
walnut939433walnut
want76156173_wan_t
wean75734353wean__
weaned103816153weaned
weaner93816773weaner
weans85326743wean_s
went76051873we_n_t
yean75834583yean__
yeaned103813903yeaned
yeans86624883yean_s
yeast85327943yea_st
zealot15313473zealot

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163775.68619823.4
3Display Results3773770.1103427.3
 (SQL Overall)1786913775.93630102.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.