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

316 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
peans7543764(None) 
beans75734691beans
deans66131391deans
jeans126022111jeans
leans55536251leans
means75831231means
paeans85118261paeans
pans65855731p_ans
peags86122841peags
peaks114825621peaks
peals75235491peals
pean66147171pean_
pears75138611pears
peas65755061pea_s
peats76140191peats
pecans101515831pecans
peens76428191peens
peins76128061peins
pekans121710551pekans
pens65649641pe_ns
peons75327181peons
pians75126961pians
plans75731271plans
speans85417141speans
weans85326741weans
yeans86624881yeans
aeons57624652aeons
alans55636172alans
azans146516882azans
bans66555142_bans
beads85429502beads
beaks115326622beaks
beams95328172beams
bean66443862bean_
beano75421552beano
beanos85516512beanos
bears75739042bears
beats76042242beats
beaus75127112beaus
bens65945702be_ns
brans75437432brans
cans65050852_cans
clans75031012clans
cleans85817052cleans
cyans105714812cyans
dans56748152_dans
deads75726912deads
deals65435342deals
dean56039482dean_
dears65736882dears
dedans85915072dedans
dens55945072de_ns
dewans105215142dewans
earns55927562_earns
ears46356592_ears
eats47054872_eats
elans55527752elans
ens37245922_e_ns
eons46638712_eons
erns45428232_erns
fans76247372_fans
fears84829392fears
feats86432752feats
fens76139762fe_ns
ferns85220082ferns
flans85327972flans
gears64628692gears
gens55740072ge_ns
glans65125832glans
gleans75014742gleans
grans64832542grans
guans64419442guans
heads95127112heads
heals85733462heals
heaps105223222heaps
hears86737372hears
heats85838402heats
hens75642572he_ns
herns84825582herns
jean116629282jean_
keas86337102kea_s
keens95721182keens
kens85435242ke_ns
kerns94719562kerns
khans124615172khans
koans95818622koans
leads66028492leads
leafs85721182leafs
leaks95923912leaks
lean46345242lean_
leant56737782leant
leaps75522932leaps
learns65513742learns
lears55938732lears
leas45954182lea_s
lemans85316392lemans
lens46146492le_ns
loans56026462loans
mans66354552_mans
meads85425322meads
meals75933382meals
mean65538092mean_
meant76537212meant
meany104620482meany
meats75034052meats
moans74624372moans
naans55815252naans
nans46139402_nans
neaps75618322neaps
nears55529422nears
neats55931902neats
neons55818682neons
oceans81211002oceans
opens76118552ope_ns
pacs85842182p_acs
pads76742962p_ads
paean77222722paean_
paeons83915522paeons
paesans93312692paesans
pagans95717922pagans
pains75138282pains
pals66951352p_als
pams85641762p_ams
pan58466452p_an_
pane64950292p_ane
panes76148692p_anes
pang75336302p_ang
pangs84628672p_angs
pansy105717972p_ansy
pant66061262p_ant
pants76536922p_ants
paps86443452p_aps
pars67560792p_ars
pas58775742p_a_s
pass65239952p_ass
pats66460852p_ats
pavans115715592pavans
pawns108818132pawns
paws96038182p_aws
pays95940222p_ays
pea56657242pea__
peace95026082peace
peaces106324082peaces
peach125422492peach
peag75431342pea_g
peage84723572peage
peages94321852peages
peahens12307572peahens
peak106535202pea_k
peaky145718152peaky
peal68648102pea_l
peanut8318182peanut
peanuts936992peanuts
pear69745232pea_r
pearl75324462pearl
pearls84715392pearls
peart76440752peart
pease75231112pease
peases85229472peases
peat65967932pea_t
peaty105725692peaty
peavy135014842peavy
pecan91919032pecan_
pechans14810502pechans
pechs125516202pechs
pecks135724432pecks
pecs84634102pe_cs
pedals94316032pedals
pedant9319492pedant
pedants10310112pedants
pedes85327292pedes
peds75835252pe_ds
peeks115021112peeks
peels75226422peels
peen65938082peen_
peeps95822362peeps
peers75130272peers
pees65257372pe_es
pegs75531762pe_gs
pehs95625762pe_hs
pein65834942pein_
pekan111613972pekan_
pekes114623562pekes
pekins121812232pekins
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
pen56558842pe_n_
penal75228372penal
penang92511112penang
penangs10268372penangs
pend75934532pe_nd
pends85527192pends
penes75839222penes
penis75129322penis
penna74520202penna
penne75423852penne
penni74617902penni
pennis84315742pennis
penny105119452penny
pent66559072pe_nt
peon65635242peon_
peones83821042peones
peony105717562peony
pepos96620082pepos
peps85134512pe_ps
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
pes57259782pe__s
pesos77221622pesos
pests75933272pests
petals84719812petals
pets66248332pe_ts
pews95731532pe_ws
phons105221142phons
pian66136102pian_
piano76118712piano
pianos84315932pianos
pias66542562pia_s
pinas75434452pinas
pins65558462p_ins
pions75826392pions
pirns76020092pirns
plains85019592plains
plan65833942plan_
plane74929142plane
planes85028082planes
plank115221142plank
planks124116752planks
plant75437112plant
plants84921802plants
plats75531372plats
plays106320772plays
pleads94613952pleads
pleas75627032plea_s
pleats85218592pleats
pleons84213342pleons
pons65850602p_ons
poons75430972poons
porns75527342porns
prams96125512prams
prang84820322prang
prangs94816232prangs
prank115019452prank
pranks124814722pranks
praos74923562praos
prats76333392prats
praus74621752praus
prawns11509022prawns
prays105022432prays
preens85020112preens
punas74826752punas
puns66641482p_uns
pyas96225702pya_s
pyins105815862pyins
pyrans11411062pyrans
queans153110752queans
reads64835272reads
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
redans75421022redans
reins56234562reins
remans84823002remans
roans54926442roans
sans45153362_sans
scans74625102scans
seals54839702seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
sedans74816092sedans
sewans95215902sewans
skeans104512912skeans
spans74528732spans
speaks125114582speaks
spean74620512spean_
spears84019472spears
swans84625012swans
tans46154832_tans
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492tea_s
teats55636812teats
teens56227482teens
tens45647412te_ns
terns55226872terns
trans54933042trans
ulans54921302ulans
vans76236742_vans
veals84926192veals
vegans103910852vegans
veins84620492veins
wans76452272_wans
weals85428742weals
wean75734352wean_
wears86030302wears
weens85224052weens
wens76337932we_ns
yeahs115214552yeahs
yean75834582yean_
yearns9509542yearns
years84527672years
yeas78638422yea_s
yens75832262ye_ns
yuans84613322yuans
zeals145320852zeals
zeins144715392zeins

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.343520965.0
2DLD Change Limit538003161.76630464.3
3Display Results3163160.0933397.8
 (SQL Overall)1786913162.20281149.4
 
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.