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 “propers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
propers11361903(None) 
gropers104813851gropers
probers113514581probers
propels113412841propels
proper104319951proper_
prosers94219641prosers
prospers123012261prospers
provers123817791provers
ropers84325901_ropers
brokers133111912brokers
coopers114019482coopers
copers104629842_copers
croppers143311482croppers
crowers124614902crowers
crozers184111082crozers
dopers95522482_dopers
dorpers104113172dorpers
drapers105313352drapers
droners84114382droners
droppers13318602droppers
drovers115212642drovers
elopers95112942elopers
gripers104011462gripers
grocers103511252grocers
groper94517252groper_
gropes95220402grope_s
groupers11358642groupers
growers113612722growers
hoopers123616482hoopers
hopers114222972_hopers
ironers74813552ironers
loopers93914032loopers
lopers84424142_lopers
mopers104220372_mopers
pampers133615932pampers
papers105125322p_apers
paupers114311072paupers
peepers113713672peepers
peoplers1237162peoplers
peppers103311442peppers
pipers104318662p_ipers
plovers123611832plovers
plowers123812242plowers
pokers124617922p_okers
polers84225642p_olers
poolers94217422poolers
popery134511702p_opery
popes95933812p_ope_s
poppers103414862poppers
porkers134314932porkers
porters93722702porters
posers84223972p_osers
powers113822322p_owers
praters94921652praters
prayers124212852prayers
prefers123713332prefers
preyers124412362preyers
pricers113915062pricers
priers84521192pr_iers
primers114215672primers
prizers183911842prizers
prober104516072prober_
probes104119452probe_s
process11310402process
prodders1237462prodders
proems104711162pro_ems
profess1237712profess
proffers16126592proffers
proggers12258162proggers
projets1639162projets
prolegs10379992prolegs
proles84627202prole_s
prompters1537552prompters
proofers13118362proofers
propel103714062prope_l
propend123311272propend
propends13249172propends
propene112716042propene
propenes122816512propenes
propense122410102propense
properer1259202properer
properest1349662properest
properly1546462properly
property1547072property
prophets1539502prophets
propjets1935492propjets
proposers13228522proposers
props95726882prop__s
propyls14308192propyls
proser84223462proser_
proses84733472prose_s
prosper114012192prosper_
proteas92015122proteas
proteus92511592proteus
prover113819722prover_
proverb14378212proverb
proverbs15315582proverbs
proves114322252prove_s
prower114218122prower_
prowess1237902prowess
prowlers13328932prowlers
pruners93710722pruners
pryers115012242pr_yers
pulpers114612282pulpers
pumpers133113672pumpers
pyropes142210192pyrope_s
rapers84327182_rapers
rogers74517912_rogers
rompers113412242_rompers
roper75431912_roper_
ropery114313872_ropery
ropes75940062_rope_s
rovers95423522_rovers
rowers94924572_rowers
slopers94213092slopers
stopers94217372stopers
topers85025322_topers
troopers10289442troopers
tropes84824352trope_s
troupers10359442troupers
trovers103713322trovers

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711213.29632667.2
3Display Results1211210.0333666.7
 (SQL Overall)1786911213.70248268.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.