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

406 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
pros6574278(None) 
bros65635661bros
eros45238451eros
poos65949111poos
praos74923561praos
pro55837261pro_
proa66229961proa
proas75028801proas
prod76129501prod
prods85523551prods
prof96134661prof
profs105120891profs
prog75729001prog
progs86624151progs
prom87631691prom
proms95426401proms
prop85932811prop
props95726881props
prose75835121prose
proso77222411proso
pross76529401pross
prost75434101prost
prosy106319251prosy
prow97030381prow
prows106327011prows
pyros105718291pyros
abos67734412abos
ados57633512ados
apos65433822apos
apres75426402apres
apron7318832apron
aprons8316992aprons
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
arks85936872arks
arms66137492arms
arose55832082arose
ars37670932ar_s
arts49650262arts
arvos86015662arvos
avos77227012avos
bios66335312bios
biros75325132biros
boos67955032boos
bos57966812_bos
bras65746452bras
brios74725722brios
bris65539612bris
bro56236602bro_
broo65129822broo
broos75126412broos
brose75227032brose
brosy106115382brosy
brow97228442brow
brows105425982brows
ceros74726072ceros
coos67456492coos
cors66656442cors
cos510270392_cos
cris66233432cris
croc85723732croc
crocs95722432crocs
crop87628632crop
crops96125232crops
cross75124502cross
crow96428132crow
crows105727312crows
crus65828482crus
dors56747602dors
dos48062312_dos
drop75324402drop
drops85719502drops
dross65418092dross
drys86314802drys
duos56728132duos
duros65422692duros
egos55821652egos
epos66723732epos
eras45441502eras
ergs55523812ergs
erns45428222erns
erose55727272erose
errs45622532errs
ers36046282er_s
euros54920242euros
faros85532022faros
fro65530642fro_
froe75329992froe
froes86126692froes
frog85624362frog
frogs96220772frogs
from96923922from
frons86124042frons
frosh115713402frosh
frost84727832frost
frow106425052frow
frows116623102frows
giros65722652giros
goos57644912goos
gos47155132_gos
grog65923342grog
grogs76319412grogs
grok95819682grok
groks105716122groks
gross65421692gross
grosz154814092grosz
grot55942052grot
grots65025852grots
grow86127302grow
grows95523922grows
gyros95616482gyros
heros84930862heros
hos68364192_hos
ires45639282ires
iris45732542iris
irks86220132irks
iron46728462iron
irons55324132irons
kors85933012kors
kos76944822_kos
kris86423602kris
loos49051122loos
mhos95517772mhos
moos66051302moos
mors65950062mors
mos57067122_mos
naos47429732naos
nos38859322_nos
onos46229002onos
orbs66626252orbs
orcs67025432orcs
ordos65216202ordos
ores46056682ores
ors35750112or_s
orts46538332orts
orzos143311252orzos
os211359882__os
pacs85842182pacs
pads76742952pads
pals66951352pals
pams85641762pams
pans65855722pans
paps86443452paps
paras76143042paras
pards85634332pards
pareos87023772pareos
pares77164482pares
pargos95719042pargos
paris75145942paris
parks116134462parks
parol74826272parol
parols84722612parols
parous84024162parous
parrs75928672parrs
pars67560792pars
parts77743372parts
parvos116614752parvos
pas58775742p_as
pass65239952pass
pats66460852pats
paws96038182paws
pays95940222pays
peas65755062peas
pecs84634102pecs
pedros9312182pedros
peds75835242peds
pees65257372pees
pegs75531762pegs
pehs95625762pehs
pens65649642pens
peon65635242peon
peons75327182peons
pepos96620082pepos
peps85134512peps
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
pes57259782p_es
peso66925822peso
pesos77221622pesos
pets66248332pets
pews95731532pews
pharos11312062pharos
phis95724902phis
phon95925382phon
phons105221142phons
phot95534352phot
phots105418492phots
pias66542552pias
pics85633912pics
pies66949602pies
pigs76634222pigs
pins65558452pins
pion67235292pion
pions75826392pions
pious74621272pious
pips85837132pips
pirns76020092pirns
pirog83913672pirog
pis56362032p_is
piso66727562piso
pisos76021062pisos
piss65033332piss
pits66348742pits
plod76723272plod
plods85719292plods
plop86625742plop
plops95920332plops
plot66141232plot
plots75025672plots
plow95923232plow
plows105419902plows
ploy96123602ploy
ploys105816592ploys
plus66324832plus
pod66351482p_od
pods76540152pods
poh86740532p_oh
poi57244662p_oi
pois66539042pois
pol56449382p_ol
polos76129912polos
pols66044562pols
pom78249912p_om
pomos95321582pomos
poms87037742poms
pons65850602pons
poo57757112p_oo
pood75934322pood
poods85124752poods
poof95541662poof
poofs105222792poofs
pooh96027382pooh
poohs103915712poohs
pool65835952pool
pools74427702pools
poon67341262poon
poons75430972poons
poop86532812poop
poops94422412poops
poor65630222poor
pop76252252p_op
pops86340952pops
pore66451262pore
pores75849032pores
pork106929682pork
porks115124142porks
porn65636022porn
pornos85015252pornos
porns75527342porns
porose84818742porose
porous84419482porous
port66059632port
ports75934592ports
pose66441732p_ose
posh95427322p_osh
post67953362p_ost
posy96028422p_osy
pot58078432p_ot
pots66452362pots
pow87147282p_ow
pows95537662pows
pox126140692p_ox
pram85733492pram
prams96125512prams
prao66229022prao
prase76128752prase
prat65952042prat
prats76333392prats
prau66529472prau
praus74621752praus
pray96331532pray
prays105022432prays
pree67044732pree
prees75937172prees
preop94715872preop
preops104911932preops
prep86427672prep
preps96220692preps
presa74319042presa
prese75228382prese
press75425952press
prest75736352prest
prex135722972prex
prey96228482prey
preys105717782preys
prez156126312prez
pries74339532pries
prig75924872prig
prigs85219702prigs
prim85132202prim
primos104514422primos
prims95425932prims
prion75119992prion
prions84317782prions
prior74316172prior
priors83914482priors
prise74632612prise
prism94820262prism
priss74623892priss
probe94320812probe
probes104119452probes
proem94818272proem
proems104711162proems
prole74527792prole
proles84627202proles
promo95619992promo
promos105116422promos
prone75332622prone
prong85218112prong
prongs94314482prongs
proof105221532proof
proofs114511682proofs
prosed94921092prosed
proser84223462proser
proses84733472proses
prosit85124592prosit
prosos85718552prosos
proud84615482proud
prove104823192prove
proves114322252proves
prowl105615122prowl
prowls115511082prowls
proxy175011012proxy
pry85728052pr_y
psis68120342psis
psoas75012982psoas
pubs85029212pubs
puds75630512puds
pugs76332772pugs
puls65437562puls
puns66641482puns
pups86032232pups
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042purs
pus55547842p_us
puss64830132puss
puts65641752puts
pyas96225702pyas
pyes95528992pyes
pyres105523882pyres
pyro96019392pyro_
ras37575392_ras
repros84216002repros
res35565042_res
rhos76319062rhos
rob56754302_rob
robs65837872_robs
roc520243252_roc
rocs65533662_rocs
rod47953892_rod
rods56442062_rods
roe36861072_roe
roes45954132_roes
rom59855632_rom
roms67038962_roms
rose46148902_rose
rosy76024872_rosy
rot37282952_rot
rots46454092_rots
row67453672_row
rows75941752_rows
saros55238062saros
sos37761602_sos
sris45434152sris
taos45541002taos
taros55640822taros
tiros54524892tiros
toros54336192toros
tors46157382tors
tres46542902tres
trios55528092trios
trod57627952trod
trog57628212trog
trogs67022602trogs
trois57226092trois
trop66833302trop
trot46351312trot
trots56629942trots
trow78031422trow
trows88826182trows
troy77429682troy
troys86418612troys
twos76718022twos
tyros85118592tyros
udos56619902udos
updos8389512updos
uprose82311482uprose
urbs65922052urbs
urds55922422urds
urns46323892urns
urps66920472urps
urus46426132urus
vrow105817472vrow
vrows116115262vrows
woos76238802woos
wos66953532_wos
zeros144918102zeros
zoos135828802zoos

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 Filter178691298720.1561145455.1
2DLD Change Limit298724061.82616359.3
3Display Results4064060.1862182.8
 (SQL Overall)1786914062.16882422.0
 
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.