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

207 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
protyls1229846(None) 
propyls14308191propyls
protyl11308211protyl_
protyle12229451protyle
protyles13249831protyles
trotyls10236031trotyls
pentyls1236522pentyls
portals94015562portals
propels113412842propels
propyl13358182propyl_
propyla14296632propyla
prostyle13187272prostyle
prostyles14157112prostyles
proteas92015122proteas
proteus92511592proteus
protons93118002protons
prowls115511082pro_wls
rotls55620162_rot_ls
trotyl9236672trotyl_
acetyls12285353acetyls
artels66216233ar_tels
aryls87015813ar__yls
botels84815803_botels
broils84114173bro_ils
bromals1139743bromals
brothels13277073brothels
broths115013923brot_hs
butyls1176753_butyls
chromyls18244733chromyls
cresyls1234753cresyls
crotons93714373crotons
dactyls1333913dactyls
dicotyls1444183dicotyls
drolls75312393dro_lls
drools74412813dro_ols
epicotyls1642583epicotyls
erotics91914153erotics
formyls15235703formyls
frontals1146273frontals
froths125411443frot_hs
grots65025853grot__s
grottos8337333grottos
grovels11427813grovels
growls104711113gro_wls
hotels94515513_hotels
mortals93914003mortals
motels83616893_motels
nonyls957853_nonyls
octyls11135323_octyls
odyls9428653__odyls
parols84722613paro__ls
paronyms1546553paronyms
parotids112610413parotids
pastels95215183pastels
pastils94416173pastils
pentyl1138813pentyl_
petals84719813p_etals
peyotls1233633peyot_ls
phenyls1534333phenyls
photics142810483photics
photogs13358213photogs
photons123814433photons
photos113316643phot_os
phots105418503phot__s
phytols15276553phytols
pistils93314303pistils
pistols93213983pistols
platys11459853platy_s
plots75025673plot__s
plotzes18317703plotzes
ploys105816593plo_y_s
polls74627723p_o_lls
pols66044563p_o__ls
polyols1238493p_olyols
polyps13479763p_olyps
polys105718763p_oly_s
pontils9312213pontils
pools74427703p_o_ols
portal84218463portal_
porters93722703porters
portly114713403port_ly
ports75934593port__s
postals93716373postals
potfuls1236293p_otfuls
pothos114214693p_othos
pots66452363p_ot__s
pottle84416103p_ottle
pottles93816983p_ottles
pottos84615873p_ottos
praters94921653praters
prates84633163prat_es
prats76333393prat__s
prattle9208833prattle
prattles10189403prattles
prays105022433pr_ay_s
pretell938243pretell
pretells1047333pretells
pretold1049083pretold
pretors9316813pretors
pretype14387483pretype
pretypes15337263pretypes
pretzels1934033pretzels
preys105717783pr_ey_s
prills84015613pr_ills
proas75028803pro__as
probers113514583probers
probes104119453pro_bes
probits112712573probits
process11310403process
proctors12311513proctors
prods85523553pro__ds
proems104711163pro_ems
proettes10312763proettes
profess1237713profess
profile123211153profile
profiles133211233profiles
profits122911243profits
profs105120893pro__fs
progs86624153pro__gs
projets1639163projets
prolans9314273prolans
prole74527793pro__le
prolegs10379993prolegs
proles84627203pro_les
prologs103512133prologs
promos105116423pro_mos
prompts1337473prompts
proms95426413pro__ms
pronely12310253pronely
prongs94314483pro_ngs
proofs114511683pro_ofs
propel103714063propel_
propers113619033propers
propolis12311403propolis
props95726883pro__ps
propylic1747183propylic
propylon1544873propylon
pros65742783pro___s
prosers94219643prosers
proses84733473pro_ses
prosily12611633prosily
prosos85718553pro_sos
pross76529403pro__ss
prosses94019513prosses
prosties101421193prosties
prosy106319253prosy__
protases102115033protases
protasis102411973protasis
protea82214763prot_ea
protean92412193protean
proteans102811543proteans
protease10209893protease
protect11313633protect
protects1239743protects
protege1059153protege
proteges1149923proteges
protei82615313prot_ei
proteid103513673proteid
proteids11259943proteids
protein92414733protein
proteins102114283proteins
protend104012793protend
protends113010353protends
proteose10229413proteose
protest9317533protest
protests10310493protests
protist9320223protist
protists10313363protists
protium11312293protium
protiums1238553protiums
protocols1347203protocols
proton84318893prot_on
proudly1336333proudly
provers123817793provers
proves114322253pro_ves
prowess1237903prowess
prowl105615123pro_wl_
prows106327013pro__ws
proxies163014933proxies
proxy175011013proxy__
ratals64219583_ratals
ratels64518213_ratels
roils54826793_ro_ils
rolls55326233_ro_lls
rotas54827723_rot_as
rotes56143903_rot_es
rotis56327063_rot_is
rotl45029683_rot_l_
rotors64917953_rotors
rotos56027883_rot_os
rots46454093_rot__s
rottes64524833_rottes
rowels94515453_rowels
royals93711263_royals
sotols63714473_sotols
tolyls9436963_tolyls
totals63115163_totals
trolls64613943tro_lls
troths95414153trot_hs
trots56629943trot__s
trowels10358363trowels
troys86418613tro_y_s
uprootals1142643uprootals
uranyls1034453uranyls
urostyle11173953urostyle
urostyles12173973urostyles
zlotys18374173zloty_s

Search took 7 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.390458182.1
2DLD Change Limit1340272076.42320866.7
3Display Results2072070.0633285.7
 (SQL Overall)1786912076.87625987.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.