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

275 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
parolees10431398(None) 
parolee94119641parolee_
paroles95025881parol_es
carolers103314172carolers
parles86334402par_l_es
parleys125212372par_leys
parodies11313692parodies
parole84425252parol_e_
paroled104217632parol_ed
parols84722612parol__s
parsleys1335082parsleys
partlets102811512partlets
prolegs10379992p_rolegs
proles84627202p_rol_es
allees64521483_a_llees
amoles84122193_amol_es
anoles64827433_anol_es
apogees1037103_apogees
areoles71016953_areol_es
argles75218483_argl_es
arles56735743_ar_l_es
armless9369943_armless
armlets94610063_armlets
arouses74921293_arouses
artless73712513_artless
azoles154614613_azol_es
bailees93914383ba_ilees
barbless12318713barbless
barflies1338303barflies
bargees105415873bar_gees
barkless14318023barkless
barless94317003bar_less
barleys125011843bar_leys
baroness101210063baroness
baronets101410903baronets
baronies10315023baronies
baronnes1038553baronnes
baroques1934863baroques
cajolers17267133cajolers
cajoles163712103cajol_es
callees94117783ca_llees
careless102813633careless
carioles10817073cariol_es
carles85435083car_l_es
carless95118493car_less
caroches15710693caroches
caroled103717693carol_ed
caroler93816753carol_er
carolled1138833carolled
caroller1039203caroller
carollers1137703carollers
carols85124983carol__s
carolus94612603carol_us
caroluses1157613caroluses
carotenes11410203carotenes
carouses10614503carouses
darioles9710693dariol_es
darkles124011933darkl_es
dartles84014133dartl_es
doolees83711613_doolees
earless74316073ear_less
earlobes1056143earlobes
enrollees974323enrollees
farles96025783far_l_es
fartleks1533963fartleks
galilees936333galilees
gaolers83511563ga_olers
garblers113810283garblers
garbles104016923garbl_es
garbless11388253garbless
garglers10418263garglers
gargles94214893gargl_es
garotes8614563garo_tes
garottes978283garottes
gasolenes1045823gasolenes
girolles935523girolles
haoles94919803ha_ol_es
harmless1337403harmless
harslets1137833harslets
karosses1236493karosses
larees65323113lar__ees
mallees93315973ma_llees
marblers12319233marblers
marbles114516653marbl_es
marquees19206243marquees
martlets103310483martlets
oarless73913373oar_less
paddlers12329153paddlers
paddles113515643paddl_es
padles95221123pa_dl_es
padrones112711043padro_nes
painless10108343painless
paisleys1333343paisleys
pales75753803pa__l_es
palets85122313pa__lets
pallets93919303pa_llets
paneless102611763paneless
panoches1548123panoches
panoplies1346003panoplies
papooses1248053papooses
papules112411573papul_es
parables121613563parables
paracletes1446093paracletes
paraders113113113paraders
parades104121463par_ades
parakeet14410523parakeet
parakeets1545103parakeets
parallel1047473parallel
parallels1145273parallels
paralyse1347483paralyse
paralyses1448283paralyses
paralyzes2346493paralyzes
parapets1239763parapets
parbakes1638343parbakes
parceled1338343parceled
parcels113712663par_cels
parcheesi16233763parcheesi
parches143720003par_ches
parclose1247243parclose
parcloses1347963parcloses
pardee93922023par_dee_
pardners11269193pardners
pardoners12208213pardoners
pareos87023773par__eos
parers85530743par__ers
pares77164483par___es
pareses94718883par_eses
pareus85420743par__eus
parfleches2042173parfleches
parflesh1643743parflesh
parfleshes1842963parfleshes
parges94529543par__ges
pargets105215193par_gets
paries84742513par__ies
parietes10714543parietes
parises94827183par_ises
parishes13314753parishes
parities10522973parities
parkades1538273parkades
parkers133816873par_kers
parlays123910453par_lays
parle75836163par_l_e_
parled94626293par_l_ed
parley116718363par_l_ey
parleyed1436243par_leyed
parleyer1335633par_leyer
parleyers1444703par_leyers
parlors9312913par_lors
parlours1036153parlours
parlous9414293par_lous
parodied1238333parodied
parodos103011753paro_dos
parol74826273parol___
paroling113316213paroling
paronyms1546553paronyms
paroquet1947283paroquet
paroquets2043643paroquets
parotids112610413parotids
parous84024163paro__us
parquets1936413parquets
parrels94713493par_rels
parriers103612903parriers
parries93925843par_ries
parrokets1543923parrokets
parroters1156763parroters
parsecs11429923par_secs
parsers94118153par_sers
parses85534703par__ses
parsley1247803parsl_ey
parsleyed1543353parsleyed
parslied1137823parslied
partakes1449923partakes
partiers103514243partiers
parties93230863par_ties
partlet92720363partl_et
partners102711133partners
partyers13277763partyers
parures9512693par_ures
parvises133911913parvises
parvolines1585993parvolines
parvolins1486693parvolins
passless10247223passless
pastless102411203pastless
pathless13138043pathless
patrolled1245713patrolled
patroller1145743patroller
patrollers1244813patrollers
patrolmen1344023patrolmen
patrols93513513patrol__s
patroness1137483patroness
pawnees12298173pa_wnees
payees114812903pa__yees
payolas12148973payol_as
payrolls1344753payrol_ls
pearlers1039033pear_lers
perigees1189503perigees
perplexes2044683perplexes
pharisees1444633pharisees
pharoses13310313pharo_ses
picotees1247113picotees
pinoles93418703pinol_es
piolets93513193p_iolets
pirogies1139423pirogies
pirogues1135473pirogues
piroques1944353piroques
poleis86018353p__oleis
polers84225643p__olers
poles75351003p__ol_es
polies84034583p__olies
pollees93215333p_ollees
poolers94217423p_oolers
portless10310643portless
posoles9314883posol_es
pozoles1839063pozol_es
prees75937173p_r__ees
probers113514583p_robers
probes104119453p_ro_bes
problems1434343p_roblems
proceed12310553p_roceed
proceeds1335983p_roceeds
process11310403p_rocess
proems104711163p_ro_ems
profess1237713p_rofess
projets1639163p_rojets
prolans9314273p_rolans
prole74527793p_rol_e_
proleg94612113p_rol_eg
prolepses13126193p_rolepses
prolines102619693p_rolines
prologs103512133p_rologs
propels113412843p_ropels
propenes122816513p_ropenes
propers113619033p_ropers
prosers94219643p_rosers
proses84733473p_ro_ses
prosses94019513p_rosses
proteas92015123p_roteas
proteges1149923p_roteges
proteus92511593p_roteus
provers123817793p_rovers
proves114322253p_ro_ves
prowess1237903p_rowess
prowlers13328933p_rowlers
proxies163014933p_roxies
purees84721683pur__ees
purflers13216963purflers
purfles122511843purfl_es
purples112712833purpl_es
pyrogens1437293pyrogens
pyrolas1239863pyrol_as
pyrolizes2347233pyrolizes
pyrolyses1745583pyrolyses
pyrolyzes2644293pyrolyzes
pyrones123113303pyro_nes
pyropes142210193pyro_pes
pyroxenes2145453pyroxenes
pyrroles1345453pyrrol_es
roles56747983__rol_es
safroles1136933safrol_es
sarees65329943sar__ees
sarodes84216143saro_des
saroses73619333saro_ses
sparklers15315643sparklers
sparkles143210493sparkl_es
sparklets15275843sparklets
tartlets8289663tartlets
varioles11711123variol_es
varlets10411573var_lets
warblers13319103warblers
warbles123215563warbl_es
wardless12249303wardless
warless104015103war_less
warslers11328073warslers
warsles103413643warsl_es
wartless11279923wartless

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622758.09318060.3
3Display Results2752750.1102500.0
 (SQL Overall)1786912758.60920756.3
 
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.