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

174 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
parve10982485(None) 
carve106227751carve
parae76335701parae
pare66760841par_e
pareve114613011pareve
parge85831851parge
parle75836161parle
parse75236991parse
parvo107719181parvo
pave96133891pa_ve
varve115716851varve
are37874572_ar_e
arse46539272_arse
arvo76023432_arvo
ave67748702_a_ve
barbe95328282barbe
barde85330772barde
bare65460522bar_e
barge85631022barge
barre75929542barre
barye105021492barye
brave104925502brave
calve105919922calve
care66968372car_e
carle74535702carle
carse74934332carse
carte75940422carte
carved124320852carved
carvel114817572carvel
carven114716662carven
carver114420152carver
carves115128452carves
cave95941262ca_ve
crave105626312crave
curve104920022curve
dare55848862dar_e
drave95219272drave
eave75733582ea_ve
farce104925322farce
fare76354462far_e
farle86929242farle
fauve114712072fauve
fave105532962fa_ve
garvey13127872garvey
gave84634052ga_ve
grave94624872grave
halve114818922halve
hare76255732har_e
have106137072ha_ve
jarvey19135402jarvey
laree56036292laree
large65325462large
larva8312482larva
larvae938842larvae
lave75642142la_ve
mare64759332mar_e
marge85328332marge
marse76231152marse
marvel113712002marvel
marvy135014032marvy
mauve104013272mauve
naive85116212naive
nave75732312na_ve
nerve86617372nerve
pace86345772pa_ce
padle84522342padle
padre86018162padre
page76036102pa_ge
paise75028332paise
pale66055012pa_le
pane64950292pa_ne
panne76623652panne
par57467022par__
para65242172par_a
parade94720642parade
paras76143042paras
parcel103915472parcel
parch125123002parch
pard76441322par_d
pardee93922022pardee
pardi85723952pardi
pardie96021442pardie
pards85634332pards
pardy115523952pardy
pared86946762pared
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
parged104922042parged
parges94529542parges
parget94529392parget
pargo86723722pargo
paries84742512paries
paris75145942paris
park105237492par_k
parka115120882parka
parked134425142parked
parker124121372parker
parks116134462parks
parled94626292parled
parles86334402parles
parley116718362parley
parol74826272parol
parole84425252parole
parr65731152par_r
parred95024072parred
parrel84515982parrel
parrs75928672parrs
parry105323752parry
pars67560792par_s
parsec105914482parsec
parsed96323892parsed
parser84822372parser
parses85534702parses
part65967462par_t
parted94228682parted
parts77743372parts
party106630612party
parure8312522parure
parvenu1247022parvenu
parvis116114802parvis
parvise124211692parvise
parvos116614752parvos
pase65346862pa_se
passe75525692passe
paste74932952paste
pate65350462pa_te
pause75021832pause
paved115525262pa_ved
paver104225832pa_ver
paves104833922pa_ves
payee105524722payee
peeve104915252peeve
pere66450262per_e
perse75429522perse
perv97224812perv_
pervs105117372pervs
poove104514302poove
pore66451262por_e
prase76128752prase
prate75135982prate
pree67044732p_ree
prove104823192prove
pure65543332pur_e
puree74632842puree
purge85324602purge
purse76028892purse
purvey14559572purvey
pyre94925552pyr_e
rare45348432rar_e
rave75542092ra_ve
salve85022132salve
saree55044662saree
sarge65531132sarge
save75741362sa_ve
serve85425962serve
spare75135562spar_e
sparge94216052sparge
sparse84516342sparse
starve94613742starve
tare45957622tar_e
targe65227092targe
tarre55825632tarre
trave85223032trave
valve114515932valve
varved134110602varved
varves124414782varves
verve115417722verve
waive114214602waive
ware76254722war_e
wave105234732wa_ve
wharve15456202wharve
yare75636942yar_e

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 Filter178691538000.296603685.8
2DLD Change Limit538001741.67332157.8
3Display Results1741740.0463782.6
 (SQL Overall)1786911742.01588680.4
 
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.