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

185 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
parae7633570(None) 
para65242171para_
parade94720641parade
paras76143041paras
pare66760841par_e
parge85831851parge
parle75836161parle
parse75236991parse
parve109824851parve
alae45643752_alae
arak86929572_arak
arame75026622_arame
are37874572_ar_e
area45843392_area
areae55229742_areae
arse46539272_arse
aurae54128112aurae
barbe95328282barbe
barde85330772barde
bare65460522bar_e
barge85631022barge
barre75929542barre
barye105021492barye
brae65639112_brae
carafe115416162carafe
carat75048792carat
carate84734002carate
care66968372car_e
carle74535702carle
carse74934332carse
carte75940422carte
carve106227752carve
dare55848862dar_e
farad95720672farad
farce104925322farce
fare76354462far_e
farle86929242farle
frae75330472_frae
garage8314512garage
hare76255732har_e
karat96837592karat
karate105320922karate
laree56036292laree
large65325462large
larvae938842larvae
laurae64011662laurae
mara67444562mara_
maras75443282maras
mare64759322mar_e
marge85328332marge
marse76231152marse
morae75831192morae
paca85132242paca_
pacas96029402pacas
pace86345772pa_ce
padle84522342padle
padre86018162padre
paean77222722paean
pagan86121162pagan
page76036102pa_ge
paise75028332paise
palace104516912palace
palate84226782palate
pale66055012pa_le
palea75028662palea
paleae84820292paleae
pane64950282pa_ne
panne76623652panne
papa85827142papa_
papal95820672papal
papas94927492papas
papaw125112492papaw
par57467022par__
parable111819772parable
paraded114014262paraded
parader103914862parader
parades104121462parades
paramo102614642paramo
parang93715512parang
parapet11317642parapet
paraph13311262paraph
parbake1538352parbake
parcel103915472parcel
parch125123002parch
pard76441322par_d
pardah123412822pardah
pardee93922022pardee
pardi85723952pardi
pardie96021442pardie
pards85634332pards
pardy115523952pardy
pared86946762pared
pareo74632602pareo
parer75839902parer
pares77164482pares
pareu74928742pareu
pareve114613012pareve
parged104922032parged
parges94529542parges
parget94529392parget
pargo86723722pargo
pariah114320582pariah
parian83223962parian
paries84742512paries
paris75145942paris
park105237492par_k
parka115120882parka
parkade1437582parkade
parkas125018022parkas
parked134425132parked
parker124121372parker
parks116134462parks
parlay113713992parlay
parled94626272parled
parles86334392parles
parley116718352parley
parol74826272parol
parole84425252parole
parr65731152par_r
parral85517532parral
parred95024072parred
parrel84515982parrel
parrs75928672parrs
parry105323752parry
pars67560792par_s
parsec105914472parsec
parsed96323892parsed
parser84822372parser
parses85534702parses
part65967462par_t
partake1339642partake
partan83820562partan
parted94228682parted
parts77743372parts
party106630612party
parure8312522parure
parvo107719182parvo
pase65346862pa_se
passe75525692passe
paste74932952paste
pate65350462pa_te
pause75021832pause
pavan106518472pavan
pavane114113442pavane
pave96133892pa_ve
payee105524722payee
pere66450262per_e
perea75026442perea
perse75429522perse
phrase11109902phrase
pirate82322882pirate
pore66451262por_e
praam94815612praam
pram85733492p_ram
prao66229022p_rao
prase76128752prase
prat65952042p_rat
prate75135982prate
prau66529472p_rau
pray96331532p_ray
pree67044732p_ree
psoae74411622psoae
pupae96515642pupae
pure65543332pur_e
puree74632842puree
purge85324602purge
purse76028892purse
pyran10514472pyran
pyre94925552pyr_e
rare45348432rar_e
saran53730302saran
sarape84817572sarape
saree55044662saree
sarge65531132sarge
spare75135562spar_e
sparge94216042sparge
sparse84516342sparse
tare45957622tar_e
targe65227092targe
tarre55825632tarre
vara75530882vara_
varas86028192varas
varve115716852varve
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.1731032896.0
2DLD Change Limit538001851.93627789.3
3Display Results1851850.0632936.5
 (SQL Overall)1786911852.17282270.3
 
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.