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

244 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
pedlery1329707(None) 
peddlery15224001peddlery
pedlary13277541pedlary
pedler93614611pedler_
pedlers103013271pedlers
celery1139622ce_lery
hellery13329212hellery
medley1298332medle_y
pedaler103410692pedaler_
pedalers11239392pedalers
peddler113210492peddler_
peddlers12298532peddlers
pedlar93311272pedlar_
pedlars103210212pedlars
peeler83517382peeler_
peelers93615592peelers
peery105719442pe__ery
peltry11288652pe_ltry
peppery13286242peppery
sealery104011052sealery
beanery1237563beanery
bedder104215783bedder_
bedders113513383bedders
bedless1039703bedless
beery105220123be__ery
belfry1435073be_lfry
butlery12369423butlery
cedary12419603ced_ary
ceder85322233ced_er_
ceders93817673ced_ers
ceiler84013963ceiler_
ceilers93912533ceilers
cutlery12448393cutlery
cyclery1763493cyclery
dealer74122143dealer_
dealers84118613dealers
deanery1137613deanery
doddery13516853doddery
dodgery13627783dodgery
eatery95316353_eatery
edger75215933_edger_
edgers84413913_edgers
eery76129623_e__ery
elder64020023_elder_
elderly1154943_elderly
elders74817303_elders
elegy939303_e_legy
emery104814333_e_mery
empery1348683_empery
every115215453_e_very
feeler93215173feeler_
feelers103814743feelers
feller94419553feller_
fellers104117543fellers
fernery1335813fernery
foolery1336693foolery
fullery13337973fullery
gallery11468743gallery
gelder84613713gelder_
gelders93812573gelders
healer94221803healer_
healers104319463healers
heder95623633hed_er_
heders104119763hed_ers
hedger114912633hedger_
hedgers124310253hedgers
heeler93917313heeler_
heelers103815623heelers
heller93322513heller_
helleri10389973helleri
hellers103619833hellers
henley1237483henle_y
hennery1335303hennery
idler65015663_idler_
idlers74012813_idlers
jewelry2041993jewelry
kegler11398233kegler_
keglers12277773keglers
ladler74314933ladler_
ladlers84613563ladlers
lechery15257643lechery
ledger85914363ledger_
ledgers94912173ledgers
leery85919133le__ery
meddler11319953meddler_
meddlers12318203meddlers
medlar93010463medlar_
medlars10259443medlars
medleys13115333medleys
melder93915813melder_
melders103213913melders
mercery14397623mercery
mewler113510233mewler_
mewlers12288983mewlers
needler8388893needler_
needlers9287423needlers
padder103415493padder_
padders113312873padders
paddler113711553paddler_
paddlers12329153paddlers
padle84522343padle__
padles95221123padle_s
palely11311923p_alely
paler75436933p_aler_
paltry114910403p_altry
papery134812743p_apery
parley116718353parle_y
pealed95322803peale_d
pearler9310373pearler_
pearlers1039033pearlers
peavey14398793peave_y
peccary1636283peccary
pecker144615363pecker_
peckers153312673peckers
pedaled113711873pedale_d
pedalfer1443273pedalfer_
pedalfers1542903pedalfers
pedalier1137603pedalier_
pedaliers1245183pedaliers
pedaller1136093pedaller_
pedallers1244763pedallers
pedantry1444053pedantry
pedately1445423pedately
peddle103512823peddle__
peddled123410533peddle_d
peddles112913703peddle_s
pedes85327283ped_e_s
pedleries1298783pedleries
pedology15216903pedology
pedro8313153ped__ro
peeled94119703peele_d
peeper103614803peeper_
peepers113713673peepers
peer66238353pe__er_
peers75130273pe__ers
pegless1038053pegless
pele65539553pe_le__
peles75738083pe_le_s
pellet83326553pelle_t
pellets94014783pellets
pelter83321623pelter_
pelters93720313pelters
penner84616663penner_
penners93414183penners
penury1148103pe_nury
peopler1138073peopler_
peoplers1237153peoplers
pepper93512943pepper_
peppers103311443peppers
perjury19244253perjury
perry105222713pe__rry
perter84422283perter_
pervert12315583pervert
pessary1246873pessary
pester84827593pester_
pesters93827093pesters
peter74427593pe_ter_
peters86624593pe_ters
petter83924773petter_
petters93722363petters
pewter114013673pewter_
pewters124113353pewters
piddler112911523piddler_
piddlers12359593piddlers
piggery14266193piggery
pillory12247443pillory
pinery115214293p_inery
pledger11359153pledger_
pledgers12387643pledgers
polder94019253polder_
polders103617373polders
poler74431793p_oler_
polers84225643p_olers
poller83921853poller_
pollers93420023pollers
pooler83819843pooler_
poolers94217423poolers
popery134511703p_opery
pottery123011073pottery
poultry1235383poultry
powdery16396123powdery
predry1237863pred__ry
prudery1335243prudery
psaltery13224733psaltery
psaltry12213803psaltry
puckery18306263puckery
puddler112910753puddler_
puddlers12298683puddlers
puffery18235113puffery
puler74826623p_uler_
pulers83820283p_ulers
puller83820813puller_
pullers93618483pullers
pulley113713403pulle_y
pusley11379613pusle_y
realer63528593realer_
redder83918133redder_
redders93615343redders
redefy13388763red_efy
redeny102712733red_eny
redleg839263redle_g
redlegs936823redlegs
redly94217193redl__y
redry94314363red__ry
reeler63822573reeler_
reelers73520273reelers
replevy1533463replevy
revelry1335693revelry
revery124014213re_very
ridley10169543ridle_y
riflery13345803riflery
rudery10419033rud_ery
saddlery13274913saddlery
sealer63928963sealer_
sealers74323553sealers
seder64826753sed_er_
seders74420283sed_ers
seller63824593seller_
sellers73721303sellers
sidler74716963sidler_
sidlers83414223sidlers
speller95415143speller_
spellers102812743spellers
spidery13308203spid_ery
tedder83312153tedder_
tedders94010233tedders
teller63519813teller_
tellers73717583tellers
vealer94016543vealer_
vealers103214293vealers
veery115816253ve__ery
veiler93814353veiler_
veilers103911823veilers
venery123710663ve_nery
volery1237873_volery
wedder113612293wedder_
wedders123610723wedders
welder102914413welder_
welders113313413welders
yeller94214513yeller_
yellers103912953yellers
yodler10389943yodler_
yodlers11298923yodlers
zedoary2043213zedoary

Search took 9 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.1561145455.1
2DLD Change Limit1340272447.75017293.8
3Display Results2442440.0803050.0
 (SQL Overall)1786912447.98622375.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.