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

317 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
peroxy183824(None) 
proxy175011011p_roxy
deoxy1648882de_oxy
desoxy1744622desoxy
epoxy17465772_epoxy
parody12410092parody
peony105717562pe_ony
perdy115417322per_dy
perky145319482per_ky
peroxid17310262peroxid
perry105222712per_ry
pertly115312542pertly
phenoxy2243482phenoxy
poxy166820892p__oxy
prexy174611572p_rexy
prosy106319252p_rosy
xerox1138622xerox_
aerify122810113aerify
aerily93017013aerily
aero45435343aero__
aerobe8412403aerobe
aery77231683aer__y
alkoxy2033343alkoxy
apery106517903aper__y
arrowy12288273arrowy
barony115915303barony
berry104521773ber_ry
betony114211583betony
boxy166420733__boxy
braxy175410893_braxy
brosy106115383_brosy
cero66329453cero__
ceros74726073cero_s
cerous85821203cerous
chromy16309903chromy
corody12149703corody
crony105918673_crony
decoy115716313deco_y
deray95024183der_ay
derby114715343der_by
derry94721373der_ry
detox13310953detox_
dexy156118553de__xy
doxy156419953__doxy
ebony104511513_ebony
eerily92913563eerily
eery76129623eer__y
erode64520993_erode
eros45238453_ero_s
erose55727273_erose
ethoxy1933923ethoxy
euroky1334823euroky
felony123710323felony
ferity122813343ferity
ferly115517353fer_ly
ferny115816183fer_ny
ferry116020803fer_ry
foxy176517753__foxy
germy115113663ger_my
grody103412063_grody
herby134715313her_by
hereby14468333hereby
heresy125011233heresy
hero74635783hero__
heroes94923823heroes
heroic113516923heroic
heroin94420593heroin
heron85025503hero_n
heronry1346043heronry
herons94820543herons
heros84930863hero_s
herry114922473her_ry
hydroxy2454263hydroxy
irony85015903_irony
jerky196712423jer_ky
jerry155016183jer_ry
jersey1636333jersey
kerry124916093ker_ry
kersey1336783kersey
lemony11419553lemony
leprosy1244223leprosy
melody1237203melody
memory1338803memory
mercy125916183mer_cy
merely111312583merely
merry104721483mer_ry
methoxy2243943methoxy
nerdy95014703ner_dy
nerol51017813nero_l
neroli61111153neroli
nerols6914883nerols
nervy114610863ner_vy
operon8811773opero_n
operons91411743operons
operose939433operose
oxy136320983___oxy
pardy115523953par_dy
parity114719873parity
parlay113713993parlay
parley116718353parley
parol74826273paro_l
parole84425253parole
parols84722613parols
paronym1437503paronym
parous84024163parous
paroxysm2242733paroxysm
parroty1247863parroty
parry105323753par_ry
partly116315473partly
party106630613par_ty
peachy164510843peachy
peaky145718153pe_aky
pearly116414843pearly
peartly1267453peartly
peaty105725693pe_aty
peavey14398793peavey
peavy135014843pe_avy
pebbly1545083pebbly
pecky165515093pe_cky
pedro8313153pedro__
pedros9312183pedro_s
peery105719443pe_ery
pegbox1844013pegbox_
pekoe114612363peko_e
pekoes124410423pekoes
pelon74423213pelo_n
pelota8612833pelota
peltry11288653peltry
penny105119453pe_nny
penury1148103penury
peon65635243pe_o_n
peons75327183pe_ons
pepo87622153pepo__
pepos96620083pepo_s
peppy114310363pe_ppy
per56353093per___
perch124518833per_ch
percoid12312313percoid
perdie94718513perdie
perdu84216273per_du
perdue93912633perdue
perdus93711273perdus
pere66450263per__e
perea75026443per_ea
pereia85217983pereia
pereon83517453pereon
pereons92815003pereons
peres76246643per_es
perfidy1635263perfidy
perform1439273perform
perfumy1763933perfumy
pergola1067623pergola
peri65636973per__i
peril75425953per_il
perils84121853perils
period9314983period
periods10312243periods
peris75537073per_is
perish114619063perish
periti8319953periti
perjury19244253perjury
perk106232843per__k
perked134617683perked
perkily1637803perkily
perks115325803per_ks
perm85834633per__m
permed115217343permed
permit10321683permit
perms95524513per_ms
pernio8513143pernio
pernod9310453pernod
pernods1038483pernods
peroral9314793peroral
peroxide1848173peroxide
peroxids1837443peroxids
perp89029893per__p
perps95521483per_ps
perron83216623perron
perrons93115483perrons
perse75429523per_se
perses85428063perses
person83517873person
persona92812453persona
persons93717013persons
pert66759323per__t
perter84422283perter
peruke123210393peruke
peruse84016843peruse
perv97224813per__v
pervs105117373per_vs
pesky145911563pe_sky
peso66925823peso__
pesos77221623peso_s
pesty106421713pe_sty
petrify1536573petrify
petrol82714063petro_l
petrols92913083petrols
petrous92714423petrous
petty105320293pe_tty
peyote1139853peyote
peyotl1146233peyotl
phlox1737333phlox_
phony136715443p_hony
phooey14379233phooey
pierogi1054723pierogi
piracy1339473piracy
pirog83913673piro_g
pirogi9299013pirogi
pixy166117763p__ixy
ploy96123603p_lo_y
poboy121612223pobo_y
pogy105623553p__ogy
poky135922153p__oky
poly96235153p__oly
pony96434053p__ony
poofy136213273p_oofy
poorly1137893poorly
porgy116916123por_gy
porky145019333por_ky
porny106020193por_ny
porose84818743porose
porous84419483porous
portly114713403portly
posy96028423p__osy
pox126140693p__ox_
pray96331533p_r_ay
prebuy1357423prebuy
predry1237863predry
preop94715873preo_p
preops104911943preops
prepay13310313prepay
preppy1235523preppy
prerock1536723prerock
pretty11510873pretty
prex135722973p_rex_
prey96228483p_r_ey
pricy124814563p_ricy
priory114110263priory
privy13439833p_rivy
pro55837263p_ro__
proa66229963p_ro_a
proas75028803p_roas
probe94320813p_robe
prod76129503p_ro_d
prods85523553p_rods
proem94818273p_roem
prof96134663p_ro_f
profs105120893p_rofs
prog75729003p_ro_g
progs86624153p_rogs
prole74527793p_role
prom87631703p_ro_m
promo95620003p_romo
proms95426413p_roms
prone75332623p_rone
prong85218113p_rong
proof105221533p_roof
prop85932813p_ro_p
props95726883p_rops
propyl13358183p_ropyl
pros65742783p_ro_s
prose75835123p_rose
proso77222413p_roso
pross76529403p_ross
prost75434103p_rost
protyl11308213p_rotyl
proud84615483p_roud
prove104823193p_rove
prow97030383p_ro_w
prowl105615123p_rowl
prows106327013p_rows
pry85728053p_r__y
ptooey11346413ptooey
purely114013623purely
purify14399153purify
purity114114913purity
purply13369043purply
pursy105016413pur_sy
purty105019403pur_ty
purvey14559573purvey
pyrex175211213pyrex_
pyro96019393pyro__
pyrola1139003pyrola
pyrone112714473pyrone
pyrope132810533pyrope
pyros105718293pyro_s
rebody1238153rebody
recopy1339043recopy
redox134714233redox_
reroll6412683reroll
reroof9315003reroof
rerose63320843rerose
ropy96323413__ropy
rosy76024873__rosy
sepoy10314303sepo_y
serosa6313023serosa
serous65023563serous
serow86720443sero_w
serows96016393serows
serry84824123ser_ry
sexy146418023se__xy
stroy87720393stro_y
tepoy10312163tepo_y
termly1138433termly
terry84721873ter_ry
troy77429683_tro_y
verify153110163verify
verily122616053verily
verity123714853verity
very108025643ver__y
xeroxed14244513xeroxed
xeroxes13246443xeroxes
zero134822473zero__
zeroed16409413zeroed
zeroes154314343zeroes
zeros144918113zero_s
zeroth1837963zeroth

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163175.81319390.3
3Display Results3173170.1102881.8
 (SQL Overall)1786913176.06329472.4
 
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.