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 “parlays” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

385 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
parlays12391045(None) 
parlay113713991parlay_
parleys125212381parleys
allays94313742_allays
arrays95311682_arrays
barleys125011842barleys
earlaps936392earlaps
margays1337492margays
palais8420422pa_lais
paralyse1347482paralyse
paras76143042par_a_s
pardahs13289672pardahs
pariahs123812342pariahs
parians93519742parians
parkas125018022parka_s
parkways2043972parkways
parlayed1435822parlayed
parles86334412parl_es
parley116718362parley_
parlors9312912parlors
parlous9414292parlous
parrals94414572parrals
parsleys1335092parsleys
partans94418282partans
paydays1634432paydays
plays106320772p__lays
prays105022432p_r_ays
waylays1634672waylays
airplays1344533airplays
airways1336243airways
alans55636173_a_lans
alas46358123_a_la_s
allay85620393_allay_
alleys95113303_alleys
alloys94014563_alloys
always12409133_always
anlas55626933_anla_s
araks94820883_ar_aks
areas55935773_area_s
argals75517713_argals
arhats9312973_arhats
arias55438023_aria_s
arles56735743_arl_es
arras55626133_arra_s
array86317143_array_
assays977903_assays
atlas55821583_atla_s
baileys12388933baileys
balas76937213ba_la_s
ballads104212913ballads
barcas101016603barca_s
barless94317003barless
barley115116763barley_
barlows12259983barlows
barneys12569563barneys
belays114313853_belays
brays106723113_br_ays
burlaps1156253burlaps
burleys12479673burleys
byplays1743103byplays
callans94518473callans
callas84526753calla_s
carats85929023car_ats
caraways1636953caraways
carboys144711783carboys
carcass11310513carcass
carles85435083carl_es
carless95118493carless
carlins93921923carlins
carloads1138393carloads
carls77037423carl__s
carneys124310543carneys
carpals113414633carpals
charleys1695633charleys
clays105521333__clays
cullays12347703cullays
darbars10510093darbars
darkeys15356533darkeys
delays104014053_delays
derays105514253der_ays
drays95819773_dr_ays
earflaps1342553earflaps
earlap837183earla_p
earless74316073earless
earls56127513earl__s
early85324123earl_y_
fairways1743873fairways
fallals103310193fallals
faradays1544273faradays
farads104713273far_ads
farfals13268503farfals
farles96025783farl_es
farls85731113farl__s
flays116321053__flays
forays124813003for_ays
frays116920103_fr_ays
galahs105512683ga_lahs
galas65731643ga_la_s
galleys11369713galleys
gamays126310913ga_mays
garland948703garland
garlands1038323garlands
garlics1038013garlics
garveys14124463garveys
grays95621333_gr_ays
halals95018313ha_lals
hallahs133912463hallahs
hallways1745423hallways
harass9313943har_ass
hardass1139753hardass
harlots103413293harlots
harls85634503harl__s
hartals10313023hartals
hearsays1444513hearsays
hurleys13407333hurleys
hurrays13386153hurrays
inlays9389873_inlays
jalaps15299183ja_laps
jarls126120963jarl__s
jarrahs1735453jarrahs
jarveys20123413jarveys
kalams12310603ka_lams
karats106420493kar_ats
karmas123013743karma_s
lallans74113543lallans
lariats7615053lariats
larvas9310233larva_s
lays76043253___lays
malars85020683ma_lars
maras75443293mar_a_s
margay12310593margay_
markas124717003marka_s
marlins93420483marlins
marls75535163marl__s
marly106925613marl_y_
marrams11310123marrams
maydays1634493maydays
mislays12349243mislays
morays114613883mor_ays
nalas55528363na_la_s
narwals1036983narwals
naysays1344123naysays
oarless73913373oarless
onlays9398713_onlays
outlays102610903outlays
overlays14239693overlays
pablums1345123pablums
pacas96029403pa_ca_s
pachas135017143pacha_s
padles95221123padl_es
padnags1135083padnags
paeans85118263pa_eans
paellas9411413paellas
paesans93312693paesans
pagans95717923pa_gans
pahlavi1542643pahlavi
pahlavis1643343pahlavis
pails75833063pail__s
paisans93614753paisans
paisas84317493paisa_s
paisleys1333353paisleys
palace104516923pa_lace
palaces114216463pa_laces
palapa10310673pa_lapa
palapas11311493pa_lapas
palate84226793pa_late
palates93624943pa_lates
pales75753803pa_l_es
palets85122313pa_lets
paleways1645833paleways
pallets93919303pallets
pallors9314363pallors
palls74332563pa_l_ls
pally105727123pa_lly_
palms94921753pa_l_ms
palmy126016733pa_lmy_
palps94719563pa_l_ps
palpus104210283pa_lpus
pals66951353pa_l__s
palsy105417463pa_lsy_
paly95835533pa_l_y_
pampas124913993pampa_s
pandas95521963panda_s
pangas99921113panga_s
papas94927493pa_pa_s
papaws13419113pa_paws
papaya1337503pa_paya
papayas1437273pa_payas
para65242173par_a__
parade94720643par_ade
parades104121473parades
parados103816053parados
parae76335703par_a_e
paralysed1545743paralysed
paralyses1448293paralyses
paralysis1447323paralysis
paralyze2246633paralyze
paralyzes2346503paralyzes
paramo102614643par_amo
paramos113213513paramos
parang93715513par_ang
parangs104314383parangs
paraph13311263par_aph
paraphs1439313paraphs
parbake1538353parbake
parbakes1638343parbakes
parcels113712663parcels
parches143720003parches
pardah123412823parda_h
pardons103817623pardons
pards85634333par__ds
pardy115523953par_dy_
parents93418133parents
pareos87023773par_eos
parers85530743par_ers
pares77164483par__es
pareses94718883pareses
paresis93315093paresis
pareus85420743par_eus
parfait12312053parfait
parfaits1346913parfaits
parges94529543par_ges
pargets105215193pargets
pargos95719043par_gos
pariah114320583paria_h
parian83223963paria_n
paries84742523par_ies
parings104219223parings
paris75145943par__is
parises94827193parises
parity114719873parity_
parka115120883parka__
parkade1437583parkade
parkades1538273parkades
parkers133816873parkers
parkland1545373parkland
parklands1654723parklands
parks116134463par__ks
parkway1934553parkway_
parlance1248723parlance
parlances1348963parlances
parlando1145413parlando
parlante1039693parlante
parlaying1537303parlaying
parle75836163parl__e
parled94626293parl_ed
parleyed1436243parleyed
parleyer1335633parleyer
parleyers1444713parleyers
parling103823763parling
parlor8312673parl_or
parlour937263parlour
parlours1036153parlours
parodos103011753parodos
parody12410093parody_
parolees104313993parolees
paroles95025893paroles
parols84722613par_ols
paronym1437503paronym
paronyms1546553paronyms
parous84024163par_ous
paroxysm2242733paroxysm
parral85517533parra_l
parrels94713493parrels
parries93925853parries
parrots9312743parrots
parrs75928673par__rs
parry105323753par_ry_
pars67560793par___s
parsecs11429923parsecs
parsers94118153parsers
parses85534703par_ses
parsley1247803parsley_
parsons93516873parsons
partake1339643partake
partakes1449923partakes
partan83820563parta_n
partials101911973partials
parties93230873parties
partlets102811523partlets
partly116315473partly_
partons94620513partons
parts77743373par__ts
partway1535923partway_
party106630613par_ty_
paruras9310543paruras
parures9512693parures
parvis116114803par_vis
parvos116614753par_vos
pascals11610013pascals
pashas115117063pasha_s
pastas85422873pasta_s
pathways1944273pathways
patly105020583patl_y_
paulins9312613paulins
pavans115715593pa_vans
pawls105617663pawl__s
pawpaws1732823pawpaws
payday1536613payday_
payloads1445293payloads
payolas12148973payola_s
pays95940223p___ays
pearlash1344133pearlash
pearlers1039033pearlers
pearls84715393pearl__s
pearly116414843pearl_y_
pedlars103210213pedlars
perhaps1446123perhaps
phreaks1634543phreaks
pilafs113511023p_ilafs
pilaus84114133p_ilaus
pilaws11399433p_ilaws
pillars9313493pillars
piraya1167713pir_aya
pirayas1277483pir_ayas
plans75731273p__lans
plats75531373p__lats
platys11459853p__latys
play95928983p__lay_
playa105812943p__laya
playas114612283p__layas
playdays1742973playdays
ploys105816593p__loys
polars84419353p_olars
polys105718763p_ol_ys
poplars113910333poplars
portals94015563portals
portrays1345293portrays
praams10459643p_raams
prams96125513p_r_ams
praos74923563p_r_aos
prats76333393p_r_ats
praus74621753p_r_aus
pray96331533p_r_ay_
prepays1437483prepays
preys105717783p_r_eys
proas75028803p_roa_s
prolans9314273prolans
pulleys12399143pulleys
purdahs13285483purdahs
purdas92612263purda_s
purlins93415423purlins
purls74723353purl__s
purveys15615903purveys
pusleys12286233pusleys
pyrans11411063pyr_ans
pyrolas1239863pyrola_s
raglans82410133raglans
railways1444603railways
rays77642353__r_ays
relays94316753_relays
replays12399763replays
salads75316963sa_lads
salals65120083sa_lals
sarans64224433sar_ans
sardars83112903sardars
sarsars73512143sarsars
sashays1336333sashays
satays94411683sa_tays
slays85723683__slays
splays114910873_splays
sprays115913643spr_ays
strays96417933str_ays
tablas83716163tabla_s
talars66021683ta_lars
talas55935893ta_la_s
tarmacs1138323tarmacs
tarpans92513533tarpans
tarsals72512603tarsals
tartans72615823tartans
tartars73313403tartars
tarzans16329923tarzans
trays85623433_tr_ays
unlays93810493_unlays
valleys13407483valleys
varas86028193var_a_s
varias95019903varia_s
varlets10411573varlets
varnas94212823varna_s
virelays1444643virelays
wallahs13409473wallahs
wallas95719393walla_s
warless104015103warless
warsaws1335763warsaws
waylay1535453waylay_

Search took 9 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 Filter1786911340270.406440125.6
2DLD Change Limit1340273857.79617191.8
3Display Results3853850.1402750.0
 (SQL Overall)1786913858.34221420.6
 
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.