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

329 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
parrying1416813(None) 
carrying14148371carrying
harrying15157641harrying
marrying14157231marrying
parring103222061parr_ing
partying14168891partying
tarrying12146721tarrying
arraying1238752_arraying
barring104021592barr_ing
berrying14137382berrying
currying14196492currying
dairying1336352dairying
earring83519012earr_ing
ferrying15146252ferrying
garring93116712garr_ing
herrying15147032herrying
hurrying15145532hurrying
jarring153613192jarr_ing
marring103319552marr_ing
pairing103716732pair_ing
palsying1436232palsying
pandying15217662pandying
panfrying1842992panfrying
parading12313862parading
parawing14310582parawing
parching164313052parching
parging113318602pa_rging
paring94236492pa_r_ing
parking143423042pa_rking
parlaying1537302parlaying
parleying1536112parleying
parling103823762pa_rling
parodying1655422parodying
paroling113316212paroling
parroting1239152parroting
parsing103819552pa_rsing
parting103527382pa_rting
paying123722162pa__ying
praying133717322p_raying
preying133114552p_reying
prying124114802p__rying
purring104515822purr_ing
quarrying2273732quarrying
serrying12167702serrying
sparring113112222sparr_ing
tarring83318302tarr_ing
varying1429722va_rying
warring113717972warr_ing
worrying1534702worrying
abying124410413_a_bying
airing74927503_air_ing
airting83616303_airting
allying113011663_allying
applying1634653applying
aproning11311793aproning
arching136216693_arching
arcing95819643_a_rcing
arcking145811963_arcking
argling92812733_argling
arguing9248733_arguing
arising83619973_arising
arming94719803_a_rming
arraign845063_arraign
arriving1237363_arriving
arrowing1237943_arrowing
babying1537963ba_bying
bandying15218073bandying
barbing123716993ba_rbing
barding113822893ba_rding
barfing134615093ba_rfing
barging114018483ba_rging
baring95135853ba_r_ing
barking144724183ba_rking
barning104320353ba_rning
barraging1337383barraging
barreling1238043barreling
baying125222583ba__ying
birring103713063birr_ing
braying134416313_braying
burring104016993burr_ing
burying133413913_burying
caddying16225063caddying
candying15188993candying
carding113922443ca_rding
caring95137993ca_r_ing
carking144322853ca_rking
carling103727063ca_rling
caroling113317003caroling
caroming133312963caroming
carping123521083ca_rping
carroming1437683carroming
carryon1237033carryon_
carryons1337103carryons
carting104228283ca_rting
carving133916773ca_rving
charring142913163charr_ing
crying123612283__crying
curring103616843curr_ing
dairyings1442633dairyings
dallying13368493dallying
daring84928683da_r_ing
darking134217343da_rking
darkling1437483darkling
darling93418363da_rling
darning93817333da_rning
darting94020663da_rting
dartling1039563dartling
decrying15237413decrying
dirtying1336093dirtying
draying123813843_draying
drying113411603__drying
earing75235483ea_r_ing
earning83418213ea_rning
earrings9299633earr_ings
earthing12310333earthing
erring73816483_err_ing
fairing113614013fair_ing
fancying1735353fancying
farcing133514003fa_rcing
farding123716743fa_rding
faring105231283fa_r_ing
farming133515083fa_rming
farrowing1645873farrowing
farthing1538073farthing
farting114120753fa_rting
faying134521073fa__ying
flurrying16162803flurrying
foraying1537433foraying
fraying143413433_fraying
frying134511403__frying
furring114013143furr_ing
gallying13328933gallying
garaging1139043garaging
garbing113613273ga_rbing
garbling12249453garbling
gargling11239203gargling
garoting10510703garoting
garroting1136953garroting
glorying1335543glorying
gnarring10225973gnarr_ing
graying124115883_graying
greying124110893_greying
haring104233003ha_r_ing
harking154120943ha_rking
harming133717933ha_rming
harping134118383ha_rping
harrowing1646433harrowing
haying134420613ha__ying
herring113615883herr_ing
hurraying1654323hurraying
jurying18337763_jurying
karting123716063ka_rting
lairing83715343lair_ing
larding92917873la_rding
larking123718253la_rking
larruping1243243larruping
laying104525703la__ying
lazying2046673la_zying
marbling13179883marbling
marching164312193marching
marking144020133ma_rking
marling103322763ma_rling
marrowing1546663marrowing
marting103325013ma_rting
martyring1535783martyring
maying124421153ma__ying
narking124015383na_rking
narrating10310353narrating
narrowing1345603narrowing
oaring74225303oa_r_ing
pacifying2045503pacifying
pacing114522753pa__cing
packing164420723pa_cking
padding123412513pa_dding
paddling13218643paddling
paging104020403pa__ging
paiking143814813pa_iking
paining103920243pa_ining
painting113614423painting
pairings11398313pair_ings
paling93530133pa__ling
palling104024483pa_lling
palming123914013pa_lming
palping124112873pa_lping
paneling111013623paneling
panging113319113pa_nging
panning104019393pa_nning
panting104025423pa_nting
papering132213313papering
papyrine1546053papyrine
paralysing16235553paralysing
paralyzing25185203paralyzing
parang93715513pa_r_ang
parasang1147333parasang
parawings1535823parawings
parbaking1877203parbaking
parceling1438443parceling
pardine103616723pa_rdine
pardoning1338763pardoning
parenting12611583parenting
pargeting1338283pargeting
pargings123410163pa_rgings
pargyline1544653pargyline
parings104219213pa_r_ings
parkings153610683pa_rkings
parridge1254333parr_idge
parried103615723parr_ied
parrier93717653parr_ier
parries93925843parr_ies
parry105323753parry___
partaking1698673partaking
partings113513733pa_rtings
pashing135120513pa_shing
passing104318423pa_ssing
pasting103826553pa_sting
patching163212753patching
patining11312303patining
patting103722343pa_tting
pausing103912813pa_using
paving124519743pa__ving
pawing124519553pa__wing
pawning134711413pa_wning
pearling11912013pearling
peering103520353peer_ing
perching163711633perching
periling11316863periling
perking143716463p_erking
perming123416093p_erming
perusing11811063perusing
pharming16248143pharming
phonying1745833phonying
phrasing1438013phrasing
piercing1346663piercing
pirating11314513pirating
pitying132910243p_itying
playing133816093p_laying
ploying132811573p_loying
plying124312083p__lying
ponying133312123p_onying
poring94227273p_or_ing
porking143515813p_orking
porting103021783p_orting
portraying1645163portraying
pouring103115863pour_ing
praising113214563praising
prancing132612163prancing
pranging123012723pranging
pranking153813383pranking
prating103424453p_rating
prawning1446963prawning
predrying1645343predrying
preeing103817673p_reeing
pricing123417343p_ricing
priding113317543p_riding
priming123417373p_riming
prising103321453p_rising
prizing193514683p_rizing
probing123314443p_robing
prosing103319383p_rosing
proving134214073p_roving
pruning10311733p_runing
pureeing1137273pureeing
purfling1467763purfling
purging113314183p_urging
purifying1835853purifying
purling103620293p_urling
purpling1368543purpling
pursing103715553p_ursing
pursuing1146233pursuing
purveying1843573purveying
puttying1434953puttying
quarryings2371763quarryings
querying2135243querying
rallying12289013rallying
rarefying1654693rarefying
rarifying1646313rarifying
raring74332873ra_r_ing
raying105027193__raying
recarrying1643653recarrying
redrying13209023redrying
refrying15278903refrying
remarrying1643373remarrying
retrying122410453retrying
sabring102614843sabr_ing
sacring103115983sacr_ing
salarying1336073salarying
sallying12309853sallying
savvying1862723savvying
saying104325543sa__ying
scarring112511513scarr_ing
scrying1338663_scrying
scurrying15183833scurrying
slurrying13203193slurrying
sparging122611133spa_rging
sparing104823873spa_r_ing
sparking152812543spa_rking
sparkling16226353sparkling
sparling112714533spa_rling
spaying133014623spa__ying
spraying14299883spraying
spurring11339763spurr_ing
starring92312953starr_ing
storying12249673storying
straying122912693straying
stroying122410593stroying
tabbying1633973tabbying
tallying12318833tallying
taring73932283ta_r_ing
tarting84222653ta_rting
taxying1836183ta_xying
trying104214073__trying
updrying1534013updrying
waddying17204723waddying
wairing113414313wair_ing
warbling14198943warbling
warding123918143wa_rding
waring105029443wa_r_ing
warking153519573wa_rking
warming133515083wa_rming
warning113717093wa_rning
warping133715183wa_rping
warsling12198593warsling
wearying1546703wearying
wherrying1952993wherrying
whirrying1962733whirrying
wrying13379623__wrying
yarding123413143ya_rding
yarning113512953ya_rning
yirring11307763yirr_ing

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 Limit1461623296.84621350.0
3Display Results3293290.1402350.0
 (SQL Overall)1786913297.40624127.9
 
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.