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

356 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
parolee9411964(None) 
parole84425251parol_e
paroled104217631paroled
parolees104313981parolees
paroles95025881paroles
caroled103717692caroled
caroler93816752caroler
pardee93922022par_dee
parle75836162par_l_e
parled94626292par_led
parles86334402par_les
parley116718362par_ley
parol74826272parol__
parols84722612parol_s
parsley1247802parsley
partlet92720362partlet
prole74527792p_rol_e
proleg94612112p_roleg
proles84627202p_roles
aglee65728493_a_glee
alee46652323_a__lee
allee54932123_a_llee
amole75724593_amol_e
amoles84122193_amoles
anole55330383_anol_e
anoles64827433_anoles
apogee9312563_apogee
aproned10311503aproned
areolae7811733_areolae
areole61017283_areol_e
areoles71016953_areoles
argle65421563_argl_e
argled85314553_argled
argles75218483_argles
ariled75620323_ariled
arles56735743_ar_les
armlet84118193_armlet
arose55832083_aro_se
arouse65019983_arouse
azole145118033_azol_e
azoles154614613_azoles
bailee84526013ba_ilee
bargee94624443bar_gee
barley115116763bar_ley
baronet91022203baronet
baronne938263baronne
baroque1835103baroque
cajole154011183cajol_e
cajoled17428283cajoled
cajoler16398393cajoler
cajoles163712103cajoles
callee84327293ca_llee
cariole9818343cariol_e
carioles10817073carioles
carle74535703car_l_e
carles85435083car_les
caroche1469243caroche
carol75128613carol__
carolers103314173carolers
caroli85918233carol_i
carolled1138833carolled
caroller1039203caroller
carols85124983carol_s
carolus94612603carolus
caromed123713623caromed
carotene1039133carotene
carouse9614423carouse
dariole8711163dariol_e
darioles9710693darioles
darkle113813943darkl_e
darkled13378723darkled
darkles124011933darkles
dartle73714833dartl_e
dartled9409853dartled
dartles84014133dartles
doolee73018953_doolee
earlobe946543earlobe
enrollee878343enrollee
farle86929243far_l_e
farles96025783far_les
fartlek1434493fartlek
galilee8312213galilee
gaoled84814503ga_oled
gaoler73913573ga_oler
garble94118453garbl_e
garbled114512803garbled
garbler104012563garbler
garbles104016923garbles
gargle84215463gargl_e
gargled104210673gargled
gargler93710263gargler
gargles94214893gargles
garote7717953garo_te
garoted9710133garoted
garotes8614563garotes
garotte868703garotte
gasolene945553gasolene
girolle835793girolle
haole84820083ha_ol_e
haoles94919803ha_oles
harslet10315653harslet
laree56036293lar__ee
mallee84525593ma_llee
marble104219103marbl_e
marbled123212113marbled
marbler113511673marbler
marbles114516653marbles
marled95523163mar_led
marquee18218583marquee
martlet93419153martlet
paddle104615143paddl_e
paddled123612023paddled
paddler113711553paddler
paddles113515643paddles
padle84522343pa_dl_e
padles95221123pa_dles
padrone102512073padro_ne
padrones112711043padrones
paisley1235553paisley
pale66055013pa__l_e
palea75028663pa__lea
paleae84820293pa__leae
paled85538723pa__led
paler75436933pa__ler
pales75753803pa__les
palet74650803pa__let
palled94625163pa_lled
pallet84232653pa_llet
paneled10612573paneled
panoche1456383panoche
papoose1147513papoose
papulae11249353papulae
papule102212133papul_e
papules112411573papules
parable111819773parable
parables121613563parables
paraclete1356343paraclete
parade94720643par_ade
paraded114014263paraded
parader103914863parader
parades104121463parades
parae76335703par__ae
parakeet14410523parakeet
parallel1047473parallel
paralyse1347483paralyse
paralyze2246623paralyze
parapet11317643parapet
parasoled1246353parasoled
parbake1538353parbake
parboiled1445223parboiled
parcel103915473par_cel
parceled1338343parceled
parcels113712663parcels
parched154013693parched
parches143720003parches
parclose1247243parclose
pardie96021443par_die
pardine103616723pardine
pardner10239473pardner
pardoned12189333pardoned
pardoner11189443pardoner
pare66760843par___e
pared86946763par__ed
pareo74632603par__eo
parer75839903par__er
pares77164483par__es
pareses94718883pareses
pareu74928743par__eu
pareve114613013par_eve
parfleche1951913parfleche
parflesh1643743parflesh
parge85831853par__ge
parged104922043par_ged
parges94529543par_ges
parget94529393par_get
paries84742513par_ies
parises94827183parises
parkade1437583parkade
parked134425143par_ked
parker124121373par_ker
parklike1337493parklike
parlay113713993par_lay
parleyed1436243par_leyed
parleyer1335633par_leyer
parleys125212373par_leys
parlor8312673par_lor
parlors9312913parlors
parlour937263parlour
parlous9414293parlous
parodic122311723parodic
parodied1238333parodied
parodies11313693parodies
parodoi10267723parodoi
parodos103011753parodos
parody12410093paro_dy
parolable1347113parolable
paroling113316213paroling
paronym1437503paronym
paroquet1947283paroquet
parotic112518043parotic
parotid102915513parotid
parous84024163paro_us
parquet18311583parquet
parred95024073par_red
parrel84515983par_rel
parrels94713493parrels
parried103615723parried
parrier93717653parrier
parries93925843parries
parroket1449203parroket
parroted1158843parroted
parroter1058203parroter
parse75236993par__se
parsec105914483par_sec
parsed96323893par_sed
parser84822373par_ser
parses85534703par_ses
parsleyed1543353parsleyed
parsleys1335083parsleys
parslied1137823parslied
partake1339643partake
parted94228683par_ted
partied103516553partied
partier93520713partier
parties93230863parties
partite9317133partite
partlets102811513partlets
partly116315473partl_y
partner92811393partner
partyer12337873partyer
parure8312523par_ure
parures9512693parures
parve109824853par__ve
parvise124211693parvise
parvolin1376933parvolin
parvoline1477173parvoline
passee84522023pa_ssee
patrol83213023patrol__
patrolled1245713patrolled
patroller1145743patroller
patrolmen1344023patrolmen
patrols93513513patrol_s
pattee84323383pa_ttee
pawnee113115403pa_wnee
payee105524723pa__yee
payola11208113payol_a
payolas12148973payolas
payroll1245613payrol_l
payrolls1344753payrolls
pearled10411553pear_led
pearler9310373pear_ler
perigee101113393perigee
periled10316323periled
perplex1836153perplex
pharisee1347603pharisee
pharoses13310313pharoses
picotee11311473picotee
pinole83218783pinol_e
pinoles93418703pinoles
piolet83225643p_iolet
pirogen1038263pirogen
pirogue1045413pirogue
piroque1844353piroque
pole65951303p__ol_e
poled84934843p__oled
poler74431793p__oler
poles75351003p__oles
pollee83623273p_ollee
pooled94619813p_ooled
pooler83819843p_ooler
porose84818743poro_se
posole8314223posol_e
posoles9314883posoles
pozole1758913pozol_e
pozoles1839063pozoles
pree67044733p_r__ee
probe94320813p_ro_be
probed114114823p_robed
prober104516073p_rober
probes104119453p_robes
problem1335983p_roblem
proceed12310553p_roceed
proem94818273p_ro_em
projet15315183p_rojet
prolan8414693p_rolan
prolate9419793p_rolate
prolegs10379993p_rolegs
proline92321593p_roline
prolix1538683p_rolix
prolog94212973p_rolog
prone75332623p_ro_ne
propel103714063p_ropel
propene112716043p_ropene
proper104319953p_roper
prose75835123p_ro_se
prosed94921093p_rosed
proser84223463p_roser
proses84733473p_roses
protea82214763p_rotea
protege1059153p_rotege
protei82615313p_rotei
prove104823193p_ro_ve
proved125016033p_roved
proven114314773p_roven
prover113819723p_rover
proves114322253p_roves
prower114218123p_rower
prowled13309913p_rowled
prowler123310013p_rowler
puree74632843pur__ee
purfle112511183purfl_e
purfled13248733purfled
purfler12248733purfler
purfles122511843purfles
purled94520753pur_led
purple102712683purpl_e
purpled12299783purpled
purpler11289273purpler
purples112712833purples
pyrogen1337353pyrogen
pyrola1139003pyrol_a
pyrolas1239863pyrolas
pyrolize2248133pyrolize
pyrolyze2554143pyrolyze
pyrone112714473pyro_ne
pyrones123113303pyrones
pyrope132810533pyro_pe
pyropes142210193pyropes
pyroxene2045083pyroxene
pyrrole1246033pyrrol_e
pyrroles1345453pyrroles
role45851823__rol_e
roles56747983__roles
safrole1037253safrol_e
safroles1136933safroles
saree55044663sar__ee
sarode75317513saro_de
sarodes84216143sarodes
saroses73619333saroses
sparkle133710213sparkl_e
sparkled15317733sparkled
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
tartlet72218483tartlet
variole10711593variol_e
varioles11711123varioles
varlet9423503var_let
warble113516603warbl_e
warbled133212163warbled
warbler123211463warbler
warbles123215563warbles
warsle93112923warsl_e
warsled112910443warsled
warsler10289893warsler
warsles103413643warsles

Search took 8 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.436409841.7
2DLD Change Limit1340273567.11018850.5
3Display Results3563560.1262825.4
 (SQL Overall)1786913567.67223291.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.