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

339 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
parsley124780(None) 
paisley1235551paisley
parley116718361par_ley
parsleys1335081parsleys
barley115116762bar_ley
harslet10315652harslet
paisleys1333342paisleys
parlay113713992par_lay
parle75836162par_le_
parled94626292par_led
parles86334402par_les
parleys125212372par_leys
parole84425252parole_
paroled104217632paroled
parolee94119642parolee
paroles95025882paroles
parse75236992pars_e_
parsec105914482pars_ec
parsed96323892pars_ed
parser84822372pars_er
parses85534702pars_es
parsleyed1543352parsleyed
parslied1137822parslied
partlet92720362partlet
partly116315472partl_y
passkey1633562passkey
pusley11379612p_usley
pussley12375122pussley
sparsely1335122sparsely
warsle93112922warsle_
warsled112910442warsled
warsler10289892warsler
warsles103413642warsles
agley96917333_a_gley
aisle55223193_aisle_
aisled74516183_aisled
aisles64721143_aisles
alley85721673_a_lley
argle65421563_argle_
argled85314553_argled
argles75218483_argles
ariled75620323_ariled
arles56735743_ar_les
armlet84118193_armlet
arse46539273_ars_e_
arses55733873_ars_es
bailey115015673ba_iley
barely114716793barel_y
barfly14339653barfl_y
barleys125011843bar_leys
barney115314453bar_ney
basely114412313ba_sely
bassly114610073bassl_y
burley114715753bur_ley
carle74535703car_le_
carles85435083car_les
carney115315703car_ney
caroled103717693caroled
caroler93816753caroler
carse74934333cars_e_
carses85233653cars_es
causey113513273caus_ey
charley15118273char_ley
coarsely1335533coarsely
corslet9318063corslet
darkey145212423dar_key
darkle113813943darkle_
darkled13378723darkled
darkles124011933darkles
darkly145411073darkl_y
dartle73714833dartle_
dartled9409853dartled
dartles84014133dartles
early85324123ear_l_y
falsely1336013falsely
farle86929243far_le_
farles96025783far_les
fartlek1434493fartlek
galley104215453ga_lley
garble94118453garble_
garbled114512803garbled
garbler104012563garbler
garbles104016923garbles
gargle84215463gargle_
gargled104210673gargled
gargler93710263gargler
gargles94214893gargles
garvey13127873gar_vey
hardly135112833hardl_y
harshen1339283harshen
harsher13310363harsher
harshly1636273harshly
harslets1137833harslets
haslet93222713ha_slet
hassle93711593hassle_
hassled11358303hassled
hassles103411693hassles
hirsle9159573hirsle_
hirsled11118113hirsled
hirsles101510073hirsles
hoarsely1444363hoarsely
horsey125115403hors_ey
hurley125012523hur_ley
jarvey19135403jar_vey
jersey1636333jers_ey
kersey1336793kers_ey
langley1147453langley
largely1136703largely
marble104219103marble_
marbled123212113marbled
marbler113511673marbler
marbles114516653marbles
marbly134111933marbl_y
marled95523163mar_led
marly106925613mar_l_y
marse76231153mars_e_
marses84827113mars_es
marshes123615373marshes
marshy14558333mars_hy
martlet93419153martlet
oarsmen938093oarsmen
pacey126720283pa__cey
packly17228333packl_y
paddle104615143paddle_
paddled123612023paddled
paddler113711553paddler
paddles113515643paddles
padle84522343pa_dle_
padles95221123pa_dles
paise75028333pais_e_
pale66055013pa__le_
palea75028663pa__lea
paled85538723pa__led
palely11311933pa__lely
paler75436933pa__ler
pales75753803pa__les
palet74650803pa__let
palfrey1533343palfrey
palled94625163pa_lled
pallet84232653pa_llet
pally105727123pa__lly
palmy126016733pa__lmy
palsied102911303palsied
palsies94420273palsies
palsy105417463pa__lsy
paly95835533pa__l_y
paneled10612573paneled
pansies94521983pansies
pansy105717973pans__y
papally1437973papally
papule102212133papule_
papules112411573papules
parable111819773parable_
parables121613563parables
parade94720643parade_
paraded114014263paraded
parader103914863parader
parades104121463parades
parae76335703par_ae_
parallel1047473parallel
parapet11317643parapet
parasoled1246353parasoled
parcel103915473par_cel
parceled1338343parceled
parcels113712663parcels
parched154013693parched
parches143720003parches
pardee93922023par_dee
pardie96021443pardie_
pardner10239473pardner
pardy115523953par__dy
pare66760843par__e_
pared86946763par__ed
pareo74632603par__eo
parer75839903par__er
pares77164483par__es
pareses94718883pareses
pareu74928743par__eu
pareve114613013pareve_
parflesh1643743parflesh
parge85831853par_ge_
parged104922043par_ged
parges94529543par_ges
parget94529393par_get
paries84742513par_ies
parises94827183parises
parishes13314753parishes
parity114719873par_ity
parked134425143par_ked
parker124121373par_ker
parkway1934553parkway
parlays123910453par_lays
parleyed1436243par_leyed
parleyer1335633par_leyer
parlor8312673par_lor
parody12410093par_ody
parol74826273parol__
parolees104313983parolees
parols84722613parol_s
parquet18311583parquet
parred95024073par_red
parrel84515983par_rel
parrels94713493parrels
parried103615723parried
parrier93717653parrier
parries93925843parries
parroty1247863parroty
parry105323753par__ry
pars67560793pars___
parsable12311693parsable_
parsecs11429923parsecs
parsers94118153parsers
parsing103819553parsing
parsnip1146323parsnip
parson83817903pars_on
parsons93516873parsons
parted94228683par_ted
partied103516553partied
partier93520713partier
parties93230863parties
partlets102811513partlets
partner92811393partner
partway1535923partway
party106630613par__ty
partyer12337873partyer
parure8312523parure_
parures9512693parures
parve109824853par_ve_
pase65346863pa_s_e_
paseo77022513pa_s_eo
pases75346503pa_s_es
pashed125923143pa_shed
pashes115828393pa_shes
passe75525693pa_sse_
passed94320943pa_ssed
passee84522023pa_ssee
passel85117003pa_ssel
passels93913023passels
passer84721033pa_sser
passes86030473pa_sses
passkeys1742323passkeys
passless10247223passless
paste74932953pa_ste_
pasted94426903pa_sted
pastel85918713pa_stel
paster85734373pa_ster
pastes85233913pa_stes
pastry114913033pa_stry
pasty105725053pa_s_ty
patly105020583pa_tl_y
patsies93919483patsies
patsy105717203pats__y
pause75021833paus_e_
paused95114963paus_ed
pauser84415963paus_er
pauses84621473paus_es
pearled10411553pear_led
pearler9310373pear_ler
pearly116414843pear_l_y
peartly1267453peartl_y
periled10316323periled
perplex1836153perplex
perse75429523pers_e_
perses85428063pers_es
perspex1834183perspex
pertly115312553pertl_y
pigsney1342873pigsney
portly114713403portl_y
prase76128753pras_e_
prases84429023pras_es
prey96228483p_r__ey
pricey134412633p_ricey
prole74527793p_role_
proleg94612113p_roleg
proles84627203p_roles
pulley113713403p_ulley
purely114013633purel_y
purfle112511183purfle_
purfled13248733purfled
purfler12248733purfler
purfles122511843purfles
purled94520753pur_led
purple102712683purple_
purpled12299783purpled
purpler11289273purpler
purples112712833purples
purply13369053purpl_y
purse76028893purs_e_
pursed95220883purs_ed
purser85020473purs_er
purses84826373purs_es
pursier94012753pursier
pursily1238213pursily
pursue84512253pursue_
pursued10388133pursued
pursuer9338893pursuer
pursues94111373pursues
pursy105016413purs__y
purvey14559573pur_vey
pusleys12286233p_usleys
pussleys13273173pussleys
pussly11407373pussl_y
rarely93513653rarel_y
rassle63813203rassle_
rassled83310453rassled
rassles73513923rassles
riley84420583__riley
sarsen6314233sars_en
sarsnet7314813sarsnet
sparely123410673sparel_y
sparkle133710213sparkle_
sparkled15317733sparkled
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
sparkly16348133sparkl_y
sparse84516343spars_e_
sparser94311483spars_er
sparsity1345463sparsity
tarsier74119253tarsier
tartlet72218483tartlet
tartly96014023tartl_y
tersely1038113tersely
trawley13317303trawley
valley124311603va_lley
varlet9423503var_let
varsity1356673varsity
warble113516603warble_
warbled133212163warbled
warbler123211463warbler
warbles123215563warbles
warily122915093waril_y
warmly14228063warml_y
warslers11328073warslers
warstle10328013warstle_
warstled12286123warstled
warstler11275933warstler
warstles11368803warstles
yarely122810303yarel_y

Search took 7 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.406440125.6
2DLD Change Limit1340273396.33021173.3
3Display Results3393390.1232756.1
 (SQL Overall)1786913396.85926052.0
 
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.