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

486 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
pickets15431418(None) 
packets155114771packets
pickers153718091pickers
picket144924311picket_
pockets154612251pockets
prickets16329081prickets
rickets134915091rickets
tickets134113681tickets
wickets164010941wickets
beckets15399822beckets
bickers154316552bickers
buckets153811692buckets
crickets16418122crickets
dickens144410132dickens
dickers144117662dickers
dickeys17479302dickeys
dockets144412242dockets
hickeys19508222hickeys
ickers123914182_ickers
jackets205011372jackets
kickers124013292kickers
lickers134118252lickers
lockets134612202lockets
mickeys18447942mickeys
nickels13338652nickels
nickers134415092nickers
packers153818892packers
packet144726502packet_
peckers153312672peckers
picked154421312picke_d
pickeer153710112pickeer
pickeers16347242pickeers
picker144422172picke_r
picketed17167382picketed
picketer16187432picketer
picketers17196482picketers
pickiest162712592pickiest
pickles153215442pickles
picks135226142pick__s
pickups1754252pickups
picots104616442pic_ots
picquets2143732picquets
piglets103311792piglets
pikers124717392pi_kers
pikes115031032pi_ke_s
pinkens13419642pinkens
pinkers134118602pinkers
pinkest132812622pinkest
pinkeys16378212pinkeys
piolets93513192piolets
pipets105714772pi_pets
piquets1836602piquets
plackets1646582plackets
pocket144622622pocket_
prickers163710672prickers
pricket153616442pricket_
puckers153514672puckers
rackets134916872rackets
rickety16478312rickety
rickeys16548982rickeys
rockets134615362rockets
sickees134514212sickees
sickens134411482sickens
sickest131813792sickest
sockets134012982sockets
tackets134914362tackets
thickets17287082thickets
tickers133617722tickers
ticket124524852ticket_
tuckets134810332tuckets
wickers164114702wickers
wicket155318942wicket_
ackees124914573_ackees
aiglets84012913aiglets
aigrets82810533aigrets
apices104916263apic_e_s
backers153821883backers
backsets1638853backsets
baskets135111833baskets
becket144619883becket_
biceps12447713bic_eps
bices95029963bic_e_s
bicker144819173bicke_r
bidets95215533bi_dets
bikers124517553bi_kers
bikes117529473bi_ke_s
bilkers134711863bilkers
billets94516153billets
boskets13409473boskets
brackets163310433brackets
briskets14346563briskets
brockets16328123brockets
buckers153517453buckers
bucket144620733bucket_
cachets145014263cachets
caskets133910173caskets
chickees19258513chickees
chickens19267433chickens
circlets1235663circlets
civets115212543ci_vets
clickers163910203clickers
cockers153618333cockers
cricket154716953cricket_
crockets16339543crockets
dackers143417043dackers
deckels14367363deckels
deckers144413833deckers
dicasts1078703dicasts
dicers94720743dic_ers
dices86434243dic_e_s
diciest103316523diciest
dicked144920863dicke_d
dicker134521403dicke_r
dickey165913523dicke_y
dickies143416343dickies
dickiest153412503dickiest
dicks125824693dick__s
dicots94915793dic_ots
diets66026643di__ets
dikers114418793di_kers
dikes105831333di_ke_s
dinkeys15507263dinkeys
dipnets10109033dipnets
dockers143715003dockers
docket134721173docket_
duckers143214713duckers
epithets1345763epithets
facets116316653fac_ets
fices106031163fic_e_s
fiches145219533fiche_s
ficklest17267903ficklest
ficoes114613463ficoe_s
fidgets12388763fidgets
filets94718953fi_lets
fillets103414753fillets
fitchets16307413fitchets
flickers17338883flickers
friskets15326263friskets
fuckers163611593fuckers
gaskets12348153gaskets
gibbets12417723gibbets
giblets103210423giblets
giglets93211553giglets
gimlets10338433gimlets
hackees165014103hackees
hackers164619043hackers
hickey185011993hicke_y
hickies163614743hickies
hicks145322173hick__s
hikers135014353hi_kers
hikes125426983hi_ke_s
hockers163915913hockers
hockeys19509273hockeys
ices66129643_ic_e_s
iciest82914743_iciest
icker114018443_icke_r
ickiest133611043_ickiest
ikats95311153_i_kats
inkers104018833_inkers
inlets63915573_inlets
insets64016133_insets
islets64513083_islets
jackers204214453jackers
jacket194720673jacket_
jinkers183511813jinkers
jockeys23365953jockeys
junkets18377623junkets
kicked124415943kicke_d
kicker114116183kicke_r
kickiest13319673kickiest
kicks104420083kick__s
kickups1443503kickups
kikes85122553ki_ke_s
kismets13306883kismets
knickers13306723knickers
lackers134120543lackers
lackeys16458263lackeys
lichees123512783lichees
lichens123510683lichens
liches114724293liche_s
lichts113712383lic_hts
licked134621563licke_d
licker125222043licke_r
licks115325393lick__s
likens105613703li_kens
likers104620913li_kers
likes96231903li_ke_s
likest104914383li_kest
limpets11329783limpets
linkers114317713linkers
linnets739833linnets
lockers133516923lockers
locket123922473locket_
locksets1435693locksets
markets133314033markets
miches134320733miche_s
mickey174211853micke_y
mickles153415003mickles
micklest16219123micklest
micks135525373mick__s
midgets113910253midgets
mikes115129893mi_ke_s
milkers134411613milkers
millets94216843millets
minkes124618783minke_s
minuets9259853minuets
mirkest13309723mirkest
missets94516573missets
mockers153812943mockers
muckers153612803muckers
muskets13258643muskets
neckers134210463neckers
nicest82315663nic_est
nicety1138433nic_ety
niches114419143niche_s
nicked135019683nicke_d
nickel123811343nicke_l
nicker123818703nicke_r
nickles133713823nickles
nicks114920493nick__s
nidgets9358143nidgets
ockers123813903_ockers
octets839403_octets
pacers105124543pac_ers
paces96741113pac_e_s
paciest112917803paciest
packed154822603packe_d
packer144223403packe_r
packeted17148283packeted
packness1636933packness
packs135528933pack__s
pacts95125803pac__ts
palets85122313p_alets
pallets93919303pallets
pargets105215193pargets
parkers133816873parkers
pecked155019103pecke_d
pecker144615363pecke_r
peckiest162711393peckiest
pecks135724433peck__s
pectens11189203pectens
pekes114623563p_eke_s
pellets94014783pellets
pelmets11309693pelmets
pets66248333p___ets
picante11310523picante
picaras11311283picaras
picaros11310893picaros
picas94626523pic__as
piccata1345703piccata
pice84641093pic_e__
piceous11310693piceous
pick125933813pick___
pickax2135913pick_ax
pickaxe2244623pickaxe
pickaxes2344913pickaxes
pickerel1645273pickerel
pickerels1743723pickerels
picketing1835683picketing
pickier153912973pickier
pickiness1737623pickiness
picking163418333picking
pickings17359383pickings
pickle144215653pick_le
pickled164011883pickled
pickoff2143693pickoff
pickoffs2242373pickoffs
pickup1655633pick_up
picky165416943pick__y
picnics13297343picnics
picot95031013pic_ot_
picoted1239213picoted
picotee11311473picotee
picotees1247113picotees
picquet2047743picquet_
picrate112014143picrate
picrates122013213picrates
picrite111911313picrite
picrites121811083picrites
pics85633913pic___s
piculs103511753pic_uls
piecers114112253piecers
pieces104217273piece_s
piers75926333pi__ers
pies66949603pi__e_s
pieta75421753pi__eta
pietas84516503pi__etas
piety105817303pi__ety
piglet93420923piglet_
pigments1337343pigments
pignuts1035613pignuts
pigouts1037593pigouts
pigpens1235503pigpens
pikakes1245823pikake_s
pikas114218093pi_k_as
pike106335213pi_ke__
piked125623313pi_ke_d
piker115622843pi_ke_r
pikis115116393pi_k_is
piles74742613pi_le_s
pileus84514943pi_leus
pilfers1238963pilfers
pilots84018873pi_lots
pincers113916503pincers
pinchers153510613pinchers
pinches144117933pinche_s
pinders103720473pinders
pines76048863pi_ne_s
pineta85815563pi_neta
pingers104020743pingers
piniest93121133piniest
pinites9319533pinites
pinked134819883pinke_d
pinken124513283pinke_n
pinker125322443pinke_r
pinkey154314673pinke_y
pinkeye16326493pinkeye
pinkeyes17335973pinkeyes
pinkies133818263pinkies
pinkness1436513pinkness
pinkoes135512313pinkoes
pinkos125313873pink_os
pinks115729383pink__s
pinners93518603pinners
pinots85920273pi_nots
pints75936223pi__nts
piolet83225643piolet_
pipers104318663pi_pers
pipes96030143pi_pe_s
pipet95533323pi_pet_
pipiest113114493pipiest
pipits104713063pi_pits
pipkins15328183pipkins
piques1739093pique_s
piquet17412353piquet_
pirates93020333pirates
pishers123815753pishers
pishes114722103pishe_s
pissers95014753pissers
pisses84525083pisse_s
pistes85325633piste_s
pitchers153211483pitchers
pitches143617753pitche_s
pitiers93812653pitiers
pities83828083pitie_s
pits66348743pi___ts
pivots115111903pi_vots
pixels15478533pi_xels
pixes144323173pi_xe_s
pixies154915513pixie_s
placets113911223placets
placket15412873placket_
planets93914083planets
plinkers14309393plinkers
pluckers16316553pluckers
pocked154818983pocke_d
pocketed17147143pocketed
pocketer16157373pocketer
pocketers17196493pocketers
pockiest163412053pockiest
pocks135022963pock__s
poets76024443p__oets
pokers124617923p_okers
pokes116133013p_oke_s
pokeys15529513p_okeys
poppets10338853poppets
porkers134314933porkers
possets94212773possets
presets94216423presets
pricers113915063pric_ers
prices104524543pric_e_s
priciest122112903priciest
pricked164613833pricke_d
pricker154013413pricke_r
prickiest1748183prickiest
prickles162511093prickles
pricks144414263prick__s
prinkers143010383prinkers
privets122910053privets
projets1639163projets
pschents1544113pschents
puces94924633puc_e_s
pucker143817633pucke_r
puckery18306263puckery
pucks134322103puck__s
pukes114523023p_uke_s
pullets94015163pullets
punkers133714853punkers
punkest132611693punkest
punkeys16366493punkeys
punnets9409263punnets
puppets10317013puppets
quickens2334253quickens
quickest2345343quickest
quicksets2442383quicksets
rachets124516833rachets
rackers134320453rackers
racket125229423racket_
rackety16499113rackety
riblets93412553riblets
ricers84120993ric_ers
rices75536153ric_e_s
richens12349733richens
riches115022083riche_s
richest122813683richest
ricked136523623ricke_d
rickey154613973ricke_y
ricks115126133rick__s
rillets74216153rillets
riskers114011993riskers
rivets94417113ri_vets
rochets124213473rochets
rockers133916553rockers
rocket125425283rocket_
sachets123914103sachets
sackers133820223sackers
secrets9311773secrets
shickers173012823shickers
sices75637273sic_e_s
sickbeds17254213sickbeds
sicked134524403sicke_d
sickee124622223sicke_e
sicken124615253sicke_n
sicker124023903sicke_r
sickies133717503sickies
sickles133417543sickles
sickness1437833sickness
sickos125112033sick_os
sickouts1455503sickouts
sicks115127623sick__s
signets83311503signets
sikes96236083si_ke_s
sinkers113618543sinkers
sippets113310183sippets
slickens14317263slickens
slickers143112553slickers
slickest14229253slickest
snickers143010963snickers
socket123923523socket_
spicers113815553spic_ers
spices104326033spic_e_s
spiciest122711603spiciest
spicks144814993spick__s
spikers135311993spi_kers
spikes124520713spi_ke_s
spinets94714813spi_nets
sprockets1743253sprockets
stickers142913033stickers
suckers133717623suckers
sunkets113511283sunkets
tackers134319623tackers
tacket124627493tacket_
thickens17266413thickens
thickest17337303thickest
thicket163213073thicket_
thickety20274103thickety
thicksets18263733thicksets
ticked134720523ticke_d
ticker124321503ticke_r
ticketed15146643ticketed
ticklers14339303ticklers
tickles133416853tickles
ticks115823293tick__s
tikes95628903ti_ke_s
tinkers113517143tinkers
tippets11339373tippets
trickers143812813trickers
trinkets1237143trinkets
tuckers134014353tuckers
tucket124219483tucket_
vices105725533vic_e_s
violets102210003violets
wackes154717713wacke_s
wackest164710863wackest
whickers20297983whickers
wiches144418753wiche_s
wicked164317413wicke_d
wicker154518673wicke_r
wickless1736083wickless
wicks144619363wick__s
widgets12318453widgets
wiglets113411423wiglets
willets104414323willets
winkers143517113winkers
yikes125117753yi_ke_s
zibets1737743zi_bets

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.1561145455.1
2DLD Change Limit1340274867.11018850.5
3Display Results4864860.1862612.9
 (SQL Overall)1786914867.45223978.9
 
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.