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

181 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
parge8583185(None) 
barge85631021barge
large65325461large
marge85328331marge
page76036101pa_ge
parae76335701parae
pare66760841par_e
parged104922031parged
parges94529541parges
parget94529391parget
pargo86723721pargo
parle75836161parle
parse75236991parse
parve109824851parve
purge85324601purge
sarge65531131sarge
sparge94216041sparge
targe65227091targe
aargh96314082aargh
age47154332_a_ge
are37874572_ar_e
argle65421562_argle
argue64818442_argue
arse46539272_arse
badge94819682badge
barbe95328282barbe
barde85330772barde
bare65460522bar_e
barege94713542barege
barged105822642barged
bargee94624442bargee
barges94528252barges
barre75929542barre
barye105021492barye
cadge94018782cadge
cage75339062ca_ge
care66968372car_e
cargo85322072cargo
carle74535702carle
carse74934332carse
carte75940422carte
carve106227752carve
charge125114212charge
dare55848862dar_e
dirge75117072dirge
eagre64315322eagre
fadge104816992fadge
farce104925322farce
fare76354462far_e
farle86929242farle
forge95126942forge
gage65936102ga_ge
garage8314512garage
garget84327272garget
gargle84215462gargle
gauge76117902gauge
gorge76423892gorge
gurge75419782gurge
hare76255732har_e
laree56036292laree
larger74417512larger
larges74824232larges
largo65319782largo
mage75739122ma_ge
mange84930182mange
mare64759322mar_e
marges94525712marges
marse76231152marse
merge84523682merge
pace86345772pa_ce
padle84522342padle
padre86018162padre
paged95926782pa_ged
pager84728202pa_ger
pages85235072pa_ges
paise75028332paise
pale66055012pa_le
pane64950282pa_ne
pang75336282pang_
panga85323532panga
panged104722332panged
pangen94115912pangen
pangs84628662pangs
panne76623652panne
par57467022par__
para65242172par_a
parade94720642parade
paras76143042paras
parcel103915472parcel
parch125123002parch
pard76441322par_d
pardee93922022pardee
pardi85723952pardi
pardie96021442pardie
pards85634332pards
pardy115523952pardy
pared86946762pared
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
pareve114613012pareve
pargets105215192pargets
pargos95719042pargos
paries84742512paries
paris75145942paris
park105237492par_k
parka115120882parka
parked134425132parked
parker124121372parker
parks116134462parks
parled94626272parled
parles86334392parles
parley116718352parley
parol74826272parol
parole84425252parole
parr65731152par_r
parred95024072parred
parrel84515982parrel
parrs75928672parrs
parry105323752parry
pars67560792par_s
parsec105914472parsec
parsed96323892parsed
parser84822372parser
parses85534702parses
part65967462par_t
parted94228682parted
parts77743372parts
party106630612party
parure8312522parure
parvo107719182parvo
pase65346862pa_se
passe75525692passe
paste74932952paste
pate65350462pa_te
pause75021832pause
pave96133892pa_ve
payee105524722payee
peage84723562peage
pere66450262per_e
perse75429522perse
phage115113672phage
plage84520402plage
pore66451262por_e
porgy116916122porgy
prase76128752prase
prate75135982prate
pree67044732p_ree
pure65543332pur_e
puree74632842puree
purged104918262purged
purger94717232purger
purges94421762purges
purse76028892purse
pyre94925552pyr_e
rage55742352ra_ge
range64728412range
rare45348432rar_e
sage55044592sa_ge
saree55044662saree
sarges75128592sarges
sargo65424412sargo
serge64727462serge
spare75135562spar_e
sparged113512752sparged
sparger103613072sparger
sparges104016332sparges
sparse84516342sparse
spurge93711322spurge
surge65027692surge
tare45957622tar_e
targes74524592targes
target75028902target
tarre55825632tarre
urge54722412_urge
varve115716852varve
verge93419832verge
wage84834082wa_ge
ware76254722war_e
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.0961861364.6
2DLD Change Limit538001811.89028465.6
3Display Results1811810.0632873.0
 (SQL Overall)1786911812.04987208.9
 
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.