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 “people” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

451 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
people1031019(None) 
peopled1238511peopled
peopler1138081peopler
peoples11312221peoples
depeople1344342depeople
epopee10312502epopee
pebble1238002pebble
peddle103512822peddle
pele65539552pe__le
penile82219602penile
peoplers1237162peoplers
pepla9312862pe_pla
perplex1836152perplex
pestle83215842pestle
pettle84116052pettle
pimple123512962pimple
pole65951302p_o_le
poodle93112042poodle
pope85535612p_op_e
popple92710982popple
prole74527792pro_le
propel103714062propel
purple102712682purple
repeople1245062repeople
semple103212752semple
temple102811332temple
unpeople1244472unpeople
aedile73716653aedile
amole75724593amo_le
ample94720303_ample
anole55330383ano_le
apple94517673_apple
areole61017283areo_le
azole145118033azo_le
beadle93314683beadle
beagle93612593beagle
beetle8311673beetle
belle75827833be_lle
bogle85821683_bogle
bole66448693_bo_le
boodle93215033boodle
boule74828043_boule
ceorl7410923ceorl_
ceorls848163ceorls
cepe84926653ce_p_e
coble94823173_coble
cole66956113_co_le
cope86847383_cop_e
copse95623933_copse
couple104415963couple
creole8913733creo_le
dapple1138853dapple
decile94619213decile
deckle1312012453deckle
decouple13114873decouple
decuple1285363decuple
deeply1257013deeply
defile105216663defile
dele56843083de__le
depeopled1543233depeopled
depeoples1444223depeoples
depone93616553depone
depose94215763depose
dhole95215363dho_le
dimple113512793dimple
dipole91112853dipole
dispeople14134923dispeople
dole56550003_do_le
doodle83212853doodle
dope76038893_dop_e
droplet10312113droplet
duple85315863_duple
eagle64219483_eagle
edile64819493_edile
elope75219343elop_e
empale102611263_empale
epee64628503_e_pee
epode85114093epo_de
epopees1137233epopees
etoile6312263etoile
exile126117653_exile
expel1448233_expel
feeble1138253feeble
female11310553female
ferule93413203ferule
fettle93713123fettle
fipple13329063fipple
footle93914383footle
foozle18369203foozle
gentle74014513gentle
geode7412593geo_de
grope84821613grop_e
haole84820083hao_le
heckle153112093heckle
heddle114211163heddle
hempie132410563hempie
hirple11158973hirple
hole77553393_ho_le
hoopla1147633hoopla
hoopoe11911233hoopoe
hope96639673_hop_e
hopple132910483hopple
hoyle11314413_hoyle
jole117233823_jo_le
joule124918203_joule
keckle11359423keckle
kelpie12308613kelpie
kettle104311613kettle
kewpie15465413kewpie
kopje1835273_kopje
laypeople1651523laypeople
leone55018823leo_ne
lope65941923_lop_e
maple95521143_maple
measle83513223measle
meddle103312763meddle
meikle1236653meikle
merle75824373me_rle
metopae1147743metopae
metope10611123metop_e
mettle83815723mettle
mole66251833_mo_le
mope86838043_mop_e
myope124010973myop_e
nebule848753nebule
needle73310613needle
nestle63013953nestle
nettle64514583nettle
nipple103410373nipple
noble74420993_noble
noodle73212543noodle
nope65934193_nop_e
obole75917143obo_le
ogle56325053__ogle
ole37155213__o_le
ope56845243__op_e
orle45630463__orle
outpeople1343153outpeople
paddle104615143paddle
padle84522343p_adle
pale66055013p__ale
panoply1434713panoply
papule102212133papule
parle75836163p_arle
parole84425253parole
peace95026083pe_ace
peage84723573pe_age
peal68648103pe_al_
pealed95322813pe_aled
peals75235493pe_als
pearl75324463pearl_
pearled10411553pearled
pearler9310373pearler
pearls84715393pearls
pearly116414843pearly
pease75231113pe_ase
pebbled1445403pebbled
pebbles1337573pebbles
pebbly1545083pebbly
pedal86022503pedal_
pedaled113711893pedaled
pedaler103410693pedaler
pedalo93811153pedalo
pedals94316033pedals
pedate93117763pedate
peddled123410543peddled
peddler113210493peddler
peddles112913703peddles
pedicle1238973pedicle
pedler93614623pe_dler
pedophile17115753pedophile
pee56066513pe___e
peel65535613pe_el_
peeled94119713pe_eled
peeler83517383pe_eler
peels75226423pe_els
peep85833693peep__
peeped113915393peeped
peeper103614803peeper
peephole1545993peephole
peeps95822363peep_s
peepul1035783peepul
peepuls1134923peepuls
peerie83617893peerie
peeve104915253pe_eve
peewee11311973peewee
peise75825773pe_ise
peke105926203pe__ke
pekoe114612363pe_koe
pelage9515363pelage
peles75738083pe__les
pelf97031453pe__lf
pelite84323003pelite
pellet83326553pe_llet
pelt67651083pe__lt
penal75228373penal_
pence94924453pe_nce
pencel103812923pencel
pennae84314033pennae
penne75423853pe_nne
penoche1447043penoche
pensee8417313pensee
pensile92713543pensile
penult8314653penult
peon65635243peo__n
peonage1048723peonage
peones83821043peones
peonies93620153peonies
peons75327183peo_ns
peony105717563peo_ny
peopling1338353peopling
pep76447083pe_p__
peplos101211543pe_plos
peplum12156823pe_plum
peplus10138343pe_plus
pepo87622153pe_p_o
pepos96620083pe_pos
pepped103113403pepped
pepper93512943pepper
peppier10268323peppier
peppily1335133peppily
peppy114310363pe_ppy
peps85134513pe_p_s
percale11314093percale
perdie94718513perdie
perdue93912633perdue
pere66450263pe__re
peril75425953peril_
periled10316323periled
perils84121853perils
perp89029893perp__
perps95521483perp_s
perse75429523pe_rse
pertly115312553pertly
peruke123210393peruke
peruse84016843peruse
pesade9311103pesade
pestled102711453pestled
pestles93217693pestles
petal76526893petal_
petaled103614153petaled
petals84719813petals
petiole9311303petiole
petite84320653petite
petrale9312623petrale
petrel83111533petrel
pettled103611513pettled
pettles93916483pettles
pewee10319973pe_wee
peyote1139853peyote
peyotl1146233peyotl_
peyotls1233633peyotls
phoebe1335003phoebe
phone105621933pho_ne
phyle134111153p_hyle
pickle144215653pickle
piddle103514913piddle
piehole12188553piehole
piffle14418233piffle
pile65649703p__ile
pilule8411123pilule
pimpled14289193pimpled
pimples133012423pimples
pimply15329213pimply
pinocle1138143pinocle
pinole83218783pinole
pintle83818263pintle
piolet83225643pio_let
pipe86434443p_ip_e
pizzle16279493pizzle
pleopod1244823pleopod
plop86625743plop__
plopped11288773plopped
plops95920333plop_s
poilu72316003p_oilu
poise75127893p_oise
poke105335363p_o_ke
pol56449383p_o_l_
poled84934843p_o_led
poler74431793p_o_ler
poles75351003p_o_les
poll66332133p_o_ll
polled94022003p_olled
pollee83623273p_ollee
pollen83416453p_ollen
poller83921853p_oller
pollex153711163p_ollex
polls74627723p_olls
polo66236633p_o_lo
pols66044563p_o_ls
poly96235153p_o_ly
pome85636693p_o_me
ponce95222513p_once
pone65747533p_o_ne
poodles103013513poodles
pool65835953p_ool_
pooled94619813p_ooled
pooler83819843p_ooler
pools74427703p_ools
poop86532813poop__
pooped113915943pooped
poops94422413poop_s
poorly1137893poorly
poove104514303p_oove
pop76252253p_op__
popes95933813p_opes
poplar103611113p_oplar
poplin10413483p_oplin
poppa8409893p_oppa
popped104117813p_opped
popper93615963p_opper
poppet92717323p_oppet
poppled11339243poppled
popples103011873popples
poppy114813193p_oppy
pops86340953p_op_s
popsie103013063p_opsie
popsy125713403p_opsy
pore66451263p_o_re
pose66441733p_o_se
posole8314223posole
posse74722273p_osse
potpie103412433potpie
pottle84416103pottle
poult76928873p_oult
pozole1758913pozole
prefile123413183prefile
preop94715873preop__
preops104911943preop_s
preppie1058093preppie
presale9416353presale
probe94320813pro_be
problem1335983problem
profile123211153profile
proleg94612113pro_leg
proles84627203pro_les
prone75332623pro_ne
prop85932813prop__
propane112716153propane
propels113412843propels
propene112716043propene
proper104319953proper
prophet14316033prophet
propine113020213propine
propjet1839913propjet
propmen1338763propmen
propone112716303propone
propose112714843propose
propped113311963propped
props95726883prop_s
propyl13358183propyl
propyla14296633propyla
propyls14308193propyls
prose75835123pro_se
protyle12229453protyle
prove104823193pro_ve
prowl105615123prowl_
prowled13309913prowled
prowler123310013prowler
prowls115511083prowls
psoae74411623pso_ae
puddle103914153puddle
puerile9310093puerile
pule65040953p__ule
pungle94413573pungle
pupae96515643p_upae
purfle112511183purfle
purpled12299783purpled
purpler11289273purpler
purples112712833purples
purply13369053purply
puzzle16318603puzzle
pyrope132810533pyrop_e
recouple12107123recouple
reddle83815913reddle
refile95122373refile
regale74821453regale
reoil55321183reoil_
reoiled84316853reoiled
reoils64516873reoils
reopen8311573reopen
repel74921403re_pel
repeopled1444393repeopled
repeoples1345413repeoples
repled93319783re_pled
reply104015853re_ply
repoll8410793repoll
repose84121413repose
resale64025543resale
resile64627673resile
resole64624183resole
retile65929673retile
revile94921613revile
rimple103814583rimple
ripple103413913ripple
roble75223023_roble
role45851823_ro_le
rootle63214453rootle
rope65542913_rop_e
rumple103913013rumple
sample104215013sample
scope94821483scop_e
sedile73517233sedile
selle54428313se_lle
sempre102710093sempre
senile63420213senile
settle63915663settle
shoppe133110323shoppe
simple104315173simple
slope75823563slop_e
socle7419573_socle
sole46053673_so_le
speckle15297553speckle
staple84415823staple
steeple937323steeple
stole54928813sto_le
stope74727243stop_e
stopple1156583stopple
supple10410203supple
swiple11379233swiple
teazle15329553teazle
teepee8314363teepee
tele45040873te__le
templed12278563templed
temples112610893temples
templet112712003templet
teopan839353teopan
tepee74724213te_pee
thole85620843tho_le
tipple103411913tipple
toile54626493_toile
tole46052903_to_le
tootle62613813tootle
tope65946383_top_e
topee76029953_topee
tophe106718973_tophe
topple104411323topple
triple84215923triple
trope75725803trop_e
unpeopled1444533unpeopled
unpeoples1343503unpeoples
veepee11311483veepee
venule94411763venule
voile84719723_voile
vole75236983_vo_le
weepie11258793weepie
wheeple1534873wheeple
whole114418093who_le
wimple133611363wimple
yodle94515043_yodle
zeppole2043493zeppole

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127164516.06318590.8
3Display Results4514510.1562891.0
 (SQL Overall)1786914516.60927037.5
 
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.