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

273 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
propyl1335818(None) 
propel103714061propel
propyla14296631propyla
propyls14308191propyls
protyl11308211protyl
prop85932812prop__
propels113412842propels
propenyl1544582propenyl
proper104319952proper
props95726882prop_s
propylic1747182propylic
propylon1544872propylon
prosy106319252prosy_
protyle12229452protyle
protyls12298462protyls
prowl105615122pro_wl
proxy175011012proxy_
ropy96323412_ropy_
trotyl9236672trotyl
apropos1138843apropos
aryl75922343ar__yl
atopy106813393atopy_
broil74918223bro_il
brolly114510853brolly
bromal10313653bromal
brosy106115383brosy_
chromyl17275233chromyl
copal95621783_copal
copy116229803_copy_
crepy124812703crepy_
cresyl1135133cresyl
crony105918673crony_
crop87628633crop__
crops96125233crop_s
croupy13458733croupy_
dopy106224153_dopy_
droll65415403dro_ll
drolly105411673drolly
drool65416103dro_ol
drooly104911073drooly
droopy12458243droopy_
drop75324403drop__
drops85719503drop_s
dropsy12497473dropsy
dropt86924433drop_t
formyl14276443formyl
goopy115816623goopy_
grapy115416433grapy_
gripy115115253gripy_
grody103412063grody_
grope84821613grop_e
groped107515053groped
groper94517253groper
gropes95220403gropes
grovel104310543grovel
growl96115823gro_wl
growly13499173growly
irony85015903irony_
isopropyl1651903isopropyl
loopy105316643loopy_
mopy115721973_mopy_
myopy15457353myopy_
nonyl849773_nonyl
nopal75517103_nopal
odyl84111463__odyl
opal66923523__opal
palpal104112053palpal
panoply1434713panoply
papal95820673p_apal
pappy114713803pappy_
parody12410093parody_
parol74826273paro__l
paronym1437503paronym
peepul1035783peepul
pentyl1138813pentyl
peony105717563peony_
people10310183people
peppy114310363peppy_
peroral9314793peroral
peroxy1838243peroxy_
phenyl1435323phenyl
phonal11310383phonal
phony136715443phony_
pimply15329213pimply
pipal95118353p_ipal
pipy115421513p_ipy_
plop86625743plop__
plops95920333plop_s
ploy96123603plo_y_
ploys105816593plo_ys
pogy105623553p_ogy_
poky135922153p_oky_
pol56449383p_o__l
poll66332133p_o_ll
poly96235153p_oly_
polyol1138713p_olyol
polyp125611533p_olyp
polys105718763p_olys
pony96434053p_ony_
poofy136213273poofy_
pool65835953p_o_ol
poop86532813poop__
pooped113915943pooped
poops94422413poop_s
poorly1137893poorly
pop76252253p_op__
pope85535613p_op_e
popes95933813p_opes
poppa8409893p_oppa
popple92710983p_opple
poppy114813193p_oppy
pops86340953p_op_s
popsy125713403p_opsy
porgy116916123porgy_
porky145019333porky_
porny106020193porny_
portal84218463portal
portly114713403portly
posy96028423p_osy_
poxy166820893p_oxy_
pray96331533pr_ay_
prays105022433pr_ays
preop94715873preop__
preops104911933preop_s
preoral9312673preoral
prep86427673prep__
prepay13310313prepay
prepays1437483prepays
prepill1147583prepill
preppy1235523preppy
preps96220693prep_s
prexy174611573prexy_
prey96228483pr_ey_
preys105717783pr_eys
pricy124814563pricy_
prill74117943pr_ill
primal104014623primal
primly13439623primly
priorly12335763priorly
priory114110263priory_
privy13439833privy_
pro55837263pro___
proa66229963pro__a
proas75028803pro_as
probe94320813pro_be
probed114114823probed
prober104516073prober
probes104119453probes
probit103218353probit
prod76129503pro__d
prods85523553pro_ds
proem94818273pro_em
proems104711163proems
prof96134663pro__f
profile123211153profile
profit113016273profit
profs105120893pro_fs
prog75729003pro__g
progs86624153pro_gs
progun968783progun
projet15315183projet
prolan8414693prolan
prole74527793pro_le
proleg94612113proleg
proles84627203proles
prolix1538683prolix
prolog94212973prolog
prom87631693pro__m
promo95619993pro_mo
promos105116423promos
prompt12313013prompt
promptly1743913promptly
prompts1337473prompts
proms95426403pro_ms
prone75332623pro_ne
pronely12310243pronely
prong85218113pro_ng
prongs94314483prongs
pronto8313993pronto
proof105221533pro_of
proofs114511683proofs
propane112716153propane
propend123311273propend
propene112716043propene
propenol1246473propenol
properly1546453properly
propers113619033propers
prophet14316033prophet
propine113020213propine
propjet1839913propjet
propman1339063propman
propmen1338763propmen
propolis12311403propolis
propone112716303propone
proposal1247743proposal
propose112714843propose
propped113311953propped
propria1149933propria
propylaea1643243propylaea
propylene1644453propylene
propylite1646713propylite
pros65742783pro__s
prose75835123pro_se
prosed94921093prosed
proser84223463proser
proses84733473proses
prosily12611633prosily
prosit85124593prosit
proso77222413pro_so
prosos85718553prosos
prosper114012183prosper
pross76529403pro_ss
prost75434103pro_st
prostyle13187273prostyle
protea82214763protea
protei82615303protei
proton84318893proton
protyles13249833protyles
proud84615483pro_ud
proudly1336323proudly
prove104823193pro_ve
proved125016033proved
proven114314773proven
prover113819723prover
proves114322253proves
prow97030383pro__w
prowar114110943prowar
prower114218123prower
prowls115511083prowls
prows106327013pro_ws
pry85728053pr__y_
pulpal10408453pulpal
pulpy124612363pulpy_
pupal97616873p_upal
pupil94712983p_upil
puppy114912413puppy_
purply13369043purply
pyrope132810533pyrop_e
pyropes142210193pyropes
repel74921403_repel
reply104015853_reply
roil46235293_ro_il
roily86121113_roily
roll46331653_ro_ll
rope65542913_rop_e
roped84630803_roped
roper75431913_roper
ropes75940063_ropes
ropey106021873_ropey
ropily113312443_ropily
rosy76024873_rosy_
rotl45029683_ro_tl
roupy106112713_roupy_
rowel84721413_rowel
royal85014703_royal
sapropel1244643sapropel
sporophyl19143843sporophyl
tolyl84710093_tolyl
triply114211023triply
troll54416533tro_ll
trolly94012353trolly
trop66833303trop__
trope75725803trop_e
tropes84824353tropes
trophy1438283trophy
tropic103014193tropic
tropin83316753tropin
trotyls10236033trotyls
trowel94211463trowel
troy77429683tro_y_
troys86418613tro_ys
uranyl936293uranyl
uropod937263uropod

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162737.89014285.9
3Display Results2732730.1561750.0
 (SQL Overall)1786912738.18921820.9
 
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.