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

235 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
parles8633440(None) 
arles56735741_arles
carles85435081carles
farles96025781farles
padles95221121padles
pales75753801pa_les
pares77164481par_es
parges94529541parges
paries84742511paries
parle75836161parle_
parled94626291parled
parley116718361parley
parleys125212371parleys
paroles95025881paroles
parses85534701parses
ables75935542_ables
ales47067102_a_les
apples104315762apples
apres75426402apr_es
ares45871022_ar_es
argles75218482_argles
arses55733872_arses
axles125219472_axles
bales76250082ba_les
barbes104526232barbes
bardes95026932bardes
bares75457132bar_es
barges94528252barges
barless94317002barless
barley115116762barley
barleys125011842barleys
barres84427542barres
baryes116218502baryes
birles84920642birles
cables104527552cables
cares77369182car_es
caries85147622caries
carle74535702carle_
carless95118492carless
carls77037422carl_s
carses85233652carses
cartes86239472cartes
carves115128452carves
caules85927252caules
dales66439742da_les
dalles74222062dalles
dares66146702dar_es
darkles124011932darkles
dartles84014132dartles
eagles73819162eagles
earless74316072earless
earls56127512earl_s
fables114921672fables
farces115223322farces
fares85852872far_es
farle86929242farle_
farls85731112farl_s
gables94222332gables
gales65442482ga_les
garbles104016922garbles
gargles94214892gargles
hales85449842ha_les
haoles94919802haoles
hares86255542har_es
harls85634502harl_s
jarls126120962jarl_s
kales95730982ka_les
kayles134712002kayles
ladles74619542ladles
larees65323112larees
lares54852632lar_es
larges74824232larges
macles107023222macles
mailes84329112mailes
males75049792ma_les
maples104819422maples
marbles114516652marbles
mares76457632mar_es
marges94525712marges
marled95523162marled
marls75535162marl_s
marses84827112marses
merles85322762merles
nares55544152nar_es
oarless73913372oarless
orles55326212_orles
paces96741112pa_ces
paddles113515642paddles
padle84522342padle_
padres95016982padres
pages85235072pa_ges
pails75833062pail_s
pale66055012pa_le_
palea75028662pa_lea
paled85538722pa_led
paler75436932pa_ler
palest83926222pa_lest
palet74650802pa_let
palets85122312pa_lets
palled94625162palled
pallet84232652pallet
pallets93919302pallets
palls74332562pa_lls
palms94921752pa_lms
palps94719562pa_lps
pals66951352pa_l_s
panels84716522panels
panes76148692pa_nes
pannes85522852pannes
papules112411572papules
parables121613562parables
parades104121462parades
parae76335702parae_
paras76143042par_as
parcel103915472parcel
parcels113712662parcels
parches143720002parches
pardee93922022pardee
pards85634332par_ds
pare66760842par_e_
pared86946762par_ed
pareo74632602par_eo
pareos87023772pareos
parer75839902par_er
parers85530742parers
pareses94718882pareses
pareu74928742par_eu
pareus85420742pareus
parflesh1643742parflesh
parge85831852parge_
parged104922042parged
parget94529392parget
pargets105215192pargets
pargos95719042pargos
paris75145942par_is
parises94827182parises
parkas125018022parkas
parked134425142parked
parker124121372parker
parkers133816872parkers
parks116134462par_ks
parlay113713992parlay
parlays123910452parlays
parlor8312672parlor
parlors9312912parlors
parlous9414292parlous
parole84425252parole_
paroled104217632paroled
parolee94119642parolee
parolees104313982parolees
parols84722612parols
parous84024162parous
parred95024072parred
parrel84515982parrel
parrels94713492parrels
parries93925842parries
parrs75928672par_rs
pars67560792par__s
parse75236992parse_
parsec105914482parsec
parsecs11429922parsecs
parsed96323892parsed
parser84822372parser
parsers94118152parsers
parsley1247802parsley
parsleys1335082parsleys
parted94228682parted
parties93230862parties
partlet92720362partlet
partlets102811512partlets
parts77743372par_ts
parures9512692parures
parve109824852parve_
parvis116114802parvis
parvos116614752parvos
pases75346502pa_ses
pashes115828392pashes
passes86030472passes
pastes85233912pastes
pates76047892pa_tes
pauses84621472pauses
paves104833922pa_ves
pawls105617662pawl_s
paxes144928422pa_xes
payees114812902payees
pearled10411552pearled
pearler9310372pearler
pearlers1039032pearlers
pearls84715392pearl_s
peles75738082p_eles
peres76246642per_es
perses85428062perses
piles74742612p_iles
poles75351002p_oles
pores75849032por_es
prases84429022prases
prates84633162prates
praxes156215182praxes
prees75937172p_rees
pries74339532p_ries
proles84627202proles
pules74538812p_ules
purees84721682purees
purfles122511842purfles
purges94421762purges
purled94520752purled
purls74723352purl_s
purples112712832purples
purses84826372purses
pyres105523882pyr_es
rales54947492ra_les
rares55247442rar_es
sables85026692sables
sales56055592sa_les
sarees65329942sarees
sarges75128592sarges
spales84728102spa_les
spares84834552spar_es
sparges104016342sparges
sparkles143210492sparkles
tables84524892tables
tales55451372ta_les
tares57456562tar_es
targes74524592targes
tarres64723042tarres
vales85434262va_les
varies94330872varies
varlet9423502varlet
varlets10411572varlets
varves124414782varves
wales86142832wa_les
warbles123215562warbles
wares88250582war_es
warless104015102warless
warsles103413642warsles

Search took 5 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 Filter178691825511.046170832.7
2DLD Change Limit825512353.64022678.8
3Display Results2352350.0802937.5
 (SQL Overall)1786912354.76637492.9
 
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.