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

239 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
prickets1632908(None) 
crickets16418121crickets
pickets154314181p_ickets
prickers163710671prickers
pricket153616441pricket_
rickets134915091_rickets
brackets163310432brackets
briskets14346562briskets
brockets16328122brockets
cricket154716952cricket_
crockets16339542crockets
friskets15326262friskets
packets155114772p_ackets
pickers153718092p_ickers
picket144924312p_icket_
plackets1646582plackets
pockets154612252p_ockets
pricers113915062pric_ers
prices104524542pric_e_s
priciest122112902priciest
pricked164613832pricke_d
pricker154013412pricke_r
prickiest1748182prickiest
prickles162511092prickles
pricks144414262prick__s
prinkers143010382prinkers
privets122910052pri_vets
rackets134916872_rackets
rickety16478312_rickety
rickeys16548982_rickeys
rockets134615362_rockets
sprockets1743252sprockets
thickets17287082thickets
tickets134113682_tickets
trickers143812812trickers
trinkets1237142trinkets
wickets164010942_wickets
apricots1275393apric_ots
beckets15399823_beckets
bickers154316553_bickers
brachets154311983brachets
brackens16327923brackens
bracket154117233bracket_
brickbats1983023brickbats
bricked164312063bricke_d
brickiest1737433brickiest
brickles162810283brickles
bricks144614623brick__s
briquets1934853briquets
briskest14337803briskest
brisket134413403brisket_
brocket154013383brocket_
buckets153811693_buckets
chickees19258513chickees
chickens19267433chickens
circlets1235663circlets
clickers163910203clickers
crackers164111723crackers
cricked164814283cricke_d
cricketed1854683cricketed
cricketer1744563cricketer
cricketers1843883cricketers
crickey18418143cricke_y
cricks144316053crick__s
crochets15359833crochets
crocket154615673crocket_
dickens144410133_dickens
dickers144117663_dickers
dickeys17479303_dickeys
dockets144412243_dockets
driblets11266093driblets
drinkers13277823drinkers
flickers17338883flickers
friskers15337373friskers
frisket143811773frisket_
grivets11357973gri_vets
hickeys19508223_hickeys
ickers123914183__ickers
jackets205011373_jackets
kickers124013293_kickers
knickers13306723knickers
lickers134118253_lickers
lockets134612203_lockets
mickeys18447943_mickeys
nickels13338653_nickels
nickers134415093_nickers
packers153818893p_ackers
packet144726503p_acket_
parrokets1543923parrokets
peckers153312673p_eckers
pernickety2151693pernickety
picked154421313p_icke_d
pickeer153710113p_ickeer
pickeers16347243p_ickeers
picker144422173p_icke_r
picketed17167383p_icketed
picketer16187433p_icketer
picketers17196473p_icketers
pickiest162712593p_ickiest
pickles153215443p_ickles
picks135226143p_ick__s
pickups1754253p_ickups
picots104616443p_ic_ots
picquets2143733p_icquets
piglets103311793p_iglets
pikers124717393p_i_kers
pikes115031033p_i_ke_s
pinkens13419643p_inkens
pinkers134118603p_inkers
pinkest132812623p_inkest
pinkeys16378213p_inkeys
piolets93513193p_iolets
pipets105714773p_i_pets
piquets1836603p_iquets
placets113911223plac_ets
placket15412873placket_
plinkers14309393plinkers
pluckers16316553pluckers
pocket144622623p_ocket_
precasts1239453precasts
precents123015043precents
precepts14268883precepts
precess11310863prec_ess
precuts111710473prec_uts
presets94216423pr_esets
price93725413pric_e__
priced115018883pric_e_d
priceless1336883priceless
pricer103918293pric_e_r
pricey134412633pric_e_y
pricier113313113pricie_r
prick134317503prick___
prickier16368143prickier
pricking173212603pricking
prickings18315643prickings
prickle153611013prick_le
prickled17358073prickled
prickliest1845293prickliest
prickly18367893prick_ly
pricky174210343prick__y
prides94324183pri_de_s
priers84521193pri__ers
pries74339533pri__e_s
priest84125423pri__est
priests93810863pri_ests
primates121515933primates
primers114215673pri_mers
primes104225263pri_me_s
primmest14226693primmest
primness1276763primness
princelets1443463princelets
princes113015143prince_s
princess12266803princess
prinked143412163prinke_d
prinker133412743prinke_r
prinks124315383prink__s
printers103214903printers
prints84320103pri__nts
prioress1035393prioress
prises84133173pri_se_s
prisses94816713prisse_s
privates131812373privates
privet113821343pri_vet_
privies122414263privie_s
priviest132310313priviest
prizers183911843pri_zers
prizes173819813pri_ze_s
proceeds1335973proceeds
process11310403proc_ess
projets1639163pr_ojets
prophets1539503prophets
propjets1935493propjets
puckers153514673p_uckers
quickens2334253quickens
quickest2345343quickest
quicksets2442383quicksets
rachets124516833_rachets
rackers134320453_rackers
racket125229423_racket_
rackety16499113_rackety
riblets93412553_riblets
ricers84120993_ric_ers
rices75536153_ric_e_s
richens12349733_richens
riches115022083_riche_s
richest122813683_richest
ricked136523623_ricke_d
rickey154613973_ricke_y
ricks115126133_rick__s
rillets74216153_rillets
riskers114011993_riskers
rivets94417113_ri_vets
rochets124213473_rochets
rockers133916553_rockers
rocket125425283_rocket_
shickers173012823shickers
sickees134514213_sickees
sickens134411483_sickens
sickest131813793_sickest
slickens14317263slickens
slickers143112553slickers
slickest14229253slickest
snickers143010963snickers
sockets134012983_sockets
sprocket1646773sprocket_
stickers142913023stickers
tackets134914363_tackets
thickens17266413thickens
thickest17337303thickest
thicket163213073thicket_
thickety20274103thickety
thicksets18263733thicksets
tickers133617723_tickers
ticket124524853_ticket_
trackers143512843trackers
triceps11267343tric_eps
trices84826333tric_e_s
tricked144016163tricke_d
tricker134615523tricke_r
trickery17297343trickery
trickiest1549023trickiest
trickles143013763trickles
tricks125319013trick__s
tricots9311563tric_ots
trijets14308263tri_jets
trikes105419493tri_ke_s
trinket11314813trinket_
triolets83410143triolets
triplets103510263triplets
trippets12357423trippets
trivets103911583tri_vets
truckers14279003truckers
tuckets134810333_tuckets
whickers20297983whickers
wickers164114703_wickers
wicket155318943_wicket_
wreckers17315973wreckers
wricked174910193wricke_d
wricks154610623wrick__s

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622398.18617855.1
3Display Results2392390.0932569.9
 (SQL Overall)1786912398.43521184.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.