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 “parses” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

244 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
parses8553470(None) 
arses55733871_arses
carses85233651carses
marses84827111marses
pares77164481par_es
pareses94718881pareses
parges94529541parges
paries84742511paries
parises94827181parises
parles86334401parles
parse75236991parse_
parsec105914481parsec
parsecs11429921parsecs
parsed96323891parsed
parser84822371parser
parsers94118151parsers
pases75346501pa_ses
passes86030471passes
pauses84621471pauses
perses85428061perses
prases84429021prases
purses84826371purses
apres75426402apr_es
apses76823912_apses
ares45871022_ar_es
arises65233802_arises
arles56735742_arles
arse46539272_arse_
arsis55722422_arsis
asses55629282_asses
baases85218012baases
barbes104526232barbes
bardes95026932bardes
bares75457132bar_es
barges94528252barges
barres84427542barres
baryes116218502baryes
bases75644352ba_ses
basses85428302basses
birses84717732birses
burses84425512burses
cares77369182car_es
caress85720262caress
caries85147622caries
carles85435082carles
carse74934332carse_
cartes86239472cartes
carves115128452carves
cases75048382ca_ses
causes88026472causes
corses84433462corses
crases85532312crases
curses85328272curses
daises74318982daises
dares66146702dar_es
eases56041612ea_ses
erases64425402erases
erses55826802_erses
farces115223322farces
fares85852872far_es
farles96025782farles
gases65633992ga_ses
gasses75724782gasses
gorses74723292gorses
hanses95022632hanses
hares86255542har_es
hawses125113992hawses
hearses104414532hearses
horses94729342horses
karsts106012942karsts
lapses85217692lapses
larees65323112larees
lares54852632lar_es
larges74824232larges
lases54944762la_ses
lasses64827592lasses
manses84225512manses
mares76457632mar_es
marges94525712marges
marse76231152marse_
marshes123615372marshes
masses85028712masses
nares55544152nar_es
nurses63919352nurses
oases55330982oa_ses
paces96741112pa_ces
padles95221122padles
padres95016982padres
pages85235072pa_ges
paisas84317492paisas
paise75028332paise_
pales75753802pa_les
palsies94420272palsies
panes76148692pa_nes
pannes85522852pannes
pansies94521982pansies
parades104121462parades
parae76335702parae_
paras76143042par_as
parcel103915472parcel
parcels113712662parcels
parches143720002parches
pardee93922022pardee
pards85634332par_ds
pare66760842par_e_
pared86946762par_ed
pareo74632602par_eo
pareos87023772pareos
parer75839902par_er
parers85530742parers
paresis93315092paresis
pareu74928742par_eu
pareus85420742pareus
parge85831852parge_
parged104922042parged
parget94529392parget
pargets105215192pargets
pargos95719042pargos
paris75145942par_is
parishes13314752parishes
parkas125018022parkas
parked134425142parked
parker124121372parker
parkers133816872parkers
parks116134462par_ks
parle75836162parle_
parled94626292parled
parley116718362parley
parleys125212372parleys
paroles95025882paroles
parols84722612parols
parous84024162parous
parred95024072parred
parrel84515982parrel
parrels94713492parrels
parries93925842parries
parrs75928672par_rs
pars67560792par__s
parsley1247802parsley
parsleys1335082parsleys
parson83817902parson
parsons93516872parsons
parted94228682parted
parties93230862parties
parts77743372par_ts
parures9512692parures
parve109824852parve_
parvis116114802parvis
parvises133911912parvises
parvos116614752parvos
pase65346862pa_se_
paseo77022512pa_seo
paseos88015812pa_seos
pashes115828392pashes
pass65239952pa_s_s
passe75525692passe_
passed94320942passed
passee84522022passee
passel85117002passel
passels93913022passels
passer84721032passer
passers94717752passers
passus83610292passus
pastes85233912pastes
pasts75936502pa_sts
pates76047892pa_tes
patsies93919482patsies
pause75021832pause_
paused95114962paused
pauser84415962pauser
pausers94113222pausers
paves104833922pa_ves
pavises125315492pavises
paxes144928422pa_xes
payees114812902payees
peases85229472peases
peises84125042peises
peres76246642per_es
perse75429522perse_
peruses94018162peruses
pharoses13310312pharoses
phases114618402phases
phrases12711462phrases
physes14399782physes
pisses84525082pisses
pluses83618072pluses
poises84226542poises
pores75849032por_es
poses74642762p_oses
posses85128802posses
praises94121102praises
prase76128752prase_
prates84633162prates
praxes156215182praxes
prees75937172p_rees
press75425952p_ress
pries74339532p_ries
prises84133172prises
proses84733472proses
ptoses83514672ptoses
pulses83818662pulses
purees84721682purees
purges94421762purges
purse76028892purse_
pursed95220882pursed
purser85020472purser
pursers93916092pursers
pursues94111372pursues
puses75532202p_uses
pusses84322842pusses
pyoses114314302pyoses
pyres105523882pyr_es
raises64826542raises
rares55247442rar_es
rases55447212ra_ses
sarees65329942sarees
sarges75128592sarges
saroses73619332saroses
sarsen6314232sarsen
sarsens7311392sarsens
sasses64124392sasses
spares84834552spar_es
sparges104016342sparges
sparse84516342sparse_
sparser94311482sparser
sparsest1048812sparsest
tares57456562tar_es
targes74524592targes
tarres64723042tarres
tarsus6310512tarsus
tasses64826762tasses
tawses94913192tawses
torses64727952torses
upases84112902upa_ses
urases63723562urases
valses94514612valses
varies94330872varies
varuses10310622varuses
varves124414782varves
vases84626262va_ses
verses94223762verses
wares88250582war_es
warsles103413642warsles
worses95522952worses

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit825512442.40634310.5
3Display Results2442440.0604066.7
 (SQL Overall)1786912442.82663231.1
 
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.