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

229 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
peags8612284(None) 
peag75431341peag_
peage84723571peage
peages94321851peages
peaks114825621peaks
peals75235491peals
peans75437641peans
pears75138611pears
peas65755061pea_s
peats76140191peats
pegs75531761pe_gs
ags47551662__ags
bags76645502_bags
beads85429502beads
beaks115326622beaks
beams95328172beams
beans75734692beans
bears75739042bears
beats76042242beats
beaus75127112beaus
begs75733832be_gs
bergs84718042bergs
brags85625102brags
clags85621122clags
crags85622572crags
dags66642602_dags
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
debags104211062debags
degas75119162degas
drags75521112drags
ears46356592_ears
eats47054872_eats
eggs66516152_eggs
engs56121392_engs
ergs55523812_ergs
fags86939122_fags
fears84829392fears
feats86432752feats
flags95321282flags
frags96322172frags
gags66441062_gags
gears64628692gears
hags86740842_hags
heads95127112heads
heals85733452heals
heaps105223222heaps
hears86737372hears
heats85838402heats
jags126132792_jags
jeans126022112jeans
keas86337092kea_s
kegs95824022ke_gs
lags56546222_lags
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182lea_s
legs56133692le_gs
mags75444532_mags
meads85425322meads
meals75933372meals
means75831232means
meats75034052meats
megs75530632me_gs
nags55436022_nags
neaps75618322neaps
nears55529422nears
neats55931902neats
negs55727362ne_gs
pacs85842182p_acs
pads76742952p_ads
paeans85118262paeans
page76036102p_age
pages85235072p_ages
pals66951352p_als
pams85641762p_ams
pangs84628662pangs
pans65855732p_ans
paps86443452p_aps
pars67560792p_ars
pas58775742p_a_s
pass65239952p_ass
pats66460852p_ats
paws96038182p_aws
pays95940222p_ays
pea56657242pea__
peace95026082peace
peaces106324082peaces
peach125422492peach
peak106535202pea_k
peaky145718152peaky
peal68648102pea_l
pean66147172pea_n
pear69745232pea_r
pearl75324462pearl
pearls84715392pearls
peart76440752peart
pease75231112pease
peases85229472peases
peat65967932pea_t
peaty105725692peaty
peavy135014842peavy
pecans101515832pecans
pechs125516202pechs
pecks135724432pecks
pecs84634102pe_cs
pedals94316032pedals
pedes85327292pedes
peds75835242pe_ds
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peers75130272peers
pees65257372pe_es
peg65843062pe_g_
pehs95625762pe_hs
peins76128062peins
pekans121710552pekans
pekes114623562pekes
pelage9515362pelage
pelages10714612pelages
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
penangs10268372penangs
pends85527192pends
penes75839222penes
pengo84317592pengo
pengos94612412pengos
penis75129322penis
pens65649642pe_ns
peons75327182peons
pepos96620082pepos
peps85134512pe_ps
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
pes57259782pe__s
pesos77221622pesos
pests75933272pests
petals84719812petals
pets66248332pe_ts
pews95731532pe_ws
phage115113672phage
phages125213512phages
pians75126962pians
pias66542552pia_s
pigs76634222p_igs
pings85830882pings
plage84520402plage
plages94520152plages
plans75731272plans
plats75531372plats
plays106320772plays
pleads94613952pleads
pleas75627032plea_s
pleats85218592pleats
plugs85213492plugs
pongs85526342pongs
prams96125512prams
prangs94816232prangs
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
prigs85219702prigs
progs86624152progs
pugs76332772p_ugs
pungs85422222pungs
pyas96225702pya_s
quags154613252quags
rags55448372_rags
reads64835272reads
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
regs55436572re_gs
retags73414302retags
sags55948402_sags
scags85520972scags
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
segs54933882se_gs
shags95123862shags
skags104316072skags
slags66525902slags
snags64421312snags
speaks125114582speaks
speans85417142speans
spears84019472spears
sprags95715822sprags
stags66226742stags
swags94921252swags
tags55545232_tags
teaks94222902teaks
teals56234132teals
teams75726512teams
tears55436462tears
teas45851492tea_s
teats55636812teats
teggs74710742teggs
tegs56031492te_gs
veals84926192veals
wags86140552_wags
weals85428742weals
weans85326742weans
wears86030302wears
yags86632292_yags
yeahs115214552yeahs
yeans86624882yeans
years84527672years
yeas78638422yea_s
yeggs10608162yeggs
zags146826682_zags
zeals145320852zeals

Search took 4 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.296603685.8
2DLD Change Limit538002292.69020000.0
3Display Results2292290.0603816.7
 (SQL Overall)1786912293.04658664.1
 
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.