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

184 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
prickling183653(None) 
pickling17239201p_ickling
pricking173212601prick_ing
trickling1647721trickling
bricking173911402brick_ing
crackling18157002crackling
cricking173412652crick_ing
crinkling16145862crinkling
freckling1934702freckling
nickling15278702_nickling
picking163418332p_ick_ing
pricing123417342pric__ing
prickings18315652prick_ings
pricklier17245062pricklier
prilling113413412pri_lling
princeling1544652princeling
prinking153212452prink_ing
ricking143920232_rick_ing
rockling15259382_rockling
ruckling15258572_ruckling
sickling152910332_sickling
sprinkling1743822sprinkling
stickling1647002stickling
strickling1744952strickling
tickling15309432_tickling
tricking152714512trick_ing
truckling1645072truckling
wricking18349492wrick_ing
wrinkling17144952wrinkling
arcking145811963ar_ck_ing
articling1247713artic_ling
bricklaying2351833bricklaying
bricklike1643113bricklike
bridling122610583bri_dling
brisking15329473brisk_ing
brisling112410843bri_sling
bristling1246663bristling
brittling1235543brittling
buckling17259113_buckling
cackling172610943_cackling
chuckling2144193chuckling
circling1338423circ_ling
clicking173610983click_ing
cockling172310393_cockling
cracking174013903crack_ing
cracklings19143523cracklings
crankling16147293crankling
cricketing1944033cricketing
crimpling1645343crimpling
crippling1644093crippling
crocking174313443crock_ing
dicking153617613_dick_ing
dribbling1533713dribbling
drilling103311983dri_lling
drinking14308913drink_ing
driveling1445763driveling
drizzling1943023drizzling
duckling16247703_duckling
flicking184110043flick_ing
fribbling1733673fribbling
frilling123011493fri_lling
frisking16268363frisk_ing
frivoling1644493frivoling
frizzling2153113frizzling
frocking18309573frock_ing
griddling1333933griddling
grilling103811533gri_lling
grizzling1942843grizzling
hackling183310163_hackling
heckling18257163_heckling
hoicking1836053hoick_ing
inkling122911303__inkling
keckling14245523_keckling
kicking133314023_kick_ing
knuckling1542753knuckling
licking144118283_lick_ing
mackling172710063_mackling
nickeling1645393_nickeling
nicking143516323_nick_ing
packing164420723p_ack_ing
paiking143814813pai_k_ing
panicking1835293panick_ing
parbuckling2251463parbuckling
parceling1438443parceling
pecking164017783p_eck_ing
penciling1437413penciling
periling11316863peri__ling
perilling12410003peri_lling
pickaxing2543103p_ickaxing
picketing1835683p_icketing
pickings17359383p_ick_ings
picolin11310883p_icolin_
picoline12310853p_icoline
picolins1239853p_icolins
picoting1338883p_icoting
piddling13208953p_iddling
piffling1745133p_iffling
piking133719643p_i_k_ing
piling95025593p_i__ling
pilling103722563p_i_lling
pindling122110983p_indling
pinking143918943p_ink_ing
plinking153611243plink_ing
plucking17357723pluck_ing
pocking163916763p_ock_ing
pranking153813383prank_ing
prattling1246303prattling
preceding15129363preceding
precising14413273precising
precoding15109733precoding
precooling1545963precooling
precuring1439423precuring
prefiling1549533prefiling
prickier16368143prick_ier
prickle153611013prickl__e
prickled17358073prickl_ed
prickles162511093prickl_es
prickliest1845293prickliest
prickliness1943903prickliness
prickly18367893prickl__y
priding113317543pri__ding
priesting1239483priesting
prigging13299093pri_gging
priming123417373pri__ming
primming15268173pri_mming
primping15338893pri_mping
princelings1642573princelings
printing113216083pri_nting
prising103321453pri__sing
prisoning1237643prisoning
prissing113011453pri_ssing
prizing193514683pri__zing
procuring1437993procuring
profiling1548233profiling
prowling1449993pr_owling
racking144323663_rack_ing
rankling132610113_rankling
recking144319923_reck_ing
ricing94822763_ric__ing
riddling11249443_riddling
ridgling11258203_ridgling
riesling939013_riesling
riffling1556113_riffling
rifling112815013_ri_fling
riling74227973_ri__ling
rilling84023623_ri_lling
rimpling13219663_rimpling
rippling13197573_rippling
risking123914243_risk_ing
rivaling1239913_rivaling
rocking143619633_rock_ing
rocklings16224843_rocklings
rucking143216673_ruck_ing
runkling13217613_runkling
shackling19286173shackling
sicking143720173_sick_ing
sicklying1943883_sicklying
slicking153712593slick_ing
snicking153610233snick_ing
spackling18266503spackling
speckling18235583speckling
sprinklings1841853sprinklings
sticking153513463stick_ing
suckling152410023_suckling
tackling153211123_tackling
ticking143218753_tick_ing
tinkling13239233_tinkling
trachling1537823trachling
tracking153715463track_ing
tricing103417353tric__ing
tricklier15256823tricklier
trifling122411503tri_fling
trilling92815963tri_lling
trindling1137133trindling
tripling112712553tri_pling
trocking153612423trock_ing
trucking153310163truck_ing
truckline1544913truckline
twinkling1743643twinkling
wicking173414773_wick_ing
winkling16298293_winkling
wracking18349963wrack_ing
wrecking18328153wreck_ing
wriggling1533813wriggling

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 Filter1786911486410.470380193.6
2DLD Change Limit1486411847.53019739.8
3Display Results1841840.0802300.0
 (SQL Overall)1786911848.08022115.2
 
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.