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

530 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
prosper11401218(None) 
proper104319951pro_per
proser84223461pros_er
prosier93817481prosier
prospers123012251prospers
crisper113511052crisper
cropper133312962cropper
crosier94116572crosier
crosser95015462crosser
dropper12329872dropper
grasper10389782grasper
groper94517252gro_per
grosser84313142grosser
grouper104210092grouper
popper93615962p_opper
poser75128772p_os_er
posher115018162p_osher
poster84129172p_oster
presser93717622presser
prester93519622prester
prober104516072pro_ber
prodder1147952prodder
proffer15126932proffer
progger11319372progger
prompter1437982prompter
proofer12149102proofer
propel103714062pro_pel
propers113619032pro_pers
propped113311952propped
prose75835122pros_e_
prosed94921092pros_ed
prosers94219642pros_ers
proses84733472pros_es
prospect1447892prospect
prospered1446962prospered
prosses94019512prosses
prouder10310372prouder
prover113819722pro_ver
prower114218122pro_wer
prowler123310012prowler
rasper83917322_rasper
romper104213682_romper
roper75431912_ro_per
rosier64221262_rosier
roster64329082_roster
trooper94210352trooper
trouper93811412trouper
apposer1147483appos_er
arose55832083aros_e_
arouser74514423arouser
artsier768943artsier
aruspex1642543aruspex
asper75520433__asper
blooper11358533blooper
booster94314553booster
bopper123813833_bopper
bosker123813653_bosker
brasher124515233brasher
brasier94516753brasier
brisker134210293brisker
broader103412603broader
broider103912973broider
broiler92911753broiler
broker124314243bro_ker
bronzer18348493bronzer
brooder103811623brooder
brose75227033bros_e_
broses86524403bros_es
brother123311333brother
browner124911643browner
browser124911143browser
brusher123813003brusher
brusker13437853brusker
chomper163810073chomper
chopper163611893chopper
clasper113811863clasper
closer84918203clos_er
cooper104221123_cooper
coper95336093_co_per
copper124321893_copper
cosher114819903_cosher
cosier84423753_cosier
coster84331293_coster
crapper133913193crapper
crasher124616153crasher
crasser94114333crasser
creeper11339973creeper
crimper136510423crimper
crisped124010103crisped
crispen11348203crispen
crispers12309433crispers
crispier12297253crispier
croaker133010683croaker
crofter12299573crofter
crooker134111093crooker
crooner93714043crooner
cropped143812063cropped
croppers143311483croppers
crosiers103312053crosiers
crosse85216303crosse_
crossed105313893crossed
crossers103912693crossers
crosses94220793crosses
croupe105114433croupe_
croupes114613103croupes
croupier1246883croupier
crowder13389843crowder
crower114117553cro_wer
crowner124012593crowner
crozer175112843cro_zer
crozier18369933crozier
crupper13338563crupper
crusher124412323crusher
doper86128393_do_per
dorper94314563_dorper
dorser74819173dors_er
doser66228563_dos_er
dosser74417973_dosser
draper94315693dr_aper
dresser83611953dresser
dripper12349223dripper
droller84110283droller
droner74717673dro_ner
drooped11368433drooped
droopier1145573droopier
dropped13329283dropped
droppers13318593droppers
drosera836203dros_era
drosses84513823drosses
drossier956313drossier
drover104614593dro_ver
drowner11369803drowner
drowsier1284903drowsier
eloper85414153elo_per
eraser64216333eras_er
erose55727273eros_e_
eroses65327053eros_es
flopper14328473flopper
flosser10339693flosser
foster94322223_foster
fresher132612643fresher
frisker14389273frisker
fronter103611583fronter
frosted113211873frosted
frostier1148163frostier
frother133110153frother
frowner13429683frowner
frowsier1444893frowsier
gasper94515543_gasper
glosser83410813glosser
goosier83512563goosier
gorsier83811073gorsier
gospel936533_gospel
grasped11409063grasped
graspers11338393graspers
griper94114613gr_iper
gripper124410713gripper
grister83915413grister
groaner82510133groaner
grocer94212143gro_cer
grodier939673grodier
groomer10399873groomer
groover11358543groover
grope84821613gro_pe_
groped107515053gro_ped
gropers104813853gro_pers
gropes95220403gro_pes
grossed93812253grossed
grossers94410973grossers
grosses84517683grosses
grosze16457733grosze_
grouped11419193grouped
groupers11358633groupers
grouser84513693grouser
grouter84412523grouter
grower104614933gro_wer
growler11318973growler
hooper114518313_hooper
hoper105829143_ho_per
hopper134218483_hopper
horsier103013243horsier
hoser811529763_hos_er
hosier94219613_hosier
improper1444533impro_per
ironer64216443iro_ner
jasper154610383_jasper
josher164312963_josher
kosher134412973_kosher
kroner104612573kro_ner
lisper84114433_lisper
looper83817113_looper
looser65219943loos_er
loper75129233_lo_per
lopper103717203_lopper
loser54728673_los_er
moper94925923_mo_per
mopper126215003_mopper
mosher114719793_mosher
mosser84618273_mosser
nooser65517823noos_er
nosher94616363_nosher
nosier63716323_nosier
oosperm1134883_oosperm
opposer1135773oppos_er
osier53518013__osier
pamper124316663p_amper
paper95128663p__aper
parser84822373pars_er
passer84721033p_asser
paster85734373p_aster
pauper103511943p_auper
pauser84415963paus_er
peeper103614803p_eeper
penster92811953penster
peopler1138073peopler
pepper93512943p_epper
perspex1834173perspex
peruser93511373perus_er
pester84827593p_ester
phonier122710633phonier
phosphor1865093phosphor
piaster93012883piaster
pilsner935343pilsner
pioneer936883pioneer
piper96523193p__iper
pisher114317753p_isher
pisser84416383p_isser
plasher124215033plasher
plaster93318693plaster
plodder1146003plodder
plopped11288773plopped
plotter94113663plotter
plover115312613plo_ver
plower114315063plo_wer
plumper13318773plumper
plusher124010383plusher
poiser84217243p_oiser
poker115122883p_o_ker
pokier124914633p_okier
polder94019253p_older
poler74431793p_o_ler
poller83921853p_oller
ponder94521693p_onder
poofter1237163poofter
pooler83819843p_ooler
pooped113915943p_ooped
poorer82613993p_oorer
pope85535613p_o_pe_
popery134511703p_o_pery
popes95933813p_o_pes
popped104117813p_opped
poppers103414863p_oppers
poppet92717323p_oppet
porker124917543p_orker
porkier133712343porkier
pornier93413123pornier
porose84818743poros_e_
porter84224413p_orter
pose66441733p_os_e_
posed85828413p_os_ed
posers84223973p_os_ers
poses74642763p_os_es
poseur8419403p_oseur
posies84431433p_osies
posse74722273p_osse_
posses85128803p_osses
posset84923253p_osset
posted93722493p_osted
postern93615603p_ostern
posters93927993p_osters
pother113818853p_other
potter83926983p_otter
potzer174411203p_otzer
pourer84516043p_ourer
pouter83923983p_outer
powder123611903p_owder
power105325953p_o_wer
powter114116033p_owter
poxier153812113p_oxier
praiser93413943praiser
prancer113613383prancer
prase76128753pras_e_
prases84429023pras_es
prater84825353pr_ater
prawner1246803prawner
prayer114815293pr_ayer
preaver121011613preaver
preener93114833preener
prefer113813203pr_efer
premier113515633premier
preorder1136463preorder
prepped11329893prepped
preppier1156643preppier
presager1138443presager
prese75228383pres_e_
preset84430983pres_et
presider11410423presider
pressed103317303pressed
pressers103215023pressers
presses93523153presses
pressor93512873pressor
presters103419003presters
presumer1247583presumer
preyer114413733pr_eyer
pricer103918293pr_icer
pricier113313113pricier
pricker154013413pricker
prier75027763pr__ier
primer105118683pr_imer
primmer134310163primmer
primped14479153primped
prinker133412743prinker
printer93917303printer
prise74632613pris_e_
prised94322203pris_ed
prisere9310943pris_ere
prises84133173pris_es
prisoner1048573prisoner
prissed103311263prissed
prisses94816713prisses
prissier10157873prissier
privier122910453privier
prizer174714883pr_izer
probe94320813pro_be_
probed114114823pro_bed
probers113514573pro_bers
probes104119453pro_bes
problem1335983problem
proceed12310543proceed
processer1346893processer
proctor11310433proctor
procure1138573procure
procurer1235833procurer
prodded1257733prodded
prodders1237453prodders
producer1355843producer
proem94818273pro__em
profaner13197943profaner
proffers16126593proffers
profiler13287643profiler
profiter132710203profiter
progged12409793progged
proggers12258163proggers
projet15315183pro_jet
prole74527793pro_le_
proleg94612113pro_leg
proles84627203pro_les
promiser122510673promiser
promoed12310083promoed
promoter12311453promoter
prompt12313013promp_t
prompted1536903prompted
prompters1537533prompters
prompts1337473prompts
prone75332623pro_ne_
pronged113912393pronged
proofed13138723proofed
proofers13118363proofers
prop85932813pro_p__
propels113412843pro_pels
propend123311273pro_pend
propene112716043pro_pene
properer1259203properer
properly1546453pro_perly
property1547073pro_perty
prophet14316033prophet
propjet1839913propjet
propmen1338763propmen
proposer121810633proposer
props95726883pro_p_s
propyl13358183pro_pyl
pros65742783pros___
prosaic11311163prosaic
prosateur1143573prosateur
prosect11313393prosect
prosiest10416523prosiest
prosily12611633prosily
prosing103319383prosing
prosit85124593pros_it
proso77222413pros__o
prosody1336433prosody
prosoma11310223prosoma
prosos85718553pros_os
prospector1644363prospector
prospects1545103prospects
prospering1547173prospering
prosperity1754513prosperity
prosperous1445463prosperous
pross76529403pros__s
prossie91812953prossie
prossies101515223prossies
prost75434103pros__t
prostie91617743prostie
prosties101421193prosties
prosy106319253pros__y
protea82214763pro_tea
protei82615303pro_tei
protester111510483protester
prove104823193pro_ve_
proved125016033pro_ved
proven114314773pro_ven
proverb14378213pro_verb
provers123817793pro_vers
proves114322253pro_ves
provider1436703provider
provoker1784913provoker
prowar114110943pro_war
prowled13309903prowled
prowlers13328933prowlers
proxies163014933proxies
pruner83413453pr_uner
pryer104415313pr__yer
ptoses83514673ptos_es
pulper103513273p_ulper
pulser84215193puls_er
pumper124415553p_umper
punster92911103punster
purser85020473purs_er
pursier94012753pursier
pursuer9338893pursuer
pusher114318283p_usher
pussier93711993pussier
pyoses114314303pyos_es
pyrope132810533pyro_pe_
pyropes142210193pyro_pes
raper74932753_r_aper
rapper104621573_rapper
raser55633413_ras_er
rasher95024113_rasher
rasped94715203_rasped
raspers94415913_raspers
raspier93110633_raspier
raster64731443_raster
reaper84223143_reaper
rester63832433_rester
riper74328403_r_iper
ripper103518653_ripper
riser55431053_ris_er
risker105414493_risker
roamer84715163_roamer
roarer63914333_roarer
roaster74116663_roaster
robber103916533_robber
rocker124319573_rocker
roger64521413_ro_ger
roister73516203_roister
rolfer94412273_rolfer
roller63919793_roller
romped114513653_romped
rompers113412243_rompers
roofer94415283_roofer
roomer84718633_roomer
rooser63921883_rooser
rooster74415173rooster
rooter64926033_rooter
rope65542913_ro_pe_
roped84630803_ro_ped
ropers84325903_ro_pers
ropery114313873_ro_pery
ropes75940063_ro_pes
ropey106021873_ro_pey
ropier84118803_ropier
rose46148903_ros_e_
rosed65930343_ros_ed
rosery93813283_ros_ery
roses56445773_ros_es
roset55945243_ros_et
rosters73727533_rosters
rotter64325463_rotter
rouped95717353_rouped
roupet84218343_roupet
roupier9319493_roupier
rouser65224083_rouser
rouster73517083_rouster
router65025843_router
rover85527373_ro_ver
rower85430493_ro_wer
royster103110533_royster
rozzer1437353_rozzer
rusher94019653_rusher
scooper113812033scooper
shopper143312623shopper
sloper84615913slo_per
snooper93511533snooper
soaper84517873_soaper
stomper114111223stomper
stooper93813183stooper
stoper84320093sto_per
stopper113012593stopper
stropper1247753stropper
swooper12389173swooper
toper75231023_to_per
topper103817603_topper
tosser64215663_tosser
tramper113812153tramper
trapper113912793trapper
trasher104416123trasher
tripper113711923tripper
troffer13125863troffer
troller73913173troller
trompe105611263trompe_
tromped124210293tromped
trompes114111623trompes
trooped104010723trooped
troopers10289423troopers
trope75725803tro_pe_
tropes84824353tro_pes
trotter73312253trotter
troupe84812433troupe_
trouped103910973trouped
troupers10359423troupers
troupes94112843troupes
trouser73812463trouser
trover95014663tro_ver
trusser74010253trusser
truster73114313truster
tryster10369513tryster
upriser9218763upris_er
uprooter1085243uprooter
uprose82311483upros_e_
vesper1138083_vesper
whisper15298013whisper
whooper15297153whooper
whopper17328503whopper
worser95117523wors_er
wrapper14368333wrapper
wrester102812413wrester
wronger11288823wronger
zoosperm2142933zoosperm
zoster153715853_zoster

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.220812231.8
2DLD Change Limit1340275307.09318895.7
3Display Results5305300.1902789.5
 (SQL Overall)1786915307.50323815.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.