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

266 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
piggery1426619(None) 
priggery1543991priggery
wiggery15295871wiggery
bigger104315062bigger_
biggety1434432biggety
buggery14367932buggery
digger94616082digger_
diggers104413392diggers
doggery13448262doggery
gingery12368912gingery
jaggery19336902jaggery
jigger155313052jigger_
jiggers164010182jiggers
nigger89713572nigger_
niggers93111322niggers
pigged114214152pigge_d
piggier113510002piggier_
piggy124011432pigg__y
pinery115214292pi_nery
pinger94324092pinger_
pingers104020742pingers
puggry13374822pugg_ry
rigger85616712rigger_
riggers93613842riggers
toggery12505922toggery
waggery15276902waggery
agger76420893_agger_
aggers85817793_aggers
bagger104619203bagger_
baggers113915693baggers
beggary14316153beggary
bibbery13426543bibbery
biggest1138143biggest
biggity1435013biggity
biggy124413133bigg__y
bigotry1344523bigotry
bindery13459833bindery
binger94923453binger_
bingers104519993bingers
biogeny1336023biogeny
bugger104418723bugger_
buggers114315663buggers
chigger1436003chigger_
chiggers1535563chiggers
cindery13429193cindery
dagger95017303dagger_
daggers103714913daggers
digged104314653digge_d
dinger85323673dinger_
dingers94321383dingers
dingey114914053dinge_y
dithery14318943dithery
dodgery13627783dodgery
dogger95216783dogger_
doggers104413433doggers
egger74414413_egger_
eggers84612583_eggers
fidgety15384893fidgety
fiery114714793fi__ery
figged124013893figge_d
finery124512893fi_nery
finger104920333finger_
fingers113418433fingers
fishery16397733fishery
fogger114414783fogger_
foggers124112013foggers
forgery14419303forgery
gagger95016513gagger_
gaggers103413663gaggers
gigged104112293gigge_d
giggler101029883giggler_
gigglers11297403gigglers
giggly12518703gigg_ly
gingely12378213gingely
ginger84920033ginger_
gingerly13315303gingerly
gingers94118643gingers
groggery1433513groggery
higgler12369803higgler_
higglers13297233higglers
higher134610893higher_
hinger104723333hinger_
hingers113420213hingers
hogger114615083hogger_
hoggers124512483hoggers
hugger114713123hugger_
huggers124211593huggers
igged86012763_igge_d
imagery13124203imagery
jaggary19304863jaggary
jagger154016003jagger_
jaggers164012893jaggers
jagghery2351803jagghery
jigged164412773jigge_d
jiggered1834203jiggered
jiggier16377823jiggier_
jiggly18378713jigg_ly
jiggy17549143jigg__y
jittery17346443jittery
jogger154713163jogger_
joggers164110693joggers
jugglery20303813jugglery
kegger12388083kegger_
keggers13357043keggers
lagger85919833lagger_
laggers94216243laggers
liger65024473li_ger_
ligers75022043li_gers
linger75226003linger_
lingers84223303lingers
littery103710493littery
livery124910903li_very
logger86420003logger_
loggers94616133loggers
lugger83916553lugger_
luggers93713483luggers
misery114113543mi_sery
mugger103914703mugger_
muggers113611933muggers
nagger84016123nagger_
naggers93812653naggers
niggard1044943niggard
niggler93610293niggler_
nigglers10307253nigglers
niggly11418913nigg_ly
nigher103612753nigher_
nitery94412173ni_tery
nuggety1234313nuggety
pager84728203p_ager_
pagers94423253p_agers
papery134812743p_apery
pedlery13297083pedlery
peery105719443p__eery
pegged114811913pegge_d
peppery13286253peppery
picker144422173picker_
pickers153718093pickers
piecer105213083piecer_
piecers114112253piecers
pier66035293pi__er_
piers75926333pi__ers
piety105817303pi__ety
pigeon949413pi_geon
piggeries13107893piggeries
piggie103210773pigg_ie
piggies113813483piggies
piggiest12259663piggiest
piggin103111093pigg_in
pigging123614673pigging
piggins113010473piggins
piggish14227703piggish
piglet93420923pigle_t
piglets103311793piglets
pigment12510733pigment
pigmy13299433pi_g_my
pignora10306363pignora
pigpen1136583pigpe_n
pigpens1235503pigpens
pigsney1342873pigsney
pigsty1235933pi_gsty
pigweed1465093pigweed
piker115622843pi_ker_
pikers124717393pi_kers
pilfer1139163pilfer_
pilfers1238963pilfers
pillory12247453pillory
pincer104019173pincer_
pincers113916503pincers
pinder94523453pinder_
pinders103720473pinders
piney105727503pi_ne_y
pinged104321383pinge_d
pinier84024693pinier_
pinker125322443pinker_
pinkers134118603pinkers
pinkey154314673pinke_y
pinner84521503pinner_
pinners93518603pinners
piper96523193pi_per_
pipers104318663pi_pers
pipier104913983pipier_
piscary1437423piscary
pisher114317753pisher_
pishers123815753pishers
pisser84416383pisser_
pissers95014753pissers
pitier84019823pitier_
pitiers93812653pitiers
plugger11378433plugger_
pluggers12297023pluggers
pogey116017893p_oge_y
popery134511703p_opery
pottery123011073pottery
powdery16396123powdery
preggers12236833preggers
prigged12398933prigge_d
printery13318433printery
progeny1389463progeny
progger11319373progger_
proggers12258163proggers
prudery1335243prudery
puckery18306263puckery
puffery18235113puffery
pugged114314533pugge_d
puggier11309383puggier_
puggree11176113puggree
puggy124612323pugg__y
purger94717233purger_
purgers104714003purgers
raggedy13334663raggedy
riflery13345803riflery
rigged94517403rigge_d
ringer74526063ringer_
ringers83922953ringers
roguery1134893roguery
rugger84414513rugger_
ruggers94612313ruggers
sagger84321073sagger_
saggers94017083saggers
sigher103813703sigher_
sighers113712183sighers
signer74015633signer_
signers84714443signers
signory11427523signory
silvery13328093silvery
singer74227313singer_
singers83824703singers
snigger9328373snigger_
sniggers10317093sniggers
snuggery13253973snuggery
spicery14499013spi_cery
spidery13308203spi_dery
spinnery13416593spinnery
sprigger12366503sprigger_
spriggers13325493spriggers
staggery13346243staggery
surgery11319213surgery
swigger12338453swigger_
swiggers13337123swiggers
tagger84017703tagger_
taggers93514193taggers
thuggery1642563thuggery
tiger65718633ti_ger_
tigers75616513ti_gers
timbery14256893timbery
tindery11389363tindery
trigger9329163trigger_
triggers10257843triggers
tugger84013103tugger_
tuggers93711443tuggers
vinery124912603vi_nery
wagger113616013wagger_
waggers124613083waggers
wigged124413583wigge_d
wiggier12418863wiggier_
wiggler123110763wiggler_
wigglers13257213wigglers
wiggly14559683wigg_ly
wiggy134510733wigg__y
winery125014283wi_nery
winger104125443winger_
wingers113921483wingers
wintery13399753wintery
zigged184110193zigge_d
zinger163816703zinger_
zingers173514853zingers

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272666.59320328.7
3Display Results2662660.0932860.2
 (SQL Overall)1786912667.09225196.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.