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

441 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
potpie10341243(None) 
potpies113116171potpies
potsie83916031potsie
cowpie133511512cowpie
hottie92514382hottie
koppie14277882koppie
pattie84020962pattie
pommie123710502pommie
pope85535612po_p_e
poppied11388982poppied
poppies102816192poppies
popple92710982popple
popsie103013052popsie
porkpie1544672porkpie
postie84123962postie
potage92715902potage
potlike13910122potlike
potline91015232potline
potsies93019482potsies
pottier93516492pottier
potties93723542potties
pottle84416102pottle
puttie84116302puttie
atopic103514143atopic
atopies92816433atopies
boccie123311453boccie
bogie89524103bo_gie
bonnie85314853bonnie
boobie104015293boobie
boogie93515993boogie
bookie123516003bookie
bootie85421163bootie
bothies12414783bothies
bottle84916073bottle
bougie93613273bougie
buppie12288733buppie
cattie85221023cattie
collie83621993collie
commie124215523commie
compile13312443compile
cookie123716043cookie
coolie83821603coolie
cootie84223093cootie
cope86847383co_p_e
copied114618563co_pied
copier103722893co_pier
copies104130303co_pies
coppice1537483coppice
copse95623923co_pse
corbie103618203corbie
corpse104013403corpse
corrie83621223corrie
cosie74728263co_sie
cote66648733cot__e
coterie9417403coterie
cottae84615703cottae
cottier93814173cottier
cotype1346823cotype
coupe96023483coup_e
couple104415963couple
couthie121810553couthie
cowpies143314283cowpies
cowrie113814283cowrie
cozie163519133co_zie
croppie13278793croppie
cutie76925933cut_ie
dobie84920333do_bie
doggie93910893doggie
dogie75222793do_gie
donsie7613643donsie
doobie94712683doobie
doolie73916833doolie
doozie163910653doozie
dope76038893do_p_e
dopier93515923do_pier
dormie9312623dormie
dotage82711613dotage
dote55442883dot__e
dotier73917033dot_ier
dottier83910923dottier
dottle74212503dottle
dowie94721143do_wie
doxie136017153do_xie
epopee10312503epo_pee
fogie96719003fo_gie
folkie13369613folkie
foodie104413843foodie
footie94718143footie
footsie1047653footsie
goalie7413163goalie
goodie83613993goodie
goonie73615563goonie
goopier103910573goopier
gopik1257533go_pik
gothic1237793gothic
gothite1146403gothite
groupie1045783groupie
hatpin112610613hatpin
hempie132410563hempie
hippie132811243hippie
hoagie102310013hoagie
hogtie102711773hogtie
homie104622533ho_mie
honkie133011673honkie
hoodie105116143hoodie
hoolie93217783hoolie
hoopoe11911233hoopoe
hope96639673ho_p_e
hoppier143110703hoppier
hopple132910483hopple
hospice14117063hospice
hotline10712353hotline
hotties103016963hotties
howdie13349733howdie
kelpie12308613kelpie
kewpie15465413kewpie
kookie9389843kookie
kopje1835273ko_pje
koppies153210013koppies
loggie84011993loggie
looie55624243lo_oie
loonie64216453loonie
loopier93711193loopier
lope65941923lo_p_e
loppier11369723loppier
loti46431843lot_i_
lotic76420673lot_ic
lotte54923853lot_te
louie55023513lo_uie
loupe75319513loup_e
magpie1139093magpie
moggie103210103moggie
mollie83517103mollie
monie75631653mo_nie
mope86838043mo_p_e
mopier103914783mo_pier
mote67048083mot__e
mothier121910213mothier
motif10519683mot_if
motile83818343motile
motive113112143motive
motlier92010583motlier
motte75526973mot_te
mottle84116053mottle
movie105319133mo_vie
moxie144018123mo_xie
nappie104112263nappie
noogie73612313noogie
nookie103712433nookie
nope65934193no_p_e
notate63217863notate
note46239963not__e
notice8313443notice
oldie6415473_oldie
oorie53026363_oorie
ootid61416703oot_id
ope56845243_o_p_e
opine77422463_o_pine
optic93715183opt_ic
optime1079353optime
orpin73415533_orpin
orpine83914483_orpine
otic66624823_ot_ic
ouphe104413263_ouphe
ourie54027303_ourie
outlie62419533outlie
outvie92412803outvie
palpi95414553palpi_
panpipe1034833panpipe
pantie84326473pantie
pappi84810893pappi_
pappier103511593pappier
pappies103214823pappies
pardie96021443pardie
pastie85525523pastie
pate65350463pat__e
patin76832853pat_in
patine85328123patine
patio74426353pat_io
patois84319363patois
patsies93919483patsies
pattee84323383pattee
patties93425143patties
peerie83617893peerie
people10310193people
peppier10268323peppier
peptic122113153peptic
peptid112712373peptid
peptide122910683peptide
peptize20279483peptize
perdie94718513perdie
petit74332653pet_it
petite84320653petite
petti75119453petti_
pettier94213613pettier
pettle84116053pettle
photic133316443phot_ic
photopia1549733photopia
photopic17411093photopic
pie55457403___pie
piggie103210773piggie
pimple123512963pimple
pinkie124414273pinkie
pipe86434433p_ip_e
pipier104913983p_ipier
pipit95224873p_ipit
pippin92810303pippin
pithier123010293pithier
pitied94017253pit_ied
pitier84019823pit_ier
pities83828083pit_ies
pixie145415523p_ixie
plie65127393p__lie
plotline1037643plotline
plottier10327263plottier
plotties103111413plotties
pockier153911603pockier
podgier11338723podgier
podia8415283po_dia
podite93315353podite
podlike14108553podlike
poesies93217403poesies
poetic10416843poetic
poetise9314043poetise
poetize18310773poetize
poetlike1436733poetlike
poetries10315583poetries
pogies94123543po_gies
poi57244663po__i_
pointe84619313pointe
pois66539043po__is
poise75127893po_ise
poke105335363po__ke
pokier124914633po_kier
pokies125921333po_kies
pole65951303po__le
poleis86018353poleis
police102918563police
polies84034583po_lies
polio75722553po_lio
polis74731163po_lis
polite83625073polite
pollee83623273pollee
polypi13458593polypi_
polypide1647013polypide
pomace123111913pomace
pomade113611333pomade
pome85636693po__me
pommee122813283pommee
pommies133712843pommies
pomp106225463pomp__
pompom1436493pompom
pompon1238943pompon
pomps115316193pomp_s
ponce95222513po_nce
pone65747533po__ne
pongee94920193pongee
pongid104111583pongid
ponied94920703po_nied
ponies84833463po_nies
pontil8315463pontil
pontine92419053pontine
poodle93112043poodle
poop86532813poop__
pooped113915943pooped
pooping123615443pooping
poops94422413poop_s
poori74816233poori_
pooris83916843pooris
poove104514303po_ove
pop76252253po_p__
popes95933813po_pes
popish133812113po_pish
poplin10413483poplin
poppa8409893po_ppa
poppas93710713poppas
popped104117813popped
popper93615963popper
poppet92717323poppet
popping113715413popping
poppled11339243poppled
popples103011873popples
poppy114813193po_ppy
pops86340953po_p_s
popsies112816463popsies
popsy125713403po_psy
porcine11312843porcine
pore66451263po__re
porgies103017003porgies
porkier133712343porkier
porkies133416493porkies
porkpies1636193porkpies
pornier93413133pornier
porose84818743porose
porpoise1248083porpoise
portage103013643portage
portlier1038373portlier
portside1138163portside
pose66441733po__se
posies84431433po_sies
posit75833333po_sit
posole8314223posole
posse74722273po_sse
postage103214853postage
postdive1445763postdive
postfire1346273postfire
postfix1944683postfix
posties93128813posties
postin83521033postin
postpaid1376543postpaid
postpone1248693postpone
postpose1247653postpose
posture9313253posture
pot58078433pot___
potable112115363potable
potages102416423potages
potamic13310853potamic
potash1138273potash
potato8513433potato
potboil1195463potboil
potboy1397813potboy
poteen83514263poteen
potence11711363potence
potent84223353potent
potful1138083potful
potheen12257893potheen
pother113818853pother
pothole12312173pothole
pothos114214693pothos
potiche1438043potiche
potion84519573potion
potlines10714213potlines
potman102813573potman
potmen102713093potmen
pots66452363pot__s
potsy105815613pot_sy
pottage103310603pottage
potted94624013potted
potteen9319673potteen
potter83926983potter
pottiest102815973pottiest
potting103720893potting
pottles93816983pottles
potto75320943pot_to
pottos84615873pottos
potty105621003pot_ty
potzer174411213potzer
pouffe14448263pouffe
pounce105214093pounce
poussie936623poussie
poutier93215323poutier
poutine93316823poutine
poxier153812113po_xier
pozole1758913pozole
premie103617993premie
preppie1058093preppie
propine113020213propine
prossie91812953prossie
prostie91617743prostie
protege1059153protege
protei82615313protei_
proteid103513673proteid
proteide11239723proteide
protein92414733protein
protyle12229453protyle
ptosis83611823ptosis
ptotic102713373ptotic
ptui64912483p_tui_
pulpier1148623pulpier
pulpit10310933pulpit
punkie123513613punkie
pupae96515643p_upae
pupil94712983p_upil
puppies103212613puppies
purple102712683purple
putrid9311173putrid
puttee85919723puttee
putti76018743putti_
puttied103811163puttied
puttier93314503puttier
putties94420023putties
pyxie17359363p_yxie
retie55735303ret_ie
roadie72813813roadie
roofie93411173roofie
rookie103613263rookie
roomie83013873roomie
rope65542913ro_p_e
ropier84118803ro_pier
rotate63320343rotate
rotche114311983rotche
rote46249023rot__e
roti46332933rot_i_
rotis56327063rot_is
rotte54625933rot_te
roupier9319493roupier
scottie937463scottie
soapier93411713soapier
softie93312483softie
sonsie6614863sonsie
sopite84917713so_pite
soppier112711583soppier
sortie63621993sortie
soupier93111753soupier
spotlit947303spotlit
spottier10207313spottier
stipe76523373_stipe
stogie7311323stogie
stope74727243stop_e
tattie64817513tattie
tawpie11339143tawpie
tie36557533__t_ie
tittie63213153tittie
toonie63617993toonie
tootsie737133tootsie
tope65946383to_p_e
topee76029953to_pee
tophe106718973to_phe
topi67830393to_pi_
topic95721503to_pic
topis76025833to_pis
topple104411323topple
torpid9310913torpid
tote46643673tot__e
toupee8316133toupee
towie85821873to_wie
townie93312303townie
untie54425493unt_ie
utopia8107883utopia
vogie95116663vo_gie
vote74728623vot__e
votive12348933votive
weepie11258793weepie
whoopie15295933whoopie
woodie103513613woodie
woolie93514483woolie
yippie13277843yippie
yowie114616453yo_wie
yuppie13297133yuppie
zombie1937323zombie
zowie174313843zo_wie

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.376475242.0
2DLD Change Limit1127164415.71619719.4
3Display Results4414410.1433083.9
 (SQL Overall)1786914416.23528659.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.