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

251 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
peag7543134(None) 
pea56657241pea_
peage84723571peage
peags86122841peags
peak106535201peak
peal68648101peal
pean66147171pean
pear69745231pear
peas65755061peas
peat65967931peat
peg65843061pe_g
ag311067462__ag
apeak115513452apeak
bag67059222_bag
bead75937922bead
beak106534382beak
beam86939232beam
bean66443862bean
bear66844642bear
beat66168302beat
beau66137272beau
beg65944132be_g
berg75425542berg
brag75229722brag
clag75924572clag
crag75625302crag
dag57753012_dag
dead65434242dead
deaf85838402deaf
deal56347412deal
dean56039482dean
dear55343602dear
debag94212302debag
drag64825052drag
ear36867882_ear
eat36989052_eat
eau37450942_eau
egg56918672_egg
eng46726782_eng
erg45531072_erg
fag76852362_fag
feal713940422feal
fear75337792fear
feat76458222feat
flag87427082flag
frag85126272frag
gag57753632_gag
gear55934972gear
hag77255742_hag
head87137172head
heal75645692heal
heap96432892heap
hear76143882hear
heat77061422heat
jag116542712_jag
jean116629282jean
kea76540912kea_
keas86337092keas
keg86432542ke_g
lag47862122_lag
lea37660182lea_
lead56038852lead
leaf76441032leaf
leak86233712leak
leal46043272leal
lean46345242lean
leap66032682leap
lear47045952lear
leas45954182leas
leg46446112le_g
mag67956482_mag
mead75531602mead
meal65643172meal
mean65538092mean
meat66359602meat
meg66040952me_g
mega77620872mega
nag46450812_nag
neap66927012neap
near45236502near
neat46356782neat
neg47237342ne_g
pa410456482p_a_
pac79054082p_ac
pad68057322p_ad
paean77222722paean
page76036102p_age
pah88853592p_ah
pal56761672p_al
pam77858392p_am
pan58466452p_an
pang75336292pang
pap76758402p_ap
par57467022p_ar
pas58775742p_as
pat58089462p_at
paw87651172p_aw
pax127346852p_ax
pay88461182p_ay
pe47649032pe__
peace95026082peace
peach125422492peach
peages94321852peages
peaks114825622peaks
peaky145718152peaky
peals75235492peals
peans75437642peans
pearl75324462pearl
pears75138612pears
peart76440752peart
pease75231112pease
peats76140192peats
peaty105725692peaty
peavy135014842peavy
pec76744412pe_c
pecan91919032pecan
pech116125452pech
peck125730682peck
pecs84634102pecs
ped66751522pe_d
pedal86022502pedal
peds75835242peds
pee56066512pe_e
peed76239182peed
peek106031432peek
peel65535612peel
peen65938082peen
peep85833692peep
peer66238352peer
pees65257372pees
pegs75531762pegs
peh86740962pe_h
pehs95625762pehs
pein65834942pein
pekan111613972pekan
peke105926202peke
pelage9515362pelage
pele65539552pele
pelf97031452pelf
pelt67651082pelt
pen56558842pe_n
penal75228372penal
penang92511112penang
pend75934532pend
pengo84317592pengo
pens65649642pens
pent66559072pent
peon65635242peon
pep76447082pe_p
pepo87622152pepo
peps85134512peps
per56353092pe_r
pere66450262pere
peri65636972peri
perk106232842perk
perm85834632perm
perp89029892perp
pert66759322pert
perv97224812perv
pes57259782pe_s
peso66925822peso
pest65555292pest
pet56477302pe_t
petal76526892petal
pets66248332pets
pew86442302pe_w
pews95731532pews
phage115113672phage
phat95837862phat
pia56848032pia_
pial65636702pial
pian66136092pian
pias66542552pias
pig65744972p_ig
ping75943592ping
plage84520402plage
plan65833942plan
plat66048872plat
play95928982play
plea66830602plea_
plead85818462plead
pleas75627032pleas
pleat74734472pleat
plug74915992plug
pong76231142pong
pram85733492pram
prang84820322prang
prao66229022prao
prat65952042prat
prau66529472prau
pray96331532pray
prig75924872prig
prog75729002prog
pug65337182p_ug
pung75429632pung
pya87023752pya_
pyas96225702pyas
quag144815942quag
rag45761322_rag
read55942532read
real45750292real
ream65841612ream
reap65934742reap
rear45644552rear
reg46146492re_g
retag63618412retag
sag46163402_sag
scag76626892scag
sea36161292sea_
seal45654372seal
seam66645972seam
sear47353842sear
seas45755272seas
seat47575562seat
seg45544882se_g
shag86430562shag
skag96321512skag
slag55934352slag
snag55827872snag
speak114618672speak
spean74620512spean
spear75821062spear
sprag86418692sprag
stag57332002stag
swag87526732swag
tag47259492_tag
tea37353322tea_
teak85930842teak
teal45546502teal
team66238652team
tear45242882tear
teas45851492teas
teat45963632teat
teg45741622te_g
tegg65315922tegg
veal76936812veal
veg76931062ve_g
wag76451752_wag
weak117126302weak
weal75838682weal
wean75734352wean
wear75836722wear
yag76947732_yag
yea66445752yea_
yeah106725412yeah
yean75834582yean
year76534252year
yeas78638422yeas
yegg96511792yegg
zag137539472_zag
zeal135530332zeal

Search took 2 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 Filter178691298720.263679433.5
2DLD Change Limit298722510.78338150.7
3Display Results2512510.0633984.1
 (SQL Overall)1786912511.109161128.0
 
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.