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

423 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
prospers12301226(None) 
propers113619031pro_pers
prosers94219641pros_ers
prosper114012191prosper_
crispers12309432crispers
croppers143311482croppers
crosiers103312062crosiers
crossers103912702crossers
droppers13318602droppers
graspers11338402graspers
gropers104813852gro_pers
grossers94410972grossers
groupers11358642groupers
poppers103414862p_oppers
posers84223972p_os_ers
posters93928012p_osters
pressers103215022pressers
presters103419002presters
probers113514582pro_bers
prodders1237462prodders
proffers16126592proffers
proggers12258162proggers
prompters1537552prompters
proofers13118362proofers
propels113412842pro_pels
proper104319952pro_per_
proser84223462pros_er_
proses84733472pros_e_s
prosier93817482prosier_
prospect1447892prospect
prospects1545102prospects
prospered1446972prospered
prosperous1445472prosperous
prosses94019512prosse_s
provers123817792pro_vers
prowlers13328932prowlers
raspers94415922_raspers
rompers113412242_rompers
ropers84325902_ro_pers
rosters73727542_rosters
troopers10289442troopers
troupers10359442troupers
apposers1236283appos_ers
arousers84810983arousers
aspers86220313__aspers
bloopers12397373bloopers
boosters104013443boosters
boppers133911923_boppers
brasiers103710513brasiers
broiders114211193broiders
broilers103210093broilers
brokers133111913bro_kers
bronzers19296983bronzers
brooders112610243brooders
broses86524403bros_e_s
brothers133410833brothers
browsers13449203browsers
brushers134210573brushers
chompers17369593chompers
choppers174110463choppers
claspers124410913claspers
closers94415323clos_ers
coopers114019483_coopers
copers104629843_co_pers
coppers133519753_coppers
coshers123618183_coshers
costers94128333_costers
crappers144011023crappers
crashers134013233crashers
creepers12318633creepers
crimpers14318933crimpers
crispens12286253crispens
crisper113511053crisper_
croakers14288523croakers
crofters13358903crofters
crooners103911393crooners
cropper133312963cropper_
crosier94116573crosier_
crosser95015463crosser_
crosses94220793crosse_s
croupes114613103croupe_s
croupiers1334653croupiers
crowders14398813crowders
crowers124614903cro_wers
crowners133710753crowners
crozers184111083cro_zers
croziers19287003croziers
cruppers14317323cruppers
crushers134010093crushers
dopers95522483_do_pers
dorpers104113173_dorpers
dorsers83516303dors_ers
dosers75723633_dos_ers
dossers84516233_dossers
drapers105313353dr_apers
dressers9359863dressers
drippers13327943drippers
droners84114383dro_ners
dropper12329873dropper_
drosera836203dros_era
droseras935873dros_eras
drosses84513823drosse_s
drovers115212643dro_vers
drowners12428273drowners
elopers95112943elo_pers
erasers74413943eras_ers
eroses65327053eros_e_s
floppers15337463floppers
flossers11307863flossers
fosters104220103_fosters
friskers15337373friskers
frosteds12305653frosteds
frothers14279813frothers
frowners14377933frowners
gaspers105014133_gaspers
glossers9319053glossers
gospels1035593_gospels
grasper10389793grasper_
gripers104011463gr_ipers
grippers13358133grippers
gristers94013403gristers
groaners9248503groaners
grocers103511253gro_cers
groomers11388483groomers
groovers12337123groovers
groper94517253gro_per_
gropes95220403gro_pe_s
grosser84313143grosser_
grosses84517683grosse_s
grouper104210093grouper_
grousers93810733grousers
grouters95910083grouters
growers113612723gro_wers
growlers12327093growlers
hoopers123616483_hoopers
hopers114222973_ho_pers
hoppers143115143_hoppers
hosers95223963_hos_ers
hosiers104212643_hosiers
ironers74813553iro_ners
jaspers164310463_jaspers
joshers174111593_joshers
koshers144811803_koshers
lispers94514323_lispers
loopers93914033_loopers
lopers84424143_lo_pers
loppers113014103_loppers
losers65123583_los_ers
mopers104220373_mo_pers
moppers133412463_moppers
moshers124017843_moshers
mossers94116193_mossers
noosers74913923noos_ers
noshers103614333_noshers
oosperm1134883_oosperm
oosperms1243793_oosperms
opposers1244973oppos_ers
osiers63412793__osiers
pampers133615933p_ampers
papers105125323p__apers
parsers94118153pars_ers
passers94717753p_assers
pasters94531733p_asters
paupers114311073p_aupers
pausers94113223paus_ers
peepers113713673p_eepers
pensters103012123pensters
peoplers1237163peoplers
peppers103311443p_eppers
perusers10328803perus_ers
pesters93827093p_esters
phosphors1976543phosphors
piasters102912813piasters
pilsners1035533pilsners
pioneers1035863pioneers
pipers104318663p__ipers
pishers123815753p_ishers
pissers95014753p_issers
plashers133813453plashers
plasters103518133plasters
plodders1235523plodders
plotters104011553plotters
plovers123611833plo_vers
plowers123812243plo_wers
plumpers14357293plumpers
poisers94214433p_oisers
pokers124617923p_o_kers
polders103617373p_olders
polers84225643p_o_lers
pollers93420023p_ollers
ponders103618843p_onders
poofters1336923poofters
poolers94217423p_oolers
popery134511703p_o_pery
popes95933813p_o_pe_s
popper93615963p_opper_
poppets10338853p_oppets
porkers134314933p_orkers
porters93722703p_orters
poser75128773p_os_er_
poses74642763p_os_e_s
poseurs9378293p_oseurs
posher115018163p_osher_
posies84431433p_osie_s
posses85128803p_osse_s
possess9419123p_ossess
possets94212773p_ossets
poster84129173p_oster_
postern93615613p_ostern
posterns102713723p_osterns
pothers123818623p_others
potters94024343p_otters
potzers184010543p_otzers
pourers93513673p_ourers
pouters94221873p_outers
powders134111553p_owders
powers113822323p_o_wers
powters124015663p_owters
praisers103410833praisers
prancers123210333prancers
prases84429023pras_e_s
praters94921653pr_aters
prawners1346003prawners
prayers124212853pr_ayers
preavers13910263preavers
preeners102712813preeners
prefers123713333pr_efers
preggers12236833preggers
premiers122911653premiers
preorders1235403preorders
presagers1236943presagers
presets94216423pres_ets
presiders1248213presiders
presser93717623presser_
presses93523153presse_s
pressors103212693pressors
prester93519623prester_
presumers1336373presumers
preyers124412363pr_eyers
pricers113915063pr_icers
prickers163710673prickers
priers84521193pr__iers
primers114215673pr_imers
prinkers143010383prinkers
printers103214903printers
prisere9310943pris_ere
priseres10310823pris_eres
prises84133173pris_e_s
prisoners1147373prisoners
prisses94816713prisse_s
prizers183911843pr_izers
prober104516073pro_ber_
probes104119453pro_be_s
problems1434343problems
proceeds1335983proceeds
process11310403pro_cess
processers1446003processers
proctors12311513proctors
procurers1345033procurers
procures1239213procures
prodder1147953prodder_
producers1454883producers
proems104711163pro__ems
profaners14256213profaners
profess1237713pro_fess
proffer15126933proffer_
profilers14236293profilers
profiters14228313profiters
progger11319373progger_
progress1137023progress
projets1639163pro_jets
prolegs10379993pro_legs
proles84627203pro_le_s
promisers13268203promisers
promoters13310093promoters
prompter1437983prompter_
prompts1337473promp_ts
proofer12149103proofer_
propel103714063pro_pe_l
propend123311273pro_pend
propends13249173pro_pends
propene112716043pro_pene
propenes122816513pro_penes
propense122410103pro_pense
properer1259203pro_perer
properest1349663pro_perest
properly1546463pro_perly
property1547073pro_perty
prophets1539503prophets
propjets1935493propjets
proposers13228523proposers
propped113311953proppe_d
props95726883pro_p__s
propyls14308193pro_pyls
prosateurs1243063prosateurs
prose75835123pros_e__
prosect11313393pros_ect
prosects1239473prosects
prosed94921093pros_e_d
prosiest10416523prosiest
prosiness11311683prosiness
prosomas1249723prosomas
prosos85718553pros__os
prospectors1754583prospectors
prospectus1643413prospectus
prospering1547173prospering
prosperity1754513prosperity
pross76529403pros___s
prossies101515223prossies
prosties101421193prosties
proteas92015123pro_teas
protesters12169383protesters
proteus92511593pro_teus
prouder10310383prouder_
prover113819723pro_ver_
proverb14378213pro_verb
proverbs15315583pro_verbs
proves114322253pro_ve_s
providers1535593providers
provokers1894203provokers
prower114218123pro_wer_
prowess1237903pro_wess
prowler123310013prowler_
proxies163014933proxie_s
pruners93710723pr_uners
pryers115012243pr__yers
ptoses83514673ptos_e_s
pulpers114612283p_ulpers
pulsers94213153puls_ers
pumpers133113673p_umpers
punsters103310583punsters
pursers93916093purs_ers
pursuers10376523pursuers
pushers123814503p_ushers
pyoses114314303pyos_e_s
pyropes142210193pyro_pe_s
rapers84327183_r_apers
rappers113618443_rappers
rasers64526783_ras_ers
rashers104020913_rashers
rasper83917333_rasper_
rasters74629023_rasters
reapers93520453_reapers
resters74130403_resters
rippers114115033_rippers
risers64624783_ris_ers
riskers114011993_riskers
roamers93713463_roamers
roarers73812743_roarers
roasters83615933_roasters
robbers112814163_robbers
rockers133916553_rockers
rogers74517913_ro_gers
roisters83615553_roisters
rolfers104011813_rolfers
rollers73117473_rollers
romper104213683_romper_
roofers105013903_roofers
roomers95416413_roomers
roosers74217873_roosers
roosters83514663roosters
rooters74522933_rooters
roper75431913_ro_per_
ropery114313873_ro_pery
ropes75940063_ro_pe_s
rosery93813283_ros_ery
roses56445773_ros_e_s
rosets65819953_ros_ets
rosier64221263_rosier_
roster64329083_roster_
rotters74421393_rotters
rousers75220143_rousers
rousters84315683_rousters
routers74822873_routers
rovers95423523_ro_vers
rowers94924573_ro_wers
roysters113610533_roysters
rozzers1535633_rozzers
rushers103816103_rushers
scoopers124210193scoopers
shoppers153010763shoppers
slopers94213093slo_pers
snoopers10319843snoopers
soapers93715923_soapers
stompers123610043stompers
stoopers103711303stoopers
stopers94217373sto_pers
stoppers123910593stoppers
stroppers1356713stroppers
swoopers13317523swoopers
topers85025323_to_pers
toppers113914603_toppers
tossers74713503_tossers
trampers123210393trampers
trappers123711043trappers
trashers113013643trashers
trippers123210163trippers
troffers14125433troffers
trollers83211213trollers
trompes114111623trompe_s
trooper94210363trooper_
tropes84824353tro_pe_s
trotters83310243trotters
trouper93811433trouper_
troupes94112853troupe_s
trousers83910633trousers
trovers103713323tro_vers
trowsers11428003trowsers
trussers8348283trussers
trusters83112263trusters
trysters11298373trysters
uprisers10206773upris_ers
uprooters1164253uprooters
vespers1239033_vespers
whispers16266993whispers
whoopers16286263whoopers
whoppers18297533whoppers
wrappers15306933wrappers
wresters112711733wresters
wrongers12327773wrongers
zoosperm2142933zoosperm
zoosperms2242613zoosperms
zosters163015413_zosters

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.453394461.4
2DLD Change Limit1461624236.82621412.5
3Display Results4234230.1732445.1
 (SQL Overall)1786914237.45223978.9
 
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.