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

429 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
prolegs1037999(None) 
proleg94612111proleg_
proles84627201prole_s
prologs103512131prologs
parolees104313982parolees
paroles95025882parole_s
piolets93513192piolets
poleis86018352p_oleis
polers84225642p_olers
poles75351002p_ole_s
poolers94217422poolers
probers113514582probers
probes104119452probe_s
problems1434342problems
process11310402process
proems104711162pro_ems
profess1237712profess
progs86624152pro__gs
projets1639162projets
prolans9314272prolans
prole74527792prole__
prolog94212972prolog_
prolongs11347612prolongs
prongs94314482pro_ngs
propels113412842propels
propers113619032propers
prosers94219642prosers
proses84733472prose_s
proteas92015122proteas
protege1059152protege
proteges1149922proteges
proteus92511592proteus
provers123817792provers
proves114322252prove_s
prowess1237902prowess
prowlers13328932prowlers
roles56747982_role_s
amoles84122193amole_s
anoles64827433anole_s
apologs1038593apologs
areoles71016953areole_s
argles75218483argle_s
arles56735743ar_le_s
armless9369943armless
armlets94610063armlets
artless73712513artless
azoles154614613azole_s
boles75448603_bole_s
bootlegs11325873bootlegs
bowlegs13366823bowlegs
braless92910563braless
broilers103210093broilers
brokers133111913brokers
bromes104719763brome_s
broses86524403brose_s
browless1346653browless
carolers103314173carolers
cholers124215203cholers
coles76055063_cole_s
coleus86818273_coleus
cologs96517353_cologs
coolers93522493coolers
creoles9913323creole_s
crones84729243crone_s
cropless1237793cropless
crores86121163crore_s
crowers124614903crowers
crozers184111083crozers
crozes174417663croze_s
dholes104914793dhole_s
doglegs1034783doglegs
doles67843753_dole_s
doolees83711613doolees
dregs76114863dr__egs
drolls75312393drol_ls
droners84114383droners
drones75023433drone_s
droplets1136063droplets
drovers115212643drovers
droves105116673drove_s
duologs935363duologs
egoless836983egoless
erodes74819883erode_s
eroses65327053erose_s
foleys123810463_foleys
forelegs1236613forelegs
froes86126693fro_e_s
froglets1235263froglets
frogs96220773fro__gs
frolics1236833frolics
gaolers83511563gaolers
golems939323_golems
grocers103511253grocers
grogs76319413gro__gs
gropers104813853gropers
gropes95220403grope_s
grovels11427813grovels
groves104318103grove_s
growers113612723growers
growlers12327093growlers
haoles94919803haole_s
holes84748653_hole_s
ireless72312243ireless
ironers74813553ironers
irones64724013irone_s
isologs837433isologs
joles125230833_jole_s
legs56133693___legs
midlegs1156323midlegs
moles74747923_mole_s
mooleys1236863mooleys
oboles83815833obole_s
oleos55419683__oleos
oles46453473__ole_s
orbless937493orbless
orioles7412993oriole_s
orles55326213or_le_s
orology11319463orology
padles95221123padle_s
pales75753803p_ale_s
palets85122313p_alets
pallets93919303pallets
parles86334403parle_s
parleys125212373parleys
parole84425253parole__
paroled104217633parole_d
parolee94119643parole_e
parols84722613parol__s
parsleys1335083parsleys
partlets102811513partlets
pedlers103013273pedlers
peelers93615593peelers
pegless1038053pegless
pegs75531763p___egs
peles75738083p_ele_s
pellets94014783pellets
peones83821043peone_s
peoplers1237163peoplers
peoples11312223people_s
phlegm1433093p_hlegm
phlegms1542373p_hlegms
phloems1433523phloems
phones114121213phone_s
phoneys15437143phoneys
photogs13358213photogs
piglets103311793piglets
piles74742613p_ile_s
pileus84514943p_ileus
pinoles93418703pinole_s
piolet83225643piole_t
pleas75627033p__leas
plebs95814583p__lebs
plews105415353p__lews
plotless10256793plotless
plovers123611833plovers
plowers123812243plowers
plugs85213493p__lugs
poems95715553p_o_ems
poets76024443p_o_ets
pogeys124110353p_ogeys
pokers124617923p_okers
pokes116133013p_oke_s
pokeys15529513p_okeys
polars84419353p_olars
polders103617373p_olders
pole65951303p_ole__
poleax1547993p_oleax
poled84934843p_ole_d
poler74431793p_ole_r
poleyn1157323p_oleyn
poleyns1236113p_oleyns
polies84034583p_olies
polios84019723p_olios
polis74731163p_ol_is
polkas1239103p_olkas
pollees93215333pollees
pollens93713303pollens
pollers93420023pollers
polls74627723p_ol_ls
polos76129913p_ol_os
pols66044563p_ol__s
polyps13479763p_olyps
polys105718763p_ol_ys
pomes94833933p_ome_s
pones74547043p_one_s
pongs85526343p_o_ngs
poodles103013513poodle_s
pooled94619813poole_d
pooler83819843poole_r
pools74427703pool__s
pooves113914713poove_s
popes95933813p_ope_s
pores75849033p_ore_s
porkers134314933porkers
porters93722703porters
portless10310643portless
posers84223973p_osers
poses74642763p_ose_s
posoles9314883posole_s
powers113822323p_owers
poxes145325723p_oxe_s
pozoles1839063pozole_s
prangs94816233pr_angs
prases84429023prase_s
praters94921653praters
prates84633163prate_s
praxes156215183praxe_s
prayers124212853prayers
prebless1236823prebless
precess11310863precess
preens85020113pr_eens
prees75937173pr__ees
prefers123713333prefers
prelect111013833prelect
prelects1299723prelects
prelegal1145053prelegal
prelims1139823prelims
premeds12389593premeds
prepregs13144763prepregs
preps96220693pr__eps
presets94216423presets
press75425953pr__ess
prexes154915953prexe_s
preyers124412363preyers
preys105717783pr__eys
prezes173614693preze_s
pricers113915063pricers
prices104524543price_s
prides94324183pride_s
priers84521193pr_iers
pries74339533pr_ie_s
prigs85219703pr__igs
prills84015613pril_ls
primers114215673primers
primes104225263prime_s
prioress1035393prioress
prises84133173prise_s
privets122910053privets
prizers183911843prizers
prizes173819813prize_s
proas75028803pro__as
probangs13256213probangs
probe94320813probe__
probed114114823probe_d
prober104516073probe_r
probits112712573probits
problem1335983proble_m
proceed12310553proceed
proceeds1335983proceeds
prodders1237463prodders
prodigy1435573prodigy
prodrugs1242483prodrugs
prods85523553pro__ds
proem94818273pro_e_m
proffers16126593proffers
profilers14236293profilers
profiles133211233profile_s
profits122911243profits
profs105120893pro__fs
prog75729003pro__g_
progeny1389463progeny
progged12409803progged
progger11319373progger
proggers12258163proggers
progress1137023progress
project1838453project
projects1936413projects
projet15315183proje_t
prolan8414693prol_an
prolapse12134913prolapse
prolate9419793prolate
prolepses13126193prolepses
prolepsis13125063prolepsis
proline92321593proline
prolines102619693prolines
prolix1538683prol_ix
prologed12189213prologed
prologist12315083prologist
prologue1146833prologue
prologues1246903prologues
prolong10319633prolong
prolonge11388403prolonge
prolonges12337923prolonges
promos105116423pro_mos
prompts1337473prompts
proms95426413pro__ms
promulges1443383promulges
prone75332623prone__
pronely12310253pronely
prong85218113pro_ng_
pronged113912393pronged
proofers13118363proofers
proofs114511683pro_ofs
propel103714063prope_l
propend123311273propend
propends13249173propends
propene112716043propene
propenes122816513propenes
propense122410103propense
proper104319953prope_r
prophets1539503prophets
propjets1935493propjets
props95726883pro__ps
propyls14308193propyls
pros65742783pro___s
prose75835123prose__
prosect11313393prosect
prosects1239473prosects
prosed94921093prose_d
proser84223463prose_r
prosos85718553pro_sos
prospers123012263prospers
pross76529403pro__ss
prosses94019513prosses
protea82214763prote_a
protean92412193protean
proteans102811543proteans
protease10209893protease
protect11313633protect
protects1239743protects
protegee1156963protegee
protegees1275393protegees
protei82615313prote_i
proteid103513673proteid
proteids11259943proteids
protein92414733protein
proteins102114283proteins
protend104012793protend
protends113010353protends
proteose10229413proteose
protest9317533protest
protests10310493protests
protons93118003protons
protyles13249833protyle_s
protyls12298463protyls
prove104823193prove__
proved125016033prove_d
proven114314773prove_n
prover113819723prove_r
proverb14378213proverb
proverbs15315583proverbs
prower114218123prowe_r
prowest12311533prowest
prowled13309913prowle_d
prowler123310013prowle_r
prowls115511083pro_wls
prows106327013pro__ws
proxies163014933proxies
prudes94215443prude_s
pruners93710723pruners
prunes83419063prune_s
pryers115012243pr_yers
ptoses83514673ptose_s
pulers83820283p_ulers
pules74538813p_ule_s
pullers93618483pullers
pullets94015163pullets
pulleys12399143pulleys
purflers13216963purflers
purfles122511843purfle_s
purples112712833purple_s
pusleys12286233pusleys
putlogs1065083putlogs
pyoses114314303pyose_s
pyrogens1437293pyrogens
pyrolas1239863pyrol_as
pyrology17136823pyrology
pyrones123113303pyrone_s
pyropes142210193pyrope_s
pyrroles1345453pyrrole_s
rales54947493_rale_s
redlegs936823redlegs
regs55436573_r__egs
relets64025673_relets
repegs93311943_repegs
riles55343643_rile_s
robes75133303_robe_s
robles85321693_roble_s
rodeos75314503_rodeos
rodes614039083_rode_s
rodless8310073_rodless
roes45954143_ro_e_s
rogers74517913_rogers
role45851823_role__
rolfers104011813_rolfers
rolfs84817123_rol_fs
rollers73117473_rollers
rolls55326233_rol_ls
romeos84013173_romeos
ropers84325903_ropers
ropes75940063_rope_s
roses56445773_rose_s
rosets65819953_rosets
rotes56143903_rote_s
rouens64814443_rouens
roues56039353_roue_s
rouges76022383_rouges
rovers95423523_rovers
roves84834483_rove_s
rowels94515453_rowels
rowens94515303_rowens
rowers94924573_rowers
rulers64317093_rulers
rules55234253_rule_s
soles55547923_sole_s
soleus64615613_soleus
spoolers10349363spoolers
stoles63927673stole_s
tholes94919783thole_s
toles55147133_tole_s
toolers74416503toolers
triolets83410143triolets
trogs67022603tro__gs
trokes104019263troke_s
trollers83211213trollers
trolleys11315693trolleys
trolls64613943trol_ls
trones65629283trone_s
tropes84824353trope_s
trovers103713323trovers
troves94719113trove_s
trowels10358363trowels
urology11217583urology
violets102210003violets
voles86234043_vole_s
wholes124616773whole_s
woolens10398843woolens
woolers104214023woolers
wrongs10338933wro_ngs

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.423422437.4
2DLD Change Limit1340274297.06318975.9
3Display Results4294290.1562750.0
 (SQL Overall)1786914297.64223382.8
 
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.