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

191 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
protyles1324983(None) 
prostyles14157111prostyles
protyle12229451protyle_
protyls12298461protyl_s
pottles93816982p_ottles
prattles10189402prattles
pretypes15337262pretypes
profiles133211232profiles
proles84627202pro__les
propyls14308192propyl_s
prostyle13187272prostyle_
protases102115032protases
proteges1149922proteges
protyl11308212protyl__
trotyls10236032trotyl_s
urostyles12173972urostyles
argyles1136053ar_gyles
biotypes1544683biotypes
bottles94216273_bottles
brattles10199333brattles
brittles10178653brittles
brothels13277073brothels
cerotypes1644733cerotypes
cotypes1437943_cotypes
crotches153411303crotches
dottles83912283_dottles
ecotypes1545053ecotypes
epistyles1454143epistyles
erotizes17311213erotizes
footles103715713foot_les
grottoes9276753grottoes
groynes1137823gro_ynes
hoyles12315013_ho_yles
isotypes13234853isotypes
motiles93317433_motiles
mottles93415803_mottles
neotypes1344523neotypes
odyles10348563__odyles
pantiles103617153pantiles
paroles95025883paro__les
pentyls1236523pentyl_s
peoples11312223peo_ples
peristyles1543863peristyles
pestles93217693pest_les
pettles93916483p_ettles
pintles94118723pint_les
pistoles102514723pistoles
plotless10256793plot_less
plotties103111413plotties
plotzes18317703plot_zes
poles75351003p_o__les
poodles103013513p_oodles
popples103011873p_opples
portables1337873portables
portages112613223portages
portaled11239203portaled
portals94015563portal_s
portholes14410373portholes
portless10310643port_less
posoles9314883p_osoles
potables12179703p_otables
potages102416423p_otages
potholes13312933p_otholes
potpies113116173p_otpies
potsies93019483p_otsies
potties93723543p_otties
pottle84416103p_ottle_
pozoles1839063p_ozoles
prates84633163prat__es
prattle9208833prattle_
prattled11246533prattled
prattler10166343prattler
prattlers11195323prattlers
prefiles133113443prefiles
presales10315263presales
pretapes122811533pretapes
pretells1047333pretells
pretties10615133pretties
pretype14387483pretype_
pretyped16306123pretyped
pretzels1934033pretzels
prickles162511093prickles
probables1545433probables
probates12414283probates
probes104119453pro__bes
problem1335983pro_blem
problems1434343pro_blems
procures1239213procures
produces1347903produces
proettes10312763proettes
profanes132311573profanes
profile123211153profile_
profiled14338523profiled
profiler13287643profiler
profilers14236293profilers
prole74527793pro__le_
proleg94612113pro__leg
prolegs10379993pro__legs
prolines102619693prolines
promines123018803promines
promises122916763promises
promotes12314123promotes
promulges1443383promulges
pronates10418373pronates
propanes122415823propanes
propels113412843propel_s
propenes122816513propenes
propines122618933propines
propolis12311403propolis
propones122516963propones
proposes122515973proposes
proptoses1349873proptoses
propyl13358183propyl__
propyla14296633propyl_a
propylaea1643243propylaea
propylene1644453propylene
propylenes1744373propylenes
propylic1747183propylic
propylites1746303propylites
propylon1544873propylon
prorates10418073prorates
proses84733473pro__ses
prosses94019513pro_sses
prossies101515223prossies
prostates11314423prostates
prosties101421193prosties
protasis102411973protasis
protea82214763prot__ea
proteans102811543proteans
proteas92015123prot_eas
protease10209893protease
proteases112110833proteases
protects1239743protects
protege1059153protege_
protegee1156963protegee
protegees1275393protegees
protei82615313prot__ei
proteides12238783proteides
proteids11259943proteids
proteins102114283proteins
protends113010353protends
proteomes13248653proteomes
proteose10229413proteose
proteoses112211013proteoses
protest9317533prot__est
protests10310493protests
proteus92511593prot_eus
proteuses11238993proteuses
protheses1449073protheses
protists10313363protists
protiums1238553protiums
protons93118003prot_ons
prototypes1745923prototypes
protoxylem2462583protoxylem
protoxylems2551953protoxylems
protrudes1245173protrudes
proves114322253pro__ves
provides1439883provides
provokes1776603provokes
prowled13309913pro_wled
prowler123310013pro_wler
prowlers13328933pro_wlers
prowls115511083pro_wl_s
proxies163014933pro_xies
pustules1038443pustules
puttyless1442013puttyless
pyrolyses1745583pyrolyses
pyrolyzes2644293pyrolyzes
rattles73217303_rattles
restyles1139193restyles
retiles74426993_retiles
retypes12308623_retypes
robles85321693_ro_bles
roles56747983_ro__les
rootles73215633_rootles
rotates72819773_rotates
rotches123515703_rotches
rotes56143903_rot__es
rotls55620163_rot_l_s
rottes64524833_rot_tes
roubles93413513_roubles
rutiles74315843_rutiles
serotypes1445323serotypes
sprattles1174883sprattles
styles94418653__styles
throttles1254353throttles
tootles72915603toot_les
trotyl9236673trotyl__
troubles1057203troubles
urodeles945563urodeles
urostyle11173953urostyle_

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621916.59622159.2
3Display Results1911910.0762513.2
 (SQL Overall)1786911917.07525256.7
 
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.