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

234 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
peaks11482562(None) 
beaks115326621beaks
leaks95923911leaks
peags86122841peags
peak106535201peak_
peaky145718151peaky
peals75235491peals
peans75437641peans
pears75138611pears
peas65755061pea_s
peats76140191peats
pecks135724431pecks
peeks115021111peeks
perks115325801perks
speaks125114581speaks
teaks94222901teaks
apeak115513452apeak_
araks94820882araks
beads85429502beads
beak106534382beak_
beaky146118022beaky
beams95328172beams
beans75734692beans
bears75739042bears
beats76042242beats
beaus75127112beaus
becks135522012becks
berks115423122berks
bleaks125112432bleaks
breaks124816422breaks
creaks124315962creaks
daks97130602_daks
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
decks124822192decks
desks105913072desks
dhaks13479702dhaks
ears46356592_ears
eats47054872_eats
elks85820032_elks
fears84829392fears
feats86432752feats
fecks145417852fecks
freaks134713062freaks
gears64628692gears
gecks125117092gecks
geeks104915842geeks
heads95127112heads
heals85733462heals
heaps105223222heaps
hears86737372hears
heats85838402heats
hecks145220652hecks
jeans126022112jeans
jerks166514892jerks
keas86337092kea_s
kecks105416572kecks
keeks84717252keeks
kyaks11459162kyaks
leads66028492leads
leafs85721182leafs
leak86233712leak_
leaky125217722leaky
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182lea_s
leeks95318892leeks
leks85427602le_ks
meads85425322meads
meals75933382meals
means75831232means
meats75034052meats
merks114722402merks
neaps75618322neaps
nears55529422nears
neats55931902neats
necks115119332necks
neuks96510862neuks
oaks86527902_oaks
packs135528932packs
pacs85842182p_acs
pads76742952p_ads
paeans85118262paeans
paiks114719852paiks
pals66951352p_als
pams85641762p_ams
pans65855732p_ans
paps86443452p_aps
parks116134462parks
pars67560792p_ars
pas58775742p_a_s
pass65239952p_ass
pats66460852p_ats
paws96038182p_aws
pays95940222p_ays
pea56657242pea__
peace95026082peace
peaces106324082peaces
peach125422492peach
peag75431342pea_g
peage84723572peage
peages94321852peages
peaked136117402peaked
peakish16268872peakish
peal68648102pea_l
pean66147172pea_n
pear69745232pea_r
pearl75324462pearl
pearls84715392pearls
peart76440752peart
pease75231112pease
peases85229472peases
peat65967932pea_t
peaty105725692peaty
peavy135014842peavy
pecans101515832pecans
pechs125516202pechs
peck125730682peck_
pecky165515092pecky
pecs84634102pe_cs
pedals94316032pedals
pedes85327292pedes
peds75835242pe_ds
peek106031432peek_
peels75226422peels
peens76428192peens
peeps95822362peeps
peers75130272peers
pees65257372pe_es
pegs75531762pe_gs
pehs95625762pe_hs
peins76128062peins
pekan111613972pekan
pekans121710552pekans
peke105926202pe_ke
pekes114623562pekes
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
pends85527192pends
penes75839222penes
penis75129322penis
pens65649642pe_ns
peons75327182peons
pepos96620082pepos
peps85134512pe_ps
peres76246642peres
peris75537072peris
perk106232842perk_
perky145319482perky
perms95524512perms
perps95521482perps
pervs105117372pervs
pes57259782pe__s
pesky145911562pesky
pesos77221622pesos
pests75933272pests
petals84719812petals
pets66248332pe_ts
pews95731532pe_ws
phreaks1634542phreaks
pians75126962pians
pias66542552pia_s
picks135226142picks
pikas114218092pikas
pinks115729382pinks
placks144414152placks
planks124116752planks
plans75731272plans
plats75531372plats
plays106320772plays
pleads94613952pleads
pleas75627032plea_s
pleats85218592pleats
pocks135022962pocks
porks115124142porks
prams96125512prams
pranks124814722pranks
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
pucks134322102pucks
punks114822682punks
pyas96225702pya_s
reads64835272reads
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
recks115625132recks
reeks94124032reeks
seals54839702seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
seeks94724642seeks
sneaks104312492sneaks
soaks95220292soaks
speak114618672speak_
speans85417142speans
spears84019472spears
specks144312702specks
steaks104415852steaks
teak85930842teak_
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492tea_s
teats55636812teats
tweaks1335962tweaks
veals84926192veals
weak117126302weak_
weals85428742weals
weans85326742weans
wears86030302wears
weeks125017862weeks
wekas123911792wekas
wreaks134711112wreaks
yaks116025202_yaks
yeahs115214552yeahs
yeans86624882yeans
years84527672years
yeas78638422yea_s
yelks126413622yelks
yerks125416562yerks
yeuks125110092yeuks
zeals145320852zeals
zeks175815062ze_ks
zerks185113822zerks

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.313570897.8
2DLD Change Limit538002341.61033416.1
3Display Results2342340.0633714.3
 (SQL Overall)1786912341.98689975.3
 
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.