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

262 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
parse7523699(None) 
arse46539271_arse
carse74934331carse
marse76231151marse
paise75028331paise
parae76335701parae
pare66760841par_e
pares77164481pares
parge85831851parge
parle75836161parle
pars67560791pars_
parsec105914481parsec
parsed96323891parsed
parser84822371parser
parses85534701parses
parve109824851parve
pase65346861pa_se
passe75525691passe
pause75021831pause
perse75429521perse
prase76128751prase
purse76028891purse
sparse84516341sparse
apres75426402apres
apse67725382_apse
are37874572_ar_e
ares45871022_ares
arise56436432_arise
arose55832082_arose
ars37670932_ars_
arses55733872_arses
barbe95328282barbe
barde85330772barde
bare65460522bar_e
bares75457132bares
barge85631022barge
barre75929542barre
bars66564092bars_
barye105021492barye
base64847022ba_se
birse74517402birse
burse75527252burse
care66968372car_e
cares77369182cares
carle74535702carle
cars67364762cars_
carses85233652carses
carte75940422carte
carve106227752carve
case65848082ca_se
cause75225352cause
coarse84813892coarse
corse75036182corse
curse75829142curse
dare55848862dar_e
dares66146702dares
ears46356592ears_
ease45042332ea_se
erase54925492erase
false84818122false
farce104925322farce
fare76354462far_e
fares85852872fares
farle86929242farle
gars55750742gars_
gorse65926812gorse
hanse85722792hanse
hare76255732har_e
hares86255542hares
harsh116418052harsh
hawse116015122hawse
hearse94114272hearse
hoarse94411322hoarse
horse86132652horse
jars117338352jars_
karst97228992karst
lapse74917682lapse
laree56036292laree
lares54852632lares
large65325462large
lars46956572lars_
lase46148512la_se
manse75528222manse
mare64759322mar_e
mares76457632mares
marge85328332marge
mars66261862mars_
marses84827112marses
marsh105320852marsh
masse75125292masse
morse76032702morse
nares55544152nares
nurse54420122nurse
oars46846032oars_
pace86345772pa_ce
paces96741112paces
pacs85842182pacs_
padle84522342padle
padre86018162padre
padres95016982padres
pads76742952pads_
page76036102pa_ge
pages85235072pages
pairs75325832pairs_
paisa76021072paisa
pale66055012pa_le
pales75753802pales
pals66951352pals_
palsy105417462palsy
pams85641762pams_
pane64950282pa_ne
panes76148692panes
panne76623652panne
pans65855722pans_
pansy105717972pansy
paps86443452paps_
par57467022par__
para65242172par_a
parade94720642parade
paras76143042paras
parcel103915472parcel
parch125123002parch
pard76441322par_d
pardee93922022pardee
pardi85723952pardi
pardie96021442pardie
pards85634332pards
pardy115523952pardy
pared86946762pared
pareo74632602pareo
parer75839902parer
pareses94718882pareses
pareu74928742pareu
pareve114613012pareve
parged104922032parged
parges94529542parges
parget94529392parget
pargo86723722pargo
paries84742512paries
paris75145942paris
parises94827182parises
parish115022352parish
park105237492par_k
parka115120882parka
parked134425132parked
parker124121372parker
parks116134462parks
parled94626272parled
parles86334402parles
parley116718352parley
parol74826272parol
parole84425252parole
parr65731152par_r
parred95024072parred
parrel84515982parrel
parrs75928672parrs
parry105323752parry
parsecs11429922parsecs
parsers94118152parsers
parsley1247792parsley
parson83817902parson
part65967462par_t
parted94228682parted
parts77743372parts
party106630612party
parure8312522parure
parvise124211692parvise
parvo107719182parvo
pas58775742pa_s_
paseo77022512pa_seo
pases75346502pa_ses
pash95638132pa_sh
pass65239952pa_ss
passed94320942passed
passee84522022passee
passel85117002passel
passer84721032passer
passes86030472passes
past65959012pa_st
paste74932952paste
pate65350462pa_te
pates76047892pates
pats66460852pats_
patsy105717202patsy
paused95114962paused
pauser84415962pauser
pauses84621472pauses
pave96133892pa_ve
paves104833922paves
pavise114714802pavise
paws96038182paws_
paxes144928422paxes
payee105524722payee
pays95940222pays_
pears75138612pears_
pease75231112pease
peise75825772peise
pere66450262per_e
peres76246642peres
perses85428062perses
peruse84016842peruse
phase104617212phase
phrase11109902phrase
poise75127892poise
pore66451262por_e
pores75849032pores
porose84818742porose
pose66441732p_ose
posse74722272posse
praise84419412praise
prases84429022prases
prate75135982prate
pree67044732p_ree
prese75228382prese
prise74632612prise
prose75835122prose
pulse74219972pulse
pure65543332pur_e
puree74632842puree
purge85324602purge
purs65641042purs_
pursed95220882pursed
purser85020472purser
purses84826372purses
pursue84512252pursue
pursy105016412pursy
pyre94925552pyr_e
pyres105523882pyres
raise54828052raise
rare45348432rar_e
rares55247442rares
rase46149982ra_se
saree55044662saree
sarge65531132sarge
sarsen6314232sarsen
spare75135562spar_e
spares84834552spares
sparge94216042sparge
spars75431542spars_
sparser94311482sparser
tare45957622tar_e
tares57456562tares
targe65227092targe
tarre55825632tarre
tars46763952tars_
tarsi55222172tarsi
tasse54821842tasse
tawse85616502tawse
terse55026822terse
torse55833332torse
urase54624682urase
valse85117522valse
vars75742072vars_
varve115716852varve
vase75629652va_se
verse84723582verse
ware76254722war_e
wares88250582wares
wars78659802wars_
warsle93112922warsle
worse86525262worse
yare75636942yar_e

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538002621.75030742.9
3Display Results2622620.0803275.0
 (SQL Overall)1786912621.92392923.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.