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

251 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
prickled1735807(None) 
pickled164011881p_ickled
pricked164613831prick_ed
prickle153611011prickle_
prickles162511091prickles
trickled152610431trickled
bricked164312062brick_ed
brickle15279932brickle_
brickles162810282brickles
crackled17428862crackled
cricked164814282crick_ed
crinkled15357152crinkled
freckled18104442freckled
nickled144010442_nickled
picked154421312p_ick_ed
pickle144215652p_ickle_
pickles153215442p_ickles
priced115018882pric__ed
pricker154013412prick_er
pricket153616442prick_et
prickier16368142prickier
pricklier17245062pricklier
prickly18367892prickl_y
prilled104713002pri_lled
prinked143412162prink_ed
ricked136523622_rick_ed
ruckled144111032_ruckled
sickled144713432_sickled
sprinkled1633712sprinkled
stickled15298972stickled
strickled1665832strickled
tickled144313132_tickled
tricked144016162trick_ed
trickle133613442trickle_
trickles143013762trickles
truckled15327312truckled
wricked174910192wrick_ed
wrinkled16275352wrinkled
arcked136211943ar_ck_ed
ariled75620323ari__led
articled1137063artic_led
auricled11135703auric_led
brickier16307163brickier
bricole112810493bricole_
bricoles122610303bricoles
bridled113611143bri_dled
brindled12407853brindled
brisked144210003brisk_ed
bristled11187343bristled
brittled11186093brittled
buckled164411883_buckled
cackled164613303_cackled
chuckled2045163chuckled
circled1237583circ_led
clicked164112453click_ed
cockled163710823_cockled
cracked163514743crack_ed
crackle153611253crackle_
crackles164111273crackles
crankled15408153crankled
cribbled15305803cribbled
cricket154716953crick_et
cricketed1854683cricketed
crickey18418143crick_ey
crimpled15366933crimpled
crinkle13359413crinkle_
crinkles14269163crinkles
crippled15336793crippled
crocked164014433crock_ed
dicked144920863_dick_ed
dribbled14376593dribbled
drilled94711673dri_lled
driveled1374973driveled
drizzled18284573drizzled
fickle153912973_fickle_
fickler16348423_fickler
flicked174610673flick_ed
freckle16106643freckle_
freckles17126383freckles
fribbled16305743fribbled
frilled113911603fri_lled
frisked15478823frisk_ed
frivoled1534043frivoled
frizzled20325703frizzled
frocked17439333frock_ed
grackle14338893grackle_
grackles15309183grackles
griddled1244203griddled
grilled94012833gri_lled
grizzled18334893grizzled
hackled173312493_hackled
heckled17318463_heckled
hoicked1735963hoick_ed
icicled1234293icic_led
keckled13376503_keckled
kicked124415943_kick_ed
knuckled1463563knuckled
licked134621563_lick_ed
mackled164111923_mackled
mickle143715133_mickle_
mickler153310233_mickler
mickles153415003_mickles
nicked135019683_nick_ed
nickeled15115513_nickeled
nickle123814483_nickle_
nickles133713823_nickles
packed154822603p_ack_ed
paiked135113433pai_k_ed
panicked1785173panick_ed
panicled13106783panic_led
parbuckled2151583parbuckled
parceled1338343parceled
pecked155019103p_eck_ed
pedicled1436463pedic_led
penciled1337823penciled
periled10316323peri__led
perilled11410113peri_lled
pickaxed2443513p_ickaxed
pickeer153710113p_ickeer
picker144422173p_ick_er
picket144924313p_ick_et
picketed17167383p_icketed
pickier153912973p_ickier
picoted1239213p_icoted
piddled123311253p_iddled
piffled16366403p_iffled
piked125623313p_i_k_ed
piled85232993p_i__led
pilled94222753p_i_lled
pimpled14289193p_impled
pinked134819883p_ink_ed
plicated13310643plicated
plinked143910893plink_ed
plucked16367963pluck_ed
pocked154818983p_ock_ed
pranked143712093prank_ed
prattled11246533prattled
preceded1438293preceded
precised133213413precised
precited133013813precited
precoded1438863precoded
precooled1446363precooled
precured1339993precured
prefiled143310573prefiled
price93725413pric__e_
priceless1336883priceless
pricer103918293pric__er
prices104524543pric__es
pricey134412633pric__ey
pricier113313113pric_ier
pricily142710283pricil_y
prick134317503prick___
prickers163710673prickers
prickets16329083prickets
prickiest1748183prickiest
pricking173212603pricking
prickliest1845293prickliest
prickling1836533prickling
pricks144414263prick__s
pricky174210343prick__y
prided103618033pri__ded
pried84426863pri___ed
priested1138393priested
prigged12398933pri_gged
primed115118913pri__med
primmed14388853pri_mmed
primped14479153pri_mped
princelet1346533princelet
principled1742593principled
prinker133412743prink_er
printed104016373pri_nted
prised94322203pri__sed
prisoned1138813prisoned
prissed103311263pri_ssed
prized184415393pri__zed
proceed12310553proc_eed
procured1336603procured
profiled14338523profiled
prowled13309913pr_owled
racked134526083_rack_ed
rackle123917293_rackle_
rankled123910653_rankled
recked134821803_reck_ed
riced85825543_ric__ed
rickey154613973_rick_ey
riddled103012043_riddled
riffled14338603_riffled
rifled104115003_ri_fled
riled65833253_ri__led
rilled74525653_ri_lled
rimpled123311423_rimpled
rippled123110273_rippled
risked115514633_risk_ed
rivaled1138933_rivaled
rocked135022323_rock_ed
rucked134718763_ruck_ed
ruckle124414583_ruckle_
ruckles133414603_ruckles
runkled12399013_runkled
shackled18277603shackled
sickbed16396823_sickbed
sicked134524403_sick_ed
sickle124418323_sickle_
sickles133417543_sickles
sicklied1546583_sicklied
slicked144413843slick_ed
snicked143811633snick_ed
spackled17297803spackled
speckled17255833speckled
sprinkle1434893sprinkle_
sprinkler1543573sprinkler
sprinkles1534923sprinkles
sticked144114633stick_ed
stickle132410973stickle_
stickler14259573stickler
stickles142512103stickles
strickle1467793strickle_
strickles1567813strickles
suckled144212513_suckled
tackled143913193_tackled
ticked134720523_tick_ed
tickle124616743_tickle_
tickler133612653_tickler
tickles133416853_tickles
tinkled123910473_tinkled
trachled1438313trachled
tracked143716133track_ed
triced95518673tric__ed
tricker134615523trick_er
trickie132611033trickie_
trickier143010233trickier
tricklier15256823tricklier
trickly16369893trickl_y
triclad1037443tric_lad
trifled113711963tri_fled
trilled84116313tri_lled
trindled10388693trindled
tripled104113833tri_pled
trocked144312243trock_ed
trucked143910813truck_ed
truckle13358863truckle_
truckler14297453truckler
truckles14319383truckles
twinkled1663943twinkled
wicked164317413_wick_ed
winkled15299593_winkled
wracked174110113wrack_ed
wrecked17418333wreck_ed
wriggled14284663wriggled
wrinkle14296923wrinkle_
wrinkles15296693wrinkles

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622516.78321548.3
3Display Results2512510.0932698.9
 (SQL Overall)1786912517.29624491.6
 
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.