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

292 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
peals7523549(None) 
deals65435341deals
heals85733451heals
meals75933371meals
pals66951351p_als
peags86122841peags
peaks114825621peaks
peal68648101peal_
peans75437641peans
pearls84715391pearls
pears75138611pears
peas65755061pea_s
peats76140191peats
pedals94316031pedals
peels75226421peels
petals84719811petals
reals55038651reals
seals54839691seals
teals56234131teals
veals84926191veals
weals85428741weals
zeals145320851zeals
aals49941142_aals
als36663022__als
appals104812942appals
appeals11378672appeals
baals76122702baals
bals66354042_bals
beads85429502beads
beaks115326622beaks
beams95328172beams
beans75734692beans
bears75739042bears
beats76042242beats
beaus75127112beaus
bells76432162bells
bels66142492be_ls
ceils75019402ceils
cells75428062cells
cels65534972ce_ls
coals76129602coals
dals57145122_dals
deads75726912deads
deal56347412deal_
dealt65234282dealt
deans66131392deans
dears65736882dears
decals93717712decals
deils65722862deils
dells66630942dells
dels56745472de_ls
dhals95415442dhals
dials64925342dials
duals65620082duals
earls56127512_earls
ears46356592_ears
eats47054872_eats
eels46536742_eels
ells46431352_ells
els37645722_e_ls
feal713940422feal_
fears84829392fears
feats86432752feats
feels85223042feels
fells85327382fells
ferals94216642ferals
foals85721692foals
gals57946502_gals
gears64628692gears
gels56836102ge_ls
goals65521292goals
heads95127112heads
heal75645692heal_
heaps105223222heaps
hears86737372hears
heats85838402heats
heels85625532heels
heils85222192heils
hells85032042hells
herls85226432herls
ideals75012502ideals
jeans126022112jeans
jells125522162jells
keas86337092kea_s
keels94622412keels
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leal46043272leal_
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182lea_s
legals73412732legals
meads85425322meads
meal65643172meal_
mealy104422182mealy
means75831232means
meats75034052meats
medals94218052medals
mells75031332mells
mels65941532me_ls
merls77423902merls
metals84520882metals
mewls105813232mewls
neaps75618322neaps
nears55529422nears
neats55931902neats
opals75718352opals
orals55826482orals
ovals85413392ovals
pacs85842182p_acs
pads76742952p_ads
paeans85118262paeans
pails75833062pails
pal56761672p_al_
pale66055012p_ale
pales75753802p_ales
pall65039342p_all
palls74332562palls
palm85331362p_alm
palms94921752p_alms
palp85828572p_alp
palps94719562p_alps
palsy105417462p_alsy
paly95835532p_aly
pams85641762p_ams
pans65855732p_ans
paps86443452p_aps
pars67560792p_ars
pas58775742p_a_s
pass65239952p_ass
pats66460852p_ats
pawls105617662pawls
paws96038182p_aws
pays95940222p_ays
pea56657242pea__
peace95026082peace
peaces106324082peaces
peach125422492peach
peag75431342pea_g
peage84723572peage
peages94321852peages
peak106535202pea_k
peaky145718152peaky
pealed95322812pealed
pean66147172pea_n
pear69745232pea_r
pearl75324462pearl
pearly116414842pearly
peart76440752peart
pease75231112pease
peases85229472peases
peat65967932pea_t
peaty105725692peaty
peavy135014842peavy
pecans101515832pecans
pechs125516202pechs
pecks135724432pecks
pecs84634102pe_cs
pedal86022502pedal_
pedalo93811152pedalo
pedalos10329702pedalos
pedes85327292pedes
peds75835242pe_ds
peeks115021112peeks
peel65535612peel_
peens76428192peens
peeps95822362peeps
peers75130272peers
pees65257372pe_es
pegs75531762pe_gs
pehs95625762pe_hs
peins76128062peins
pekans121710552pekans
pekes114623562pekes
pele65539552pe_le
peles75738082peles
pelf97031452pe_lf
pelfs105016292pelfs
pelt67651082pe_lt
pelts76128812pelts
penal75228372penal_
pends85527192pends
penes75839222penes
penis75129322penis
pens65649642pe_ns
peons75327182peons
pepla9312862pepla
peplos101211542peplos
peplus10138342peplus
pepos96620082pepos
peps85134512pe_ps
peres76246642peres
perils84121852perils
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
pes57259782pe__s
pesos77221622pesos
pests75933272pests
petal76526892petal_
pets66248332pe_ts
pews95731532pe_ws
phials1158872phials
pial65636702pial_
pians75126962pians
pias66542552pia_s
pibals103813082pibals
pills74130972pills
pineals93212842pineals
pipals104213642pipals
plans75731272plans
plats75531372plats
plays106320772plays
pleads94613952pleads
pleas75627032plea_s
pleats85218592pleats
polls74627722polls
pols66044562p_ols
pools74427702pools
prams96125512prams
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
psalm949272psalm
psalms1045672psalms
pulls74425052pulls
puls65437562p_uls
purls74723352purls
pyas96225702pya_s
reads64835272reads
real45750292real_
reales64934122reales
realm75621622realm
realms84913492realms
reams75729622reams
reaps75626192reaps
rears54739652rears
reels55333262reels
repeals94014522repeals
rials55026672rials
sals46851672_sals
seal45654372seal_
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
seels55632822seels
sells55134432sells
sels46345982se_ls
sepals85217372sepals
sheals94420642sheals
sials54227242sials
speaks125114582speaks
speans85417142speans
spears84019472spears
speels85116392speels
speils84116222speils
spells84617682spells
steals64020062steals
taels56822072taels
teaks94222902teaks
teal45546502teal_
teams75726512teams
tears55436462tears
teas45851492tea_s
teats55636812teats
teels55726372teels
tells55828942tells
tels46841692te_ls
tepals85415042tepals
veal76936812veal_
vealy115817772vealy
veils84918802veils
vials85822382vials
weal75838682weal_
weald95615022weald
wealds10459102wealds
weans85326742weans
wears86030302wears
wells85426192wells
wheals124512522wheals
yeahs115214552yeahs
yeans86624882yeans
years84527672years
yeas78638422yea_s
yells85821942yells
zeal135530332zeal_

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.550324892.7
2DLD Change Limit538002922.61020613.0
3Display Results2922920.0763842.1
 (SQL Overall)1786912923.23655219.7
 
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.